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.

Do Oracle’s JDBC drivers support PL/SQL tables/result sets/records/booleans?

April 26, 2017Drivers JDBC Oracle PL records sql support tables

0

Posted

Do Oracle’s JDBC drivers support PL/SQL tables/result sets/records/booleans?

1 Answer

0

Posted

No. It is not feasible for Oracle JDBC drivers to support calling arguments or return values of the PL/SQL types TABLE (now known as indexed-by tables), RESULT SET, RECORD, or BOOLEAN. There are currently no plans to change this. Instead people are encouraged to use RefCursor, Oracle Collections and Structured Object Types.