Forum Discussion

CDurkin's avatar
CDurkin
Contributor
14 years ago

Calling a Oracle Stored Proc with a BOOLEAN param

I have been unable to call a Oracle StoredProc with a boolean parameter, without it causing a excepetion.  Try ftBoolean first,  then  adBoolean neither worked.  Then I tried a brute force attempt whe...
CDurkin's avatar
CDurkin
Contributor
14 years ago
This is what I found out...



"Unfortunately an Oracle Boolean is a special data type that is understood only by Oracle. You would have to evaluate it in PL/SQL and return it as another data type, such as a number."