Page 1 of 1

Data Type = boolean, Param Type = out

Posted: Sun 21 Jun 2009 09:06
by JuryZ
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

:?:

Posted: Mon 22 Jun 2009 06:44
by Plash
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.