Page 1 of 1

Stored proc args default to aplhabetical order in Oracle

Posted: Fri 09 Jan 2009 19:23
by NileshA
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

Posted: Tue 13 Jan 2009 10:08
by AndreyR
Thank you for the bug report.
The problem is fixed, look forward to the upcoming build.

Posted: Tue 13 Jan 2009 16:17
by NileshA
Thanks for the prompt response. Will test again with new build.

Posted: Thu 26 Feb 2009 08:22
by ies
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

Posted: Thu 26 Feb 2009 12:33
by AndreyR
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.

Posted: Thu 26 Feb 2009 15:22
by ies
ok, thanks, now is right. My version was 5.0.16.0