Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
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.

Register

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