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

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

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

Did this article solve an issue for you?

Select Rating

Title