Re: How to create stored procedure in SQLplus?

Rookie wrote:
>
> Hi could some one show me how to create stored procedure in SQLplus, thx?
> either with param or without param. thanks in advance

SQL> create or replace procedure do_nothing is  2 begin
 3 null;
 4 end;
 5 /

SQL> create or replace procedure do_nothing(p_param in number) is  2 x number;
 3 begin
 4 x := p_param;
 5 end;
 6 /

hth
connor

-- 
=========================
Connor McDonald
http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue"