Hi ,<BR><BR> I am working with an Oracle database and i have come across a problem which is new to me.I have an sql statement which is as shown below <BR><BR>select segment1,inventory_item_id from web_inventory_item where inventory_item_id in (" & inventory_item_id & ") and onhand_quantity &#062; 0<BR><BR>The inventory_item_id contains around 337 entries that are comma separated.<BR><BR>But this is the error that i come across .. Can somebody please help...<BR><BR>Microsoft OLE DB Provider for ODBC Drivers error &#039 80004005&#039 <BR><BR>[Microsoft][ODBC driver for Oracle][Oracle]ORA-01795: maximum number of expressions in a list is 254 <BR><BR>/order_placement1.asp, line 62