ORA:00900 Invalid sql statement

Question

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 1

Use:

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

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

Answer 2

In Oracle SQL Developer you should execute it this way:

BEGIN
    YOUR_PROCEDURE(PARAM1, PARAM2);
END;

If you use EXECUTE or EXEC (which work in SqlPlus) you get the ORA-00900 error.

Answer 3

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.