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.
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 )
Ralph Waldenmaier is Senior Software Developer in Telerik OpenAccess ORM
Copyright © 2016, Progress Software Corporation and/or its subsidiaries or affiliates. All Rights Reserved.
Progress, Telerik, and certain product names used herein are trademarks or registered trademarks of Progress Software Corporation and/or one of its subsidiaries or affiliates in the U.S. and/or other countries. See Trademarks or appropriate markings.