Skip to Main Content

Java APIs

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

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,
Jacek

Comments
Post Details
Added on Jan 23 2023
1 comment
337 views