Stored proc args default to aplhabetical order in Oracle
Posted: 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
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