We are working on Oracle 8i in the UNIX environment. In the PL/SQL
layer, we are dynamically forming a query using values that were input
by the user.
For e.g., the user is allowed to enter upto 10000 names.
The query that would be constructed would be of the form:
Select col1, col2 from table_name where col3 in (<the list that was
enetered by the user>);
The above mentioned query might grow to a size of around 70K or
mroe depending on the user input.
Two doubts that we have are:
- Is there a limit to the size of the query that Oracle supprts?
- Since this string (the query formed) may have a length of 70K or
even more, which datatype can we use to store it. We believe the max.
size of a VARCHAR2 datatype is 32767. What datatype can we use to
store the query?
