PL/SQL (MOSC)

MOSC Banner

Problem with passing Array values from our java code to PLSQL.

edited Jul 6, 2011 5:42AM in PL/SQL (MOSC) 1 commentAnswered
 Hi,

We have a problem with passing Array values from our java code to PLSQL.

Our Oracle array structure is -

create or replace TYPE OBJ_COMMENTS AS OBJECT
(
table_name varchar2(30),
column_name varchar2(100),
column_comment varchar2(4000)
)

create or replace TYPE TAB_OBJ_COMMENTS IS TABLE OF OBJ_COMMENTS

In Java code we have writen the following code

ConnectionHandle connectionhandle = (ConnectionHandle)((java.sql.DatabaseMetaData)connection.getMetaData()).getConnection();
connection = (Connection)connectionhandle.getAssociation().getPhysicalConnection();
     
// create descriptor and oracle array type object
ArrayDescriptor arrayDesc = ArrayDescriptor.createDescriptor("TAB_OBJ_COMMENTS", connection);    
empArray = new ARRAY(arrayDesc, connection,  dataDictionaryTOArr);  
    
// create call-able statement and call stored procedure

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center