Error on executing Oracle SP with JDBC Adapter


I’m working with Oracle DB version 8i.
I’m trying to execute an SP with OUT parameters type BOOLEAN. By using Developer tool, the configuration of the adapter service we find out that, in the “Parameter” tab configuration does not exist this kind of JDBC Parameter type (BOOLEAN). So have tried some types and the error message that I always receive is:

“Wrong number or types of arguments in call to…”

Anyone used Oracle BOOLEAN types with JDBC Adapter?

Someone can help me understanding why this happens?




The Oracle JDBC driver doesn’t support the passing of BOOLEAN parameters to PL/SQL procedures. Check out the Oracle8i JDBC Developer’s Guide and Reference (Chapter 19 - Common problems - Boolean parameters in PL/SQL Stored procedures).

The article also contains a work around.