Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Using DBMS_SQL getting ORA-29255

430487Aug 13 2009 — edited Aug 13 2009

Sort of new to DBMS_SQL - as I've been using NDS for almost everything to this point.

However - I have a situation where I'm selecting data that requires a predicate of multiple values for a single column (i.e. column in (:v1)) where :v1 is a list of values. I was using bind_array to set the values for :v1. However - I get the error above.

The SQL returns mutiple rows so - define array is being used to indicate what column should be returned to what array.

I understand based on the error message that they can't be used together. So- my question is - when using a SQL statement that requires "columnA IN (multiple_values)" how are you supposed to bind those using DBMS_SQL?

Any help is appreciated!!

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 10 2009

Added on Aug 13 2009

#general-database-discussions

9 comments

1,253 views