Error 00900 in stored procedure [message #927] |
Wed, 13 March 2002 10:12 |
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 |
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>
|
|
|