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
WORKAROUND
None
STATUS
Waiting for fix in a future release of SQL Navigator
© 2021 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy