Data Type = boolean, Param Type = out

Discussion of open issues, suggestions and bugs regarding ODAC (Oracle Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
JuryZ
Posts: 1
Joined: Sun 21 Jun 2009 08:39

Data Type = boolean, Param Type = out

Post by JuryZ » Sun 21 Jun 2009 09:06

1. ODAC 6.50.0.35

2. OraSQL:
begin
:b := true;
end;
b: Data Type = boolean, Param Type = out

3. Execute

4. Error:
ORA-06550: line 2, column 9:
PLS-00382: expressin is of wrong type
ORA-06550: line 2, column 3:
PL/SQL: Statement ignored

:?:

Plash
Devart Team
Posts: 2844
Joined: Wed 10 May 2006 07:09

Post by Plash » Mon 22 Jun 2009 06:44

Boolean data type can be used inside PL/SQL only. So ODAC maps ftBoolean parameters to Oracle INTEGER type. The error occurs because you cannot assing True to an INTEGER variable.

Post Reply