CODEWITHSUNDEEP
oracle-databaseora-00900
Sandy
Sandy

Reputation: 14135

ORA-00900: invalid SQL statement error

While running dbms command

execute dbms_utility.analyze_schema('MCC','ESTIMATE',30);

I got ORA-00900: invalid SQL statement error.

Can anyone tell me what could be the reason?

Upvotes: 2

Views: 23220

Answers (3)

Piyush
Piyush

Reputation: 23

You need to set the server output on before executing the procedure in SQL Developer. Kindly try below code:

SET SERVEROUTPUT ON;
execute dbms_utility.analyze_schema('MCC','ESTIMATE',30);

If you still get the same error then please open your SQL*PLUS and check if PLSQL is installed in it.

Upvotes: 0

dhananjay singh
dhananjay singh

Reputation: 1

In Oracle 10g people face ORA-0900 Invalid SQL statement. Solution is try to execute stored procedure by placing the stored procedure between BEGIN and END keywords.

begin
    stored_procedure_name(parameter);
end;

Upvotes: -1

FerranB
FerranB

Reputation: 36827

The execute sentence is only for SQL*Plus utility.

To call a PLSQL statement from the most of applications/languages you have to try some of the following, It depends on where you are playing:

Option 1. Without /.

begin
  dbms_utility.analyze_schema('MCC','ESTIMATE',30);
end;

Option 2. With /

begin
  dbms_utility.analyze_schema('MCC','ESTIMATE',30);
end;
/

Upvotes: 5

Related Questions