PL/SQL: Inserting the values of a column of a table into an array or VARRAY to be accessed by java?

Question

I need to take the values from a specific column in a table and place them into an array. I'm thinking to use a PL/SQL Stored procedure then calling the procedure in java and using something like:

    CallableStatement.getArray(2, myArray);

I was thinking of using something like:

SELECT column1 
INTO myVARRAY
FROM table1
WHERE table_id = t_id;

In a stored procedure But that didn't work

"But that didn't work". C'mon, give us a clue. How didn't it work? We are not telepathic, so you need to provide details: describe the observed behaviour, results, error messages etc. — APC
– APC, Commented Nov 17, 2012 at 9:04

Jacob · Accepted Answer · 2012-11-18 04:58:40Z

1

Presume that myVARRAY is of type varchar2. In this case you could try something like

p_col   VARCHAR2 (32);

SELECT column1 
INTO p_col
FROM table1
WHERE table_id = t_id;

and then you add p_col into your array by

myVARRAY.EXTEND;
myVARRAY (1) := p_col;

RETURN myVARRAY;

And from Java call your array by

callablestatement.registerOutParameter(2, OracleTypes.ARRAY, "MYVARRAY");

Hope this will be helpful, otherwise provide more information about your function/procedure and the type of errors you are getting.

answered Nov 18, 2012 at 4:58

Jacob

14.8k69 gold badges215 silver badges323 bronze badges

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

Collectives™ on Stack Overflow

PL/SQL: Inserting the values of a column of a table into an array or VARRAY to be accessed by java?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related