[Mono-dev] Problem with call of stored procedure in Oracle

Sergey 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;
end test_int;
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...
URL: http://lists.ximian.com/pipermail/mono-devel-list/attachments/20060818/34623c63/attachment.html 

More information about the Mono-devel-list mailing list