Home » Open Source » Programming Interfaces » Nested Tables with JDBC (9i)
Nested Tables with JDBC [message #431644] Wed, 18 November 2009 21:09 Go to next message
prax_14
Messages: 64
Registered: July 2008
Member

I am calling a database procedure from java using JDBC. This database procedure has IN and OUT parameter as Nested table like the following.
Create Type ARRAY_VARCHAR IS table of VARCHAR2(192);

Procedure Mark_Data(p_tapes IN ARRAY_VARCHAR,p_final_tapes OUT ARRAY_VARCHAR);


When this procedure is called from java using JDBC with contents in Input array p_tapes,inside the database procedure the array is not empty but all the contents comes only as blank strings.

Is there any database parameter or JDBC setting to make the interface work properly. Any info will be helpful. Thanks in advance.

Re: Nested Tables with JDBC [message #431801 is a reply to message #431644] Thu, 19 November 2009 10:26 Go to previous message
prax_14
Messages: 64
Registered: July 2008
Member
I have two installs of Oracle 9i. The above situation works fine in one of the installs and not working in the other. Whats possible database parameter or configuration could cause this behavior.

Thanks in advance.
Previous Topic: DBD::Oracle install problem on 64-bit RHEL51
Next Topic: Problem creating package body via JDBC: Non supported SQL92 token
Goto Forum:
  


Current Time: Thu Mar 28 20:07:29 CDT 2024