Invalid variant type conversion when running query with bind variables of date type (10689)

Chat now with support

Return

Feedback submitted.

Was this article helpful?

[Select Rating]

Title

Invalid variant type conversion when running query with bind variables of date type
Description

When I run a sql query in the sql editor that uses bind variables of date type then it errors with the following message:

<DD:MM:YY> Invalid variant type conversion.

For example:
SELECT :dt FROM DUAL;
Executing this with Scan statement for bound variables and set the type to DATE and the value to a valid date format it produces the error
Resolution

WORKAROUND
None

STATUS
Waiting for fix in a future release of SQL Navigator

Feedback submitted.

Was this article helpful?

[Select Rating]

Title