The new BOOLEAN data type in Oracle Database 23c with PL/SQL and the JDBC Drivers (21c, 23c)

by Juarez Junior

Introduction

A previous blog post introduced the ISO SQL standard-compliant BOOLEAN data type as supported by the Oracle Database 23c Free — Developer Release.

We’ve explored several specific scenarios concerning the details that Java developers must pay attention to when working with the BOOLEAN data type for column definitions, and its use with the Oracle JDBC drivers (23c, 21c).

Besides, we’ve also analyzed what happens when using some different JDBC queries with table columns that use the NUMBER and VARCHAR data types and values that may represent logical boolean values.

This blog post complements those scenarios but now in consideration of such combinations with PL/SQL stored procedures, JDBC and CallableStatements.

If you need an introduction to JDBC and CallableStatements, please check my previous blog post — Invoking Stored Procedures with JDBC CallableStatements.

So, without further ado, let’s get started!