Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How to create stored procedure in SQLplus?

Re: How to create stored procedure in SQLplus?

From: Rookie <fake_at_fake.com>
Date: Fri, 2 May 2003 00:55:05 +1000
Message-ID: <3eb1355b@shknews01>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US