oracle Array filled with null data in java

Question

When I try to throw an Array of strings to oracle stored procedure as:

String arrStr[] ={"val1","val2","val3"};
ArrayDescriptor descriptor = ArrayDescriptor.createDescriptor("STR_ARRAY", connection );

oracle.sql.ARRAY oracleArray = new oracle.sql.ARRAY(descriptor, connection, arrStr);

oracleArray holds null data , oracleArray.datumArray = {???,???,???}

What is the SQL definition of STR_ARRAY? Here's a working example, can you reproduce this example on your system? — Vincent Malgrat
– Vincent Malgrat, Commented Feb 21, 2013 at 9:28
here is the script of creating type in database: CREATE TYPE str_array AS TABLE OF VARCHAR2 (40) — mega
– mega, Commented Feb 21, 2013 at 9:32
How are you determining that it holds null data - with oracleArray.dump(), looking at the Datum elements from oracleArray.getOracleArray()... or something else? (Since I don't think you can access datumArray directly). Or are the values null on the Oracle side when you try to use the passed array in your procedure - in which case you might need to show that call as well? — Alex Poole
– Alex Poole, Commented Feb 21, 2013 at 10:49
I determine that it holds null data by watching 'oracleArray' in debugging mode. — mega
– mega, Commented Feb 21, 2013 at 11:23
I'm having same issue - using oracle 9i as well as 10g and all available jdbc drivers - result is the same. oracle.sql.ARRAY is empty when it is created in java, INSERT in the procedure will therefore create only null vvalues - I'm trying to find solution, but no luck so far :( did you oslve the problem? — tomas
– tomas, Commented Sep 13, 2013 at 12:00

tomas · Accepted Answer · 2013-09-16 15:00:32Z

10

In my case (see my comment above), it was caused by encoding problem, however - without any exception or debug information. Including orai18n.jar to the project libraries solved this... it is really sad, there is no exception or something that would indicate how to solve the problem

answered Sep 16, 2013 at 15:00

tomas

7393 gold badges11 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Luke Woodward Over a year ago

Glad to hear you figured this out, and thanks for posting the solution. Oracle issues can be a bit difficult to figure out, and even it does give you an error message, it isn't always accurate or helpful. +1

Viktor Ozerov Over a year ago

Awwww, man, that's so cool! This is solution for me too! Can you explain, why we need orai18n.jar in classpath? How it affects our project?

user987339 · Accepted Answer · 2014-03-06 12:44:37Z

1

After hours I have founded the cause, the real problem is the NLS_CHARACTERSET of your database work with a encoding that is not supported by your client, to jdbc support others NLS_LANG is necessary add orai18n.jar in classpath. See your database settings with this sql:

SELECT * FROM NLS_DATABASE_PARAMETERS

edited Mar 6, 2014 at 12:44

user987339

10.7k8 gold badges45 silver badges48 bronze badges

answered Mar 6, 2014 at 12:23

Paulo Henrique

111 bronze badge

Comments

mark · Accepted Answer · 2014-05-09 14:17:39Z

0

Probably your STR_ARRAY is defined in this way:

create or replace type STR_ARRAY is table of VARCHAR2(20);

As Tomas said the problem is encoding. My solution - use NVARCHAR2 instead.

create or replace type STR_ARRAY is table of NVARCHAR2(20);

answered May 9, 2014 at 14:17

mark

1

Collectives™ on Stack Overflow

oracle Array filled with null data in java

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related