How to get ride of ORA-01426: numeric overflow error?

[slimdave]

Slimdave... can you please give some more clear idea about whats the need of putting N = 100 as default value.?..

I was cheating by using a precalculated value. Note that I changed the return type of the function to varchar2 also.