Oracle, Stored Procedures with ref cursor from .Net code and BID tracing.

Ok, many concepts today.   First we’ll create some tables, a package and a stored procedure using ref cursors in a Oracle database. Then we’ll create a .Net application that uses this stored procedure. Finally we’ll create a BID trace for this that traces both System.Data.OracleClient and OCI activity (System.Data.OracleClient just calls into the OCI…

1