Oracle Function - Where is the data stored?

[saw15]

Using a oracle function within 8.1.7, the function determines the total # claims within an age bracket. There are approx 25 age brackets. (Question is at the bottom)

The function fails when trying to calc all age brackets with the following error:

ORA-06502: PL/SQL: numeric or value error: character string buffer too small ORA-06512: at line 1

But the function runs successfully when I only use one or two brackets. It appears that the designated storage area for a function is set incorrect.

MY QUESTION IS: Where to I adjust the storage parameters for the function?

 

[OraCool]

Hi Saweens

Looks like you are building a string that is store in some defined variable. So check by increasing any such Varchar2 variable and test it again. It could also be a numeric variable that is overflowing its max value. Eg x number(2,0) and you are trying to store 100 in 'x' when it can onlt hold 99.

Regards

 

[saw15]

Thanks OraCool ..

Correct .. we are storing the function value in a number (within the function), the number is currently set to unlimited. It is then within the sql query, that we pass that number (zero or one) back to a group within a age bracket (ex.. age_1_5). This # is then summed up within each age bracket.

The function actually runs correct, its when that number from the function variable is passed back into the sql variable (age_1_5) where the statement is blowing up, giving the posted error.

Any other ideas? Do appreciate your assistance.