ORA-00900: invalid SQL statement error

oracle ora-00900
Sandeep Kumar picture Sandeep Kumar · Feb 27, 2010 · Viewed 18.9k times · Source

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?

Answer

FerranB picture FerranB · Feb 27, 2010

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;
/

Related questions

How to execute an oracle stored procedure?

I am using oracle 10g express edition. It has a nice ui for db developers. But i am facing some problems executing stored procedures. Procedure: create or replace procedure temp_proc is begin DBMS_OUTPUT.PUT_LINE('Test'); end it …

Read More
Problem with execute procedure in PL/SQL Developer

I this is my first attempt to create procedure and execute it. First I create simple table. DB scheme of table is here: Table name: Ziaci Columns: ZiakId - primary key, number Surname, varchar2 FirstName, varchar2 TriedaId - forgein key, …

Read More
Executing stored procedure in PL/SQL Developer SQL Window

I've used TOAD for awhile, but my dept has asked me to evaluate PL/SQL Developer as a possible change. I'm trying to run the following in PL/SQL developer. It gives an error saying: ORA-00900: Invalid SQL Statement VARIABLE …

Read More