Skip to Main Content

Java Database Connectivity (JDBC)

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!

How to read a Varray of Strings that is returned by a stored procedure in Java

Ioanna Kat-OracleJun 27 2017 — edited Jun 30 2017

Hello,

I have be given a stored procedure that returns a String and a custom type custom_typ which is varray(5000) of varchar2(15) .

I want to execute this procedure and then get the result array.

I tried searching the internet and tried several mechanisms, but seems like the most examples I find use the ArrayDescriptor or other Deprecated classes.

Does anyone know how to call this in order to print out in my Java program the result array or where to search in order to find more information about this topic?

Many thanks

Ioanna

This post has been answered by unknown-7404 on Jun 27 2017
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 28 2017
Added on Jun 27 2017
3 comments
726 views