Many databases support the REF CURSOR type. Java 8 has added direct support for REF CURSOR data type in the JDBC API by adding the JDBCType.REF_CURSOR enum constant that represents REF CUSROR data type in Java. Using this JDBC type, you will be able to work with the REF CURSOR type without using proprietary JDBC classes in your Java program. For example, you will be able to register the OUT parameter of the REF CURSOR database type in the printPersonDetails() method as follows:
cstmt.registerOutParameter(2, JDBCType.REF_CURSOR);
Tip At the time of this writing, the JDBCType.REF_CURSOR type has not been implemented in the Oracle JDBC driver. ...
Get Beginning Java 8 APIs, Extensions and Libraries Swing, JavaFX, JavaScript, JDBC and Network Programming APIs 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.
