Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Does Oracle SQLJ support REF CURSORS?

April 26, 2017cursors Oracle REF SQLJ support

0

Posted

Does Oracle SQLJ support REF CURSORS?

1 Answer

0

Posted

Oracle SQLJ supports REF CURSORS along the same lines that Oracle’s JDBC drivers do. Specifically, a REF CURSOR that is a SELECT column, a function return, or an OUT parameter of a procedure can be materialized in SQLJ as a JDBC ResultSet or a SQLJ iterator instance. In Oracle 9.0.1 and later JDBC stored procedures permit passing a JDBC ResultSet out as a REF CURSOR argument (with an Oracle-specific API to enable this). However, at this point SQLJ stored procedures do not permit passing SQLJ iterators in this way. 7. Translation (and Compilation and Customization) Process 7.