powerbuilder unable to send more than 1000 elements in the number array - dw parameter

hi all,

i have gone through the postings, but still could not find a satisfactory reason.

am using :
powerbuilder 7.02 + oracle 8.1.5

my doubt is :
my datawindow works fine till it has around 950 elements (a long array)
when i have more, the retrieve returns -1. eg:
select * from table_a where id in (:l_var);

i found from the powerbuilder newsgroups that this is specific to Database vendor. what parameter in the Oracle should i redefine to increase or support an unlimited number or elements in the "IN CLAUSE "

TIA chandran
steelbird_at_hotmail.com Received on Mon Sep 23 2002 - 03:30:25 CDT