I am calling a database procedure from java using JDBC. This database procedure has IN and OUT parameter as Nested table like the following.
Create Type ARRAY_VARCHAR IS table of VARCHAR2(192);
Procedure Mark_Data(p_tapes IN ARRAY_VARCHAR,p_final_tapes OUT ARRAY_VARCHAR);
When this procedure is called from java using JDBC with contents in Input array p_tapes,inside the database procedure the array is not empty but all the contents comes only as blank strings.
Is there any database parameter or JDBC setting to make the interface work properly. Any info will be helpful. Thanks in advance.