Problem with passing Array values from our java code to PLSQL.
We have a problem with passing Array values from our java code to PLSQL.
Our Oracle array structure is -
create or replace TYPE OBJ_COMMENTS AS OBJECT
(
table_name varchar2(30),
column_name varchar2(100),
column_comment varchar2(4000)
)
create or replace TYPE TAB_OBJ_COMMENTS IS TABLE OF OBJ_COMMENTS
In Java code we have writen the following code
ConnectionHandle connectionhandle = (ConnectionHandle)((java.sql.DatabaseMetaData)connection.getMetaData()).getConnection();
connection = (Connection)connectionhandle.getAssociation().getPhysicalConnection();
// create descriptor and oracle array type object
ArrayDescriptor arrayDesc = ArrayDescriptor.createDescriptor("TAB_OBJ_COMMENTS", connection);
empArray = new ARRAY(arrayDesc, connection, dataDictionaryTOArr);
// create call-able statement and call stored procedure