Re: Query Size limit in PL/SQL in Iracle 8i

Look at www.oracle.asktom.com and do a search there for in list I believe. There are better ways to do this.(Is a user really going to enter 10,000 names? How long would it take for them to pick 10,000 names to specify.) Jim

--
Replace part of the email address: kennedy-down_with_spammers_at_attbi.com
with family.  Remove the negative part, keep the minus sign.  You can figure
it out.
"R197509" <ramsunders_at_yahoo.com> wrote in message
news:1e562f83.0304172044.15f81c7a_at_posting.google.com...


> Hi,

>    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:

>    1. Is there a limit to the size of the query that Oracle supprts?

>    2. 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?

>

> Regards,

> Ram.