PL/SQL table as IN parameter to stored proc [message #37071] |
Tue, 15 January 2002 12:48 |
Ed
Messages: 24 Registered: November 1999
|
Junior Member |
|
|
Hi,
Does anyone know if it is possible to pass a PL/SQL table (array) as an INPUT parameter to a stored proc via ADO and the OraOleDb.Oracle OLEDB provider? (I know there are are a couple of ways to OUPUT pl/sql tables or ref cursors, but I am looking for a way to pass it IN)..
I'd rather not use OO4O, so I'd prefer to get help from the ADO/OLE-DB angle.
Thanks.
|
|
|
Re: PL/SQL table as IN parameter to stored proc [message #37085 is a reply to message #37071] |
Wed, 16 January 2002 14:07 |
Suresh Vemulapalli
Messages: 624 Registered: August 2000
|
Senior Member |
|
|
Oraoledb or odbc drivers will not support passing pl/sql tables parameters. pass concatenated string with delimter and break it into pieces , store it in pl/sql table inside stored procedure or write generic stored procedure to do that task and call that generic stored procedure from original stored proc.
|
|
|
|
|