Home » SQL & PL/SQL » SQL & PL/SQL » Error 00900 in stored procedure
Error 00900 in stored procedure [message #927] Wed, 13 March 2002 10:12 Go to next message
LI810
Messages: 25
Registered: February 2002
Junior Member
Please help.

What is wrong ? I cannot create stored procedure . Have error message. Invalid SQL statement ora- 00900.

create or replace PROCEDURE NEW_USER.test
as

begin

dbms_output.put_line('1234');
end;
Re: Error 00900 in stored procedure [message #929 is a reply to message #927] Wed, 13 March 2002 10:29 Go to previous message
Grant
Messages: 578
Registered: January 2002
Senior Member
Worked for me. I added a "/" at the end and took off "NEW_USER.". Are you connected as NEW_USER? If not you have to have CREATE_ANY_PROCEDURE system priv to create it in another schema. But this worked for me.

SQL> set serverout on
SQL> set echo on
SQL> @t
SQL> create or replace PROCEDURE test
2 as
3
4 begin
5 dbms_output.put_line('1234');
6 end;
7 /

Procedure created.

SQL>
SQL> exec test
1234

PL/SQL procedure successfully completed.

SQL>
Previous Topic: EXP-00046
Next Topic: simple PL/SQL question 2
Goto Forum:
  


Current Time: Thu Oct 31 17:50:51 CDT 2024