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

Return a json collection from a REST integration involving Oracle DBAdaptor

Hi All

In Oracle 19c I have setup a proc that returns a nested table which references a plsql record. Back in OIC when trying to reference the proc I encountered a 'JCABindingException Image is not in 8.1 format' in the log file and I narrowed that down to metalink note (Doc ID 2708728.1). Basically my nested table structure does not conform to JDBC.

' 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!