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.

 

Project

 

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 )

About the Author

Ralph Waldenmaier

 is Senior Software Developer in Telerik OpenAccess ORM

Comments

Comments are disabled in preview mode.