PL/SQL BOOLEAN problems

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
gregor
Posts: 10
Joined: Sat 25 Dec 2010 15:55

PL/SQL BOOLEAN problems

Post by gregor » Sat 25 Dec 2010 16:25

Please advice how call procedure with linq, if procedure accepts pl/sql boolean as parameter.

If I import it to Model explorer, connector maps as db type pl/sql boolean and if I call procedure i get error:

Unsupported data type PL.

I searched forums and tried to change it to number, but then there is error that different data types are calling procedure.

There are one solution for ADO.NET, but not for linq to oracle.

Do you have any advice?


Best regards, Gregor

StanislavK
Devart Team
Posts: 1710
Joined: Thu 03 Dec 2009 10:48

Post by StanislavK » Mon 27 Dec 2010 11:31

Thank you for your report. We will investigate this problem and inform you about the results as soon as possible.

StanislavK
Devart Team
Posts: 1710
Joined: Thu 03 Dec 2009 10:48

Post by StanislavK » Thu 27 Jan 2011 18:08

We have fixed the runtime problem. I.e., now it should be possible to use procedures with boolean parameters; however, it is necessary to change the DbType property of the parameter from 'PL/SQL BOOLEAN' to 'BOOLEAN' for this. We will inform here when proper default mapping for 'PL/SQL BOOLEAN' parameters is implemented.

The fix is available in the new 6.10.96 build of dotConnect for Oracle. This build can be downloaded from
http://www.devart.com/dotconnect/oracle/download.html
(the trial version) or from Registered Users' Area (for users with active subscription only):
http://secure.devart.com/

For the detailed information about the fixes and improvements available in dotConnect for Oracle 6.10.96, please refer to
http://www.devart.com/forums/viewtopic.php?t=20115

StanislavK
Devart Team
Posts: 1710
Joined: Thu 03 Dec 2009 10:48

Post by StanislavK » Thu 10 Feb 2011 17:48

We have fixed the problem in the designer as well, now 'PL/SQL BOOLEAN' parameters should be mapped properly by default. The fix is available in the new 6.10.103 build of dotConnect for Oracle. The new build can be downloaded from
http://www.devart.com/dotconnect/oracle/download.html
(the trial version) or from Registered Users' Area (for users with active subscription only):
http://secure.devart.com/

For the detailed information about the fixes and improvements available in dotConnect for Oracle 6.10.103, please refer to
http://www.devart.com/forums/viewtopic.php?t=20224

Post Reply