Stored proc args default to aplhabetical order in Oracle

NileshA · Post by **NileshA** » Fri 09 Jan 2009 19:23

Hi,

I am using your dotconnect driver for Oracle to test EF functionality.

One of the tests I did was to add a stored procedure that returned a ref cursor. I am finding that the stored proc's arguments are generated in alphabetical order rather than the order in which they have been specified in the stored procedure.

This is causing the call to fail. If I manually edit the edmx file and rearrange the args then the call succeeds. This ofcourse gets overwritten everytime the model is updated.

The work around is to modify the sp to rearrange the args in alpha order.

I am using version 5.0.16.0 on an SP system running VS 2008SP1 with .NET 3.5 SP1.

I have tried it with both direct=true and false.

Thanks

AndreyR · Post by **AndreyR** » Tue 13 Jan 2009 10:08

Thank you for the bug report.
The problem is fixed, look forward to the upcoming build.

NileshA · Post by **NileshA** » Tue 13 Jan 2009 16:17

Thanks for the prompt response. Will test again with new build.

ies · Post by **ies** » Thu 26 Feb 2009 08:22

I am using trial version of devart dotConnect for Oracle and I have de same problema, what can i do??

http://connect.microsoft.com/VisualStud ... kID=334535

AndreyR · Post by **AndreyR** » Thu 26 Feb 2009 12:33

Please check that you have the latest build of dotConnect for Oracle (current one is 5.0.22).
If you do, but you have this problem, please send me the script of your procedure, I'll check it out.

ies · Post by **ies** » Thu 26 Feb 2009 15:22

ok, thanks, now is right. My version was 5.0.16.0