Calling Oracle stored procedure that returns a pl/sql table

Topics: Data Access Application Block
Jul 11, 2007 at 6: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 7: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.

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.