Interacting with SQL and PL/SQL in OCI and Java Interfaces

The OCI and Java interfaces now provide the ability to bind and define VARCHAR2 variables to SQL and PL/SQL statements with LOBs.

See Also: Oracle Call Interface Programmer's Guide Oracle9i JDBC Developer's Guide and Reference

This release does not provide the ability to define variables in the other direction, that is, defining a client-side CLOB locator on a VARCHAR2 column.

Note: In OCI, from a SQL query, temporary LOBs are generally returned in 'session` duration.