How do I modify an oracle.sql.ARRAY argument in a Java stored procedure?

Question

When writing Java stored procedures, I often receive values via oracle.sql.ARRAY parameters. However, how do I export values via oracle.sql.ARRAY parameters? For example:

public static void fetchFavoriteFoods(oracle.sql.ARRAY favoriteFoods) {
    // What must be done here to add "pizza" and "cheese burger" to favoriteFoods?
}

Powerlord · Accepted Answer · 2010-11-08 16:26:04Z

1

Simply put, you don't. java.sql.Array and its implementations (like oracle.sql.ARRAY) are

a logical pointer to the data in the SQL ARRAY value rather than containing the ARRAY value's data.

Needless to say, this means that they are read-only values.

answered Nov 8, 2010 at 16:26

Powerlord

89k17 gold badges130 silver badges179 bronze badges

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

Comments

Bill the Lizard · Accepted Answer · 2011-12-12 17:32:41Z

0

This should be along the lines of what you are looking for: Oracle ARRAY type usage

Basically, you can create an object of your own oracle.sql.ARRAY and use it.

edited Dec 12, 2011 at 17:32

Bill the Lizard

407k213 gold badges579 silver badges892 bronze badges

answered Nov 8, 2010 at 16:15

Eddy B

11 bronze badge

Collectives™ on Stack Overflow

How do I modify an oracle.sql.ARRAY argument in a Java stored procedure?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related