Oracle stored procedures

4 posts, 0 answers
  1. Stepan
    Stepan avatar
    11 posts
    Member since:
    Mar 2011

    Posted 16 Aug 2011 Link to this post

    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), 
       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
  2. Ady
    Ady avatar
    588 posts

    Posted 18 Aug 2011 Link to this post

    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.

    the Telerik team

    Explore the entire Telerik portfolio by downloading the Ultimate Collection trial package. Get now >>

  3. DevCraft banner
  4. Stepan
    Stepan avatar
    11 posts
    Member since:
    Mar 2011

    Posted 29 Sep 2011 Link to this post

    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,
  5. Ady
    Ady avatar
    588 posts

    Posted 03 Oct 2011 Link to this post

    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 .

    the Telerik team

    Thank you for being the most amazing .NET community! Your unfailing support is what helps us charge forward! We'd appreciate your vote for Telerik in this year's SQL Server Community Awards. We are competing in TWO categories and every vote counts! VOTE for Telerik NOW >>

Back to Top