Hello! 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? Regards, Zsolt Petreny 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... |
_______________________________________________ Mono-devel-list mailing list Mono-devel-list@lists.ximian.com http://lists.ximian.com/mailman/listinfo/mono-devel-list