User uses Create option to open Table Editor window and creates a table with a Date column having default value of SYSDATE. The Generate SQL icon is used to generate the Create statement. Created statement encloses SYSDATE word with single quotes and running this Create statement results in the following error: "ORA-01858: a non-numeric character was found where a numeric was expected"
WORKAROUND:
Modify script to remove single quotes prior to execution.
This issue is fixed in SQL Navigator 6.3 Beta release.
© 2021 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy