[Mono-dev] Calling Oracle package with output ref cursor parameter

Daniel Morgan monodanmorg at yahoo.com
Fri Sep 16 09:48:52 EDT 2005

There is no support for REF CURSOR in Mono's OracleClient.   It is something I want to do though.  Many types default to a VARCHAR or String if there is no support for it.
Output parameters work for other types though, such as, varchar, numeric, date, etc...
I still need to get TIMESTAMP and OracleDateTime working good.  Well, it works for me, but not Hurbert.
I have been spending my time trying to write an oracle pl/sql debugger in C#.  I can put that on hold and start fixing bugs in OracleClient again.
By the way, looking at the IL is not the best way to figure out how it works.  The source code to Mono is available.  You can look at the C# code to see exactly what is happening. 

Zsolt Petrény <Zsolt.Petreny at sensenet.hu> wrote:

I would like to ask whether calling Oracle package with output ref cursor parameter is supported.


I am using Debian and the Oracle Client (despite it’s not supported...) and trying to get the output of a package as an OracleDataReader. AFAIK, this can be achieved by declaring an output ref cursor parameter in the package and then calling the ExecuteReader() method. It really works with .NET FW 1.1 but not under Mono.


I have downloaded the new 1.1.9 version of Mono and checked its IL code and noticed that OracleType.Cursor parameters are treated as characters (DbType.AnsiStringFixedLength, OciDataType.Char). I suppose this is not correct (especially because I get an exception with the message "ORA-06553: PLS-306: wrong number or types of arguments in call to 'GETDATA'").


So my question is, whether there's any way to retrieve rows by calling an Oracle package and if not then when can we/I expect this to be implemented?


P.S.: I know, according to the http://www.mono-project.com/Oracle page Cursors are not supported yet, but it’s confusing to see it in the IL code...


Yahoo! for Good
 Click here to donate to the Hurricane Katrina relief effort. 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.ximian.com/pipermail/mono-devel-list/attachments/20050916/9e975c93/attachment.html 

More information about the Mono-devel-list mailing list