CallableStatement

This class extends the PreparedStatement class to support the execution of stored procedures or PL/SQL blocks. It enables PL/SQL OUT parameters and function return values to be defined and accessed. In addition to inheriting methods and properties of the PreparedStatement class, it adds routines for using OUT parameters. Oracle provides extenstions to the CallableStatement class as shown in Table A.9.

Table A.8. Methods of the CallableStatement Class
MethodPurpose
getBigDecimalRetrieve the value of the specified BigDecimal OUTparameter
getBooleanRetrieve the value of the specified Boolean OUTparameter
getByteRetrieve the value of the specified byte OUTparameter
getBytesRetrieve thevalue of the specified byte OUTparameter
getDateRetrieve ...

Get e-Commerce Applications Using Oracle8i and Java from Scratch now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.