ORA-06502: PL/SQL: numeric or value error-6502 - ANY IDEA ????

I have a HTML based input mask for a sql statement. As soon as the user press the Submit button I build (dynamically) a sql statement string and pass it to another page to show the results.

e.g. Select x,y,z from a, b c where condition1 or condition2 or condition3.

condition1 e.g:          x like '%NATL%'
condition2 e.g:         y like  '%Voice%'
condition3 e.g:        z like '%Y%'

The string as follows:

l_sqlstring varchar2(25000) := sqlstring;

Now to my problem:

Every time I extend the sql statement with the third condition and want to show the results it shows the ORA-06502: PL/SQL: numeric or value error-6502.
If I have just two conditions (no matter which one) it is working ok. The sql statement itself is not wrong since is working ok in the sql command prompt.

Any ideas ?

Thanks in advance. Received on Fri Sep 27 2002 - 09:11:57 CDT