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

[Sergey]

Hello.

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
begin
  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)
   value="1000"
 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?

-- 
Thanks,
Sergey                          
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.ximian.com/pipermail/mono-devel-list/attachments/20060818/34623c63/attachment.html