Home » SQL & PL/SQL » SQL & PL/SQL » problem in 'IN' clause of select query (9i)
problem in 'IN' clause of select query [message #393932] Wed, 25 March 2009 00:59 Go to next message
rohitupgzp
Messages: 11
Registered: August 2008
Junior Member
1. Functionality: Customer uploads a file for bulk payments (up to 15 payments in one file). There is a BIC code for each payment in the file. We have to fetch additional Bank details using this BIC code from the DB before submitting the payment for processing through the application.
• We are trying to execute a select query with "IN" expression containing the BIC codes. It is not allowing us to put more than 1000 variables in the expression. Any idea why?
• The "IN" expression is used to fetch those additional details. Is there any other better way of obtaining this data?
Re: problem in 'IN' clause of select query [message #393935 is a reply to message #393932] Wed, 25 March 2009 01:22 Go to previous message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Quote:
It is not allowing us to put more than 1000 variables in the expression. Any idea why?
Because it is a limit.

A possible workaround might be storing these values into a separate table and use it as
...
where bic_code in (select bic_code from the_new_table)

[Updated on: Wed, 25 March 2009 01:23]

Report message to a moderator

Previous Topic: merge multiple varchar2 rows into one row of type CLOB
Next Topic: query to procedure
Goto Forum:
  


Current Time: Fri Dec 09 08:02:00 CST 2016

Total time taken to generate the page: 0.11301 seconds