hi,
i am planning to upgrade to dotConnect 7.7 and EntityDeveloper tool 5.5. so I'm trying a POC for calling a oracle stored procedure with an out ref cursor and out param with the latest tools. I'm getting an exception that ORA exception. If i don't have any out params, its working fine.
I'm attaching the POC files to this.
Attached zip file contains
devartpoc\EDModel\createdb.sql to create the tables and oracle package.
devartpoc\EDModel\createdata.sql to insert data into the 2 tables.
devartpoc\EDModel folder has the csdl, msl and ssdl files.
\devartpoc\DevartOracleCallingSP is the .net 4.0 console application to call the stored procedure.
Thanks for your help.
oracle stored procedure with out ref cursor and out param
Re: oracle stored procedure with out ref cursor and out param
devart, any help with this issue is greatly appreciated. i already sent the code to [email protected]
Thanks again
Thanks again
Re: oracle stored procedure with out ref cursor and out param
To debug this and similar issues, please turn on the dbMonitor tool for tracing database activity when developing application:smuddasu wrote:ORA-06550: line 2, column 3:
PLS-00306: wrong number or types of arguments in call to 'P_GET_CONTACT'
http://www.devart.com/dotconnect/oracle ... nitor.html
http://www.devart.com/dbmonitor/dbmon3.exe
dbMonitor shows that O_RESULT_SET parameter is the last in the signature of stored procedure call (because it is a hidden parameter, see the generated DevartPOCSP.ssdl). But its position is different in the stored procedure definition (in database).
As a solution, please set the Pass Parameters By Name connection string option to True (via Connection Properties > Advanced window in Database Explorer of Entity Developer). This setting is applied for the stored procedure calls. Save the model, regenerate code and metadata files.
Re: oracle stored procedure with out ref cursor and out param
Thanks a lot for your help. That did it.