Re: Passing PL/SQL Table into Stored Proc from SQLPlus
From: Tan La <TLa_at_mtl.marconi.ca>
Date: 1996/07/10
Message-ID: <4s18gi$189_at_gateway.marconi.ca>#1/1
END; Hope this helps
Date: 1996/07/10
Message-ID: <4s18gi$189_at_gateway.marconi.ca>#1/1
In article <31e2d776.0_at_www.cerner.com>, gfriedrichsen_at_cerner.com says...
>
>I have created a Stored Procedure which has 3 scalar input
>parameters, and two PL/SQL Table input parameters. I have been
>unsuccessfull executing this from SQLPlus because I cannot
>find how to pass in the table parameters.
>
>Any help???
>
>
>
Why don't you create a script file and declare the PL/SQL Table input parameters, then execute the stored procedure within the script. Something like this:
Declare
TYPE MY_TABLE IS TABLE OF....
....
BEGIN
EXECUTE MY_PROC(...., MY_TABLE);
END; Hope this helps
Tan Received on Wed Jul 10 1996 - 00:00:00 CEST