Oracle stored procedures

[Stepan]

Hi,

We are playing with ORM+Oracle, and have several issues.
1. After any update of Model (with Database-first approach), we have to 
   manually restore oracle package name in full proc's name, 
   FOR EACH PACKAGED SUBPROGRAM. Full name does not persist ;-)

2. It seems, that ORM calls procedures (more exactly, packaged ones), 
   passing 
   arguments in incorrect order. 
   In designer, we are observing arguments in alphabetical order, 
   in c# code Intellisense shows that arguments should follow in 
   reverse order (compared to Designer), whereas in DB the order
   is totally different.
The error from Oracle:  
wrong number or types of arguments in call to 'proc_name'

It makes me think, that internally ORM apply arguments in some
order, different from the correct one,
and, additionally, the syntax is being used:
Sal_raise(:p1, :p2);



Instead of:




Sal_raise(Sal_incr=>:p1, Emp_id=>:p2);



Best regards,
Zykov Max

[Ady]

Hello Maxim,

 We are aware for certain problems there. We have made considerable improvements in that area (stored procedure code generation and execution) and the next service pack would contain these improvements. We will keep you updated when the service pack is released, probably in a fortnight from now.

Regards,
Ady
the Telerik team

[Stepan]

Hello Telerik,

I had to look up for "fortnight" in my dictionary, and the translation was "you can expect that your service pack is already available".

Best regards,
Maxim

[Ady]

Hi Maxim,

 Did you update to the latest internal build - 2011.2.908.1? Regarding the new stored procedure support you can have a look at the new 'Execute...' set of methods on the OpenAccessContextBase class and for some advanced use cases like obtaining multiple result sets via a stored procedure you can have a look at the new ADO API.
Regarding the UI for generating context methods to execute the stored procedure - that should be available in the next release for sure.

Do get back in case you need assistance for achieving anything in particular .

Greetings,
Ady
the Telerik team