Page 1 of 1
ExecuteMethodCall Invalid datatype : PL
Posted: Wed 15 Jul 2009 08:35
by talsja
Hello,
I am using linq to oracle datacontext with oracle 9 as underlaying database.
When i execute a stored procedure with input and output parameters from my C# class i get a Invalid datatype : PL error
Does anyone know what this means and what to do about this?
Thanks a lot
Talsja
Posted: Wed 15 Jul 2009 10:22
by AndreyR
Does this problem persist in the latest build of dotConnect for Oracle (5.25.37)?
If so, please send us (support * devart * com) the script of the procedure and a sample code calling it.
Posted: Wed 15 Jul 2009 13:24
by talsja
Dear AndreyR
I have purchaced dotConnect520Pro just a few weeks ago so i assume this is the latest version.
Now i am using devart linq to sql datacontext and have implemented all my tables and stored procedures. After your support on the input and output parameters i get the error invalid datatype: pl while executing the stored procedure. What i have noticed is that all my number(10) witch in c# are int64 are bind in the linq to sql class to a double.
Also numbers(7,4) are bound to doubles where i would expect decimals.
I have tried to rebind to the correct types but still have the same problem.
I will send u a email with the codeblock i am using and the stored procedure.
Thanks in atvance
Talsja