This is a migrated thread and some comments may be shown as answers.

Stored Procedure Editor

4 Answers 29 Views
Getting Started
This is a migrated thread and some comments may be shown as answers.
This question is locked. New answers and comments are not allowed.
Henk
Top achievements
Rank 1
Henk asked on 21 Dec 2011, 04:00 PM
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.

4 Answers, 1 is accepted

Sort by
0
Ralph Waldenmaier
Telerik team
answered on 22 Dec 2011, 10:12 AM
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!

0
Henk
Top achievements
Rank 1
answered on 22 Dec 2011, 10:22 AM
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
0
Ralph Waldenmaier
Telerik team
answered on 22 Dec 2011, 02:45 PM
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!

0
Henk
Top achievements
Rank 1
answered on 22 Dec 2011, 04:46 PM
Hi Ralph,

No, I used views until this feature will be available in ORM. Less coding ;-)
Tags
Getting Started
Asked by
Henk
Top achievements
Rank 1
Answers by
Ralph Waldenmaier
Telerik team
Henk
Top achievements
Rank 1
Share this question
or