i created a procedure with 32 in argument,it sucessfully created.but when i am executing this in back end oracle the errror came ORA:00900 Invalid sql statement
+4
A:
Use:
SQL> alter procedure [your procedure name here] compile;
SQL> show errors
...to be able to diagnose the issue from the resulting error output.
OMG Ponies
2009-12-25 06:30:51
The ORA-900 indicates it's probably not the procedure itself, but the SQL he's using to call it; or, perhaps, the procedure is trying to execute some dynamic SQL. Either way show errors should not show anything, I think.
Jeffrey Kemp
2010-03-04 07:24:52
A:
Also look at view USER_ERRORS.
Sometimes, show errors does not show anything when in fact there are errors. Especially after alter compile.
Finally, re-compile in TOAD or SQL Developer and you can easily navigate to the error.
pj
2010-03-16 11:50:53