Re: call Oracle stored procedure

From: FC <flavio_at_tin.it>
Date: Tue, 10 Dec 2002 21:13:59 GMT
Message-ID: <rOsJ9.2587$ab2.78427@news1.tin.it>

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
>
Received on Tue Dec 10 2002 - 15:13:59 CST