My Oracle Support Banner

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

Last updated on AUGUST 09, 2023

Applies to:

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

Symptoms

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 11.2.0.3 ( 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.

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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