Telerik OpenAccess ORM - Executing an Oracle stored procedure that returns result sets

In this blog post I will describe how easy it is, to work with the Telerik OpenAccess lower level ADO API and Oracle Stored Procedures that are returning SYS_REFCURSOR as out parameters.

The Setup

For the following examples we are using a basic Console Application project, which should be enough for the purpose of this blog. We have added a Domain Model to our Solution with two Domain Classes(‘Category’ and ‘Product’). Further we added the ODP.NET Driver from Oracle( you can get it from here), which should be installed on your machine as well.

On the Oracle database, we have created 2 stored procedures.

The first one we create is a simple stored procedure having an SYS_REFCURSOR out parameter. We return all category rows via this cursor.

   1: CREATE OR REPLACE PROCEDURE SPSingleRefCur(catCur OUT SYS_REFCURSOR )