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 |