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.'
Tagged:
0