PLSQL arrays and Integration Cloud
Hi All
I have an xml array posting to a plsql table and record and that works fine. But I want to set up a GET to return that plsql table into an XML array. The error I am getting is covered by DocID 2720875.1
Unable to convert the XSD element V_RECS_OUT whose JDBC type is ARRAY to a corresponding XML document element. Cause: java.sql.SQLException: Internal Error: Image is not in 8.1 format.
Document ID 2708728.1 goes onto say
The nested PL/SQL type (for example, a RECORD type inside a TABLE type) is not supported as an IN/OUT parameter in a stored procedure if the target database is version 18c or higher. However, you can define OBJECT types inside TABLE types.