Skip to Main Content

Java APIs

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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

Hiroshi Tonegawa May 31 2024

追加情報です。

リスナーからエラーメッセージでておりました。ただどうしたら良いのかわかりません。

そのlog(TNSLSNR.log)を添付しました。ここから原因、また対処法など解析できませんでしょうか?

大変困っております。よろしくお願いいたします。

TNSLSNR_496.log

1 - 1

Post Details

Added on Jan 23 2023
1 comment
920 views