ORA:00900 Invalid sql statement

maheswari picture maheswari · Dec 25, 2009 · Viewed 12.2k times · Source

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

Answer

OMG Ponies picture OMG Ponies · Dec 25, 2009

Use:

SQL>  alter procedure [your procedure name here] compile;
SQL>  show errors

...to be able to diagnose the issue from the resulting error output.