Re: PRO*C & PL/SQL Stored procedure

From: Deepak Kumar <dgaur_at_ebay.sun.com>
Date: 2000/05/03
Message-ID: <39107175.470CEF72@ebay.sun.com>#1/1

David BARATTE wrote:

> Hello,
>
> Is it possible to pass a host array to a PL/SQL stored procedure as a
> parameter ?
> Remark : the call to the stored procedure is made from a PRO*C function.
>
> Of what type should be the IN parameters of the stored procedure ?
>
> Thanks in
> advance.

Hi David,

It is possible to pass host array to a PL/SQL stored procedure from a Pro *C

program. The procedure must be accepting parameter as PL/SQL Tables. If you are passingMulti Dimensional Array, the PL/SQL table should be created

based on the RECORD data type to accept this Array.

Thanks
Deepak Received on Wed May 03 2000 - 00:00:00 CDT