[Mono-dev] Problem with call of stored procedure in Oracle
sergey.monolists at gmail.com
Fri Aug 18 05:48:00 EDT 2006
Something strange happens with types when calling stored procedure in Oracle.
Procedure looks like:
create or replace procedure test_int(p1 in number, p2 out number) is
p2 := p1;
Putting trace option on we can see that mono oracle client passes parameter of wrong type:
bind 0: dty=1 (varchar2)
bind 1: dty=96 (char)
The same code in .net works well. (Types are dty=2 (number).)
This strange behavior cause problems with value of out parameter.
According to class status of System.Data.OracleClient namespace it should be rather stable, but it doesn't seem to be so. (There are also problems with Blobs, etc.)
Are any ongoing improvements of it?
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the Mono-devel-list