Using Boolean input parameter in SP call || JDBC

, , , , ,
1

Hi,

From this post here from 2014, it says ,JDBC has a limitation to treat Boolean as a parameter. Is it still the same?

Do we still have to create a wrapper StoredProcedure which accepts a Varchar instead of boolean?

2

Hi Divya,

As per JDBC Developer’s guide of 11g release 2 (11.2), Oracle JDBC drivers doesn’t support calling arguments or return values of the PL/SQL BOOLEAN type.
You can check below link for more details.
https://docs.oracle.com/cd/E11882_01/java.112/e16548/apxref.htm#JJDBC28928

However, such limitation is not mentioned in JDBC Developer’s guide of 12c release 2 (12.2).

So, I assume that there is no such limitation with latest oracle JDBC driver.

Regards
Anurag

2 Likes