Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Trouble calling Stored Procedures from SQL*Plus! Please help!
Hi.
You have to "wrap" the call by PL/SQL block:
DECLARE
my_var1 <datatype>; my_var2 <datatype>; my_var3 <datatype>;
my_var2 || ' my_var3 = ' || my_var3 ); END; HTH. Michael
In article <ooeB5.317$6c3.6674_at_typhoon.mw.mediaone.net>,
"Kent P. Iler" <kent_at_iler.NOSPAM.com> wrote:
> Hi,
>
> Our DBA create this procedure to insert/update data in our tables.
I'm
> trying to verify it with SQL*Plus, but I can't get the syntax right.
Can
> someone please help?!
>
> The first 4 parameters are required, and the 3 output parameters.
There are
> a total of 136 parameters, but the others are set to "default" if they
> aren't passed.
>
> How do you specify output variables for the output parameters, and
call the
> stored procedure with SQL*Plus?
>
> If you would be willing to look at the code, I'll send you the Create
Table
> scripts and the Stored Procedure (didn't want to waste bandwidth).
If not,
> the correct syntax would be very helpful!
>
> Thank you for your help!
>
> -- Kent Iler
> ----------------------------------------------------------------------
> kent_at_iler.NOSPAM.com
> Please CC: all replies via e-mail
> Remove .NOSPAM from e-mail address
>
>
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Sat Sep 30 2000 - 01:18:04 CDT