Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
PLSQL arrays and Integration Cloud — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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.

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!