Calling Oracle stored procedure that returns a pl/sql table

Topics: Data Access Application Block
Jul 11, 2007 at 7:54 PM
I am working on a new project where I am connecting to an oracle database. I need to know if I can call an Oracle stored procedure that returns a pl/sql table using enterprise library version 2.0
Jul 17, 2007 at 8:29 PM
The short answer is yes. However, that particular problem is addressed within Oracle PL/SQL syntax instead of the Enterprise Library Data Access Application Block. The following demonstrates how to implement returning a PL/SQL table as a reference cursor. It just so happens that the EntLib DAAB will see the output as just a regular reference cursor.

http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11QUESTIONID:246014735810

An alternative to the approach above are pipelined functions that were made available in Oracle 9i. Tom Kyte is a very respected individual in the Oracle community. Search his site and you're guaranteed to get a solid answer.

JB