Stored Procedure Editor

[Henk]

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.

[Ralph Waldenmaier]

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

[Henk]

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

[Ralph Waldenmaier]

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

[Henk]

Hi Ralph,

No, I used views until this feature will be available in ORM. Less coding ;-)