SQL & PL/SQL

Hello,

I created a simple stored procedure in the procedure editor in TOAD. It's just a simple 'Hello World' output statement. Here is the code:

create or replace procedure new_proc is
greetings varchar2(20);
begin
greetings := 'Hello World';
dbms_output.put_line(greetings);
end;

The procedure created fine, but when I try to call it in the procedure editor or in the SQL Editor, both tools act as if the procedure cannot be found, and I get an error message.

In SQL Editor, I type in:

exec new_proc;

and it says that "new_proc" is invalid.

Does anyone know how to run this procedure in TOAD?

Thanks,

Peter

Message was edited by:
P. Swanson