While executing wrapped files in the Toad's Editor, the following oracle error occurs "ORA-00900 invalid SQL statement".
This is the wrong line in the code:
1;:
SQL *Plus is able to execute the wrapped file, no error appears.
Attached are the source and wrapped file. I
Toad Result:
Warning: PROCEDURE created with compilation errors.
ORA-00900: invalid SQL statement
SQL*Plus result:
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
Procedure created.
SQL>
WORKAROUND:
None
STATUS:
Issue fixed in version 9.5. The latest version of Toad for Oracle can be downloaded here.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center