Stored Procedure Editor

5 posts, 0 answers
  1. Henk
    Henk avatar
    113 posts
    Member since:
    Apr 2006

    Posted 21 Dec 2011 Link to this post

    Hello,

    I try to use the new Stored Procedure Editor in Q3 2011.
    I would like to create a Domain Method for my Oracle Stored Procedure returning a ref cursor.
    When I try to use "Retrieve Result Shape" I receive the following error:
    "Your procedure contains ref cursors that are currently not supported"
    Is Oracle not yet supported?

    Kind Regards.
  2. Ralph Waldenmaier
    Admin
    Ralph Waldenmaier avatar
    202 posts

    Posted 22 Dec 2011 Link to this post

    Hello Henk,

    We support stored procedures with in/out parameters for Oracle with our Stored Procedure Editor. I'm afraid, that the usage of ref cursors is not supported yet, but is on our TODO list. 
    At the moment, you can use our ADO API to execute stored procedures returning ref cursors. See this blog post how to do this.

    Hope that helps.

    Greetings,
    Ralph
    the Telerik team

    Q3’11 of Telerik OpenAccess ORM is available for download. Register for the What's New in Data Tools webinar to see what's new and get a chance to WIN A FREE LICENSE!

  3. DevCraft banner
  4. Henk
    Henk avatar
    113 posts
    Member since:
    Apr 2006

    Posted 22 Dec 2011 Link to this post

    Hi Ralph,

    A pitty, I want to used ORM for this. I am aware of the blog post. We used the same technology also for streaming blob on the fly to oracle. With strong type refcursors we can avoid using views and its more secure. Q1 2012? ;-)

    Thanks
  5. Ralph Waldenmaier
    Admin
    Ralph Waldenmaier avatar
    202 posts

    Posted 22 Dec 2011 Link to this post

    Hi Henk,

    I'm glad that you can use the ADO API in the meantime and I understand that you would like to have the feature in the stored procedure editor. We are working hard on bringing this feature into the product 
    as fast as possible. 
    We apologize for any inconvenience this is causing to you.

    Greetings,
    Ralph
    the Telerik team

    Q3’11 of Telerik OpenAccess ORM is available for download. Register for the What's New in Data Tools webinar to see what's new and get a chance to WIN A FREE LICENSE!

  6. Henk
    Henk avatar
    113 posts
    Member since:
    Apr 2006

    Posted 22 Dec 2011 Link to this post

    Hi Ralph,

    No, I used views until this feature will be available in ORM. Less coding ;-)
Back to Top
DevCraft banner