Skip to Main Content

Java APIs


For appeals, questions and feedback, please email

Passing array of arrays as a parameter to Oracle

JackKJan 23 2023

Hi All.
I don't know Java language and I'm not sure if I am writing in the correct subforum.
We have a function that needs an array of arrays as an input parameter. The type of this parameter is t_a_varchar2s defined as:

create or replace type t_varchar2s is table of varchar2(255);
create or replace type t_a_varchar2s is table of t_varchar2s;

We have a problem with defining an array in Java that can be passed to Oracle into a parameter of this t_a_varchar2s type.
May you help us, please?

Best regards,

Post Details
Added on Jan 23 2023
1 comment