Re: ORA-06502: PL/SQL: numeric or value error? Not to sure whats wrong.

On 8 Aug 2005 13:13:19 -0700, jimi_xyz_at_hotmail.com wrote:

>The thing is when i take this statement
>sql_final := 'SELECT DISTINCT projectid, jobordernumber, score(1)'
>and remove jobordernumber it works fine but when i add any more
>columns to the select clause i get this error..
>
> ORA-06502: PL/SQL: numeric or value error

You should post the *complete* package (you can't expect anyone is keeping your previous posts) and you should post the complete error stack.
Your ora-6502 can occur anywhere.

There is a flaw in your code that will result in ora-6502 when the location_array is empty. Your ELSE clause is hit for both location_array.count = 1 and location_array.count = 0;

--
Sybrand Bakker, Senior Oracle DBA