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>
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center