ORA-00900: invalid SQL statement - when starting a procedure in oracle 10g

Question

I am using an Oracle 10g database and trying to start a procedure using SQL commands.

create or replace procedure "exam" is begin DBMS_OUTPUT.PUT_LINE('Test'); end; 

Then click the Run button. It shows: "created procedure."

When I try to execute it using:

 execute exam; 

then click the “Run” button, it shows:

 ORA-00900: invalid SQL statement 

Thank you for your help.

Answer 1

Just noticed the detail in your question. You press the run button. Therefore, you should use an IDE.

You cannot use execute in the IDE - this is the sql*plus command. However, it can work in Oracle SQL Developer, but I would not use it there,

Try

 begin exam; end; 

Answer 2

Lose double quotes around the name. They do not work well in Oracle.

Answer 3

See: Syntax error when trying to call Oracle package using ODBC in C #

You must put "{" and "}" before the command. Example:

  processListCmd.CommandType = CommandType.StoredProcedure; processListCmd.CommandText = "{ call rep_invnr_proclist }"; processListCmd.ExecuteNonQuery();