Re: How to create stored procedure in SQLplus?

thx
I have tried but it said compiled with error

assume i have a table abc

create or replace procedure showabc is
begin
select * from abc;
end;
/

what is the problem ?

thanks again

"Connor McDonald" <connor_mcdonald_at_yahoo.com> ???????:3EB13413.7009_at_yahoo.com...
> 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"
Received on Thu May 01 2003 - 09:55:05 CDT