Re: call Oracle stored procedure

FC wrote:

> Oooops!
> You're right!
>
> ...execute <stored_procedure(arg1, arg2...argn)>
>
> sounds better ?
>
> Cheers,
> Flavio
>
> "Frank" <fbortel_at_home.nl> wrote in message news:3DF65717.8040608_at_home.nl...
> > FC wrote:
> > > Look at the "@" command in the SQL Plus User's Guide.
> > >
> > > You can find the docs here:
> > > http://tahiti.oracle.com/
> >
> >
> > That would be an external file.
> >
> > >
> > > "Jenny" <jwang_at_housing.tamu.edu> wrote in message
> > > news:at5db7$f38$1_at_news.tamu.edu...
> > >
> > >>Need to know how to make a call to Oracle stored procedure from SQL
> plus.
> > >>Thanks in advance!
> > >>
> > >>Jenny
> > >>jennyw_at_housing.tamu.edu
> > >>
> >
> > exec <procedure_name>. Oracle fixes that into:
> > begin
> > <procedure_name>
> > end;
> >
> > which you could type yourself, too.
> >
> > Grtz, Frank
> >

Depends on the procedure.

If no parameters or only IN parameters

BEGIN
   proc_name(p1, p2);
END;
/

But if IN and OUT params

DECLARE
   variable declarations
BEGIN
   proc_name(p1, p2, p3);
END;
/

Dan Morgan Received on Tue Dec 10 2002 - 17:43:38 CST