Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to create stored procedure in SQLplus?
"Rookie" <fake_at_fake.com> wrote in message news:3eb1355b_at_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"
>
>
What is the error?
-- Steve Rainbird Principal consultant MSS International Ltd. www.mssint.com Remove "nospam" from email address to replyReceived on Thu May 01 2003 - 10:30:08 CDT