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

Home -> Community -> Usenet -> c.d.o.tools -> Re: Trouble calling Stored Procedures from SQL*Plus! Please help!

Re: Trouble calling Stored Procedures from SQL*Plus! Please help!

From: Michael Bialik <michael_bialik_at_my-deja.com>
Date: Sat, 30 Sep 2000 06:18:04 GMT
Message-ID: <8r40iq$9sf$1@nnrp1.deja.com>

Hi.

 You have to "wrap" the call by PL/SQL block:

 DECLARE

   my_var1   <datatype>;
   my_var2   <datatype>;
   my_var3   <datatype>;

 BEGIN
   your_proc_name(1,2,3,4, my_var1, my_var2, my_var3);    dbms_output.put_line('--- my_var1 = ' || my_var1 || ' my_var2 = ' ||

        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

Original text of this message

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