returning table rows from a stored proc through OCI

How do we bind a table of objects passed from a stored procedure in OCI?

Explanation:

1. We created the necessary types in the Oracle database

create type [Record_Type] as object (...); create type [Table_Type] as table of [Record_Type];

2. In a stored procedure we have the table type as an OUT procedure. create procedure [new_procedure] ( arg_table out [Table_Type]
)
..

arg_table(1) := Record_Type(...);
arg_table(2) := Record_Type(...);
..

3. This is the problem; we want to call the stored procedure in (2) and bind to the arg_table parameter that is passed back to through the OCI interface. We need to access the individual records inside. Has anybody done anything like this?

• Sent from RemarQ http://www.remarq.com The Internet's Discussion Network * The fastest and easiest way to search and participate in Usenet - Free!