Skip to Main Content
Forums

SQL & PL/SQL

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!

sys.odcivarchar2list

584328Jul 20 2010 — edited Jul 20 2010
hi ,


can someone tell me what is the maximum number of arguments for
sys.odcivarchar2list()?

i have try to use 2000+ and 1000 arguments and i get "too many arguments".
i want to something like

select * from table_x where column_x in (select * from table(sys.odcivarchar2list('and here about 2000 elements')))

i want to over the limitation on "in" clause of 1000 elements.
Sorry for my english

thank you

Ionut
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 17 2010
Added on Jul 20 2010
1 comment
3,307 views