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

Thread is closed for posting
3 posts, 0 answers
  1. 63F75A2C-1F16-4AED-AFE8-B1BBD57646AD
    63F75A2C-1F16-4AED-AFE8-B1BBD57646AD avatar
    1572 posts
    Member since:
    Oct 2004

    Posted 02 Aug 2011 Link to this post


    OpenAccess version 2011.2 713
    .NET version 4.0
    Visual Studio version 2010
    programming language C#

    This project shows how to work with the Telerik OpenAccess ORM lower level ADO API and Oracle Stored Procedures, that have out parameters of type SYS_REFCURSOR. Two approaches are presented - using OpenAccessContext and using OACommand.
    The second one is more complex, but provides more control and flexibility. The HR sample database is used.

    • Make sure you have ODP.NET (ODAC) installed.
    • Make sure you reference the correct version of Oracle.DataAccess.dll in your project, it should be the same as the one defined in machine.config (4.0 by default)
    • Make sure you have a connection to a working Oracle database with the HR sample schema enabled. The HR schema is not active by default, it can be enabled from the Oracle admin webpage.
    • Run the script located next to the .sln file in the attached archive, named storedProcedures.sql . It will create the stored procedures needed for the demo.
  2. B5DBAB25-F4EB-43B7-BAD5-B817A13825E9
    B5DBAB25-F4EB-43B7-BAD5-B817A13825E9 avatar
    114 posts
    Member since:
    Apr 2006

    Posted 04 May 2012 Link to this post


    Do you have also an example using the new wizard  (the sp  mapped as IEnumerable) and bind to a Silverlight grid(view) Also using  a domain dataservice like the introduction "getting started with orm and silverlight".


  3. 506D51F9-1C3B-4917-91B4-D8B1E0285216
    506D51F9-1C3B-4917-91B4-D8B1E0285216 avatar
    318 posts
    Member since:
    Dec 2017

    Posted 09 May 2012 Link to this post

    Hi Henk,

    We do not have such example yet. We are planning to release a stored procedure usage sample with Q2 2012 release of the OpenAccess SDK, but the results are not shown in a Silverlight grid.

    What we do have now in the SDK is:
    - an example shows how Silverlight is working with OpenAccess exposing data through a RIA service
    - a WPF sample showing data exposed through a WCF Data Service.

    We hope that the current samples will be helpful for your scenario. In any case, do not hesitate to submit a support ticket if you need any assistance. 

    All the best,
    the Telerik team
    Follow @OpenAccessORM Twitter channel to get first the latest updates on new releases, tips and tricks and sneak peeks at our product labs!
Back to Top

This Code Library is part of the product documentation and subject to the respective product license agreement.