My Oracle Support Banner

Inserting Or Retrieving A Varray of Strings With Jdbc Driver Produces Empty Strings (Doc ID 551167.1)

Last updated on NOVEMBER 05, 2021

Applies to:

JDBC - Version to [Release 10.2 to 11.2]
Information in this document applies to any platform.
This problem can occur on any platform.


JDBC application inserting VARRAY of VARCHAR works on some databases but not on others.

When the issue occurs, the VARRAY is inserted with the correct number of elements but each element is null.

Here is a simple demo adapted from a demo provided with the standard JDBC demos:

Above example was run using JDBC/thin ( ojdbc6.jar)  connecting to various databases version 10.2, 11.1 and 11.2.   This issue is not JDBC driver version specific reproduces on JDBC 10.2 and 11.1 drivers.  The issue is however database dependent and may or may not reproduce depending on the database character set used.




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.