Skip to Main Content
Forums

ODP.NET

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Support for Array Binding and PL/SQL tables (IN, INOUT, or OUT)

301617Sep 18 2002 — edited May 12 2003
I have attempted, unsuccessfully, to use array binding in stored procedure/function calls where the sp/sf has parameters that are PL/SQL tables. I have seen the topic floating around in this forum, but I have not seen the explicit questions:
- Does ODP.NET support PL/SQL tables as IN, INOUT or OUT parameters to stored procedures/functions?
- Will any planned ODP.NET release support PL/SQL tables as IN, INOUT or OUT parameters to stored procedures/functions?

I am aware that I can use REF CURSORS to handle the OUT situation, but I need to make a design decision concerning supporting parameters of IN and INOUT PL/SQL tables.

Thanks.
James

Comments

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jun 9 2003
Added on Sep 18 2002
#odp-net
4 comments
375 views