The Oracle Provider for OLEDB has some nice methods for retrieving an array from a PL/SQL procedure call and making it appear to be a Recordset object. It's a bit trickier to go in the other ...

Oracle has continuously evolved its JSON processing capabilities, transitioning from APEX_JSON-based PL/SQL parsing to high-performance, native JSON functions embedded within SQL and PL/SQL.