Using Table of Records type as Input to PLSQL procedure showing performance issues from Java

Hi Team,

We are facing performance issues when we are trying to pass an array of array as input from Java to PLSQL procedure which has the table of records as input in 19C database.

We are using Oracle Database 19C, Java Version 8, JDBC Specification 4.2 in ojdbc8.jar

Table Type

CREATE TYPE TEST_REC AS OBJECT (EmpName VARCHAR2(50),EmpNo NUMBER));

CREATE TYPE TEST_TBL AS TABLE OF TEST_REC;

PLSQL procedure:

procedure TEST_PROC(P_TEST_TBL IN TEST_TBL)

as

begin

...........

end;

Java Code:

1. OracleStruct[] structArray = new OracleStruct[length];
2. ArrayDescriptor descriptor =ArrayDescriptor.createDescriptor( "TEST_TBL", oracleConnection );
3. ARRAY array_to_pass =new ARRAY( descriptor, oracleConnection, structArray );