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

"Filiz Duman" <filiz.duman_at_bt.com> wrote in message
news:an1p8l$o92$1_at_pheidippides.axion.bt.co.uk...
> 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.
>

trying to kill performance ?
anyway, your varchar2 variable is most likely too small to hold the resultset.
expand the variable to 32767, which is max. or modify your like condition.

Regards,
Keld Received on Sat Sep 28 2002 - 14:07:27 CDT