PL/SQL: Numeric or value errorr. Que?

Ok, I don't get this one. Maybe you do:

I've got a function that determines if a user may execute a procedure with the given parameters. It uses several explicit cursors to determine this. Which cursors to use depends on the given parameters. This is done by evaluating what parameters are null-values. (IF par1 IS NULL THEN..)

The function compiles fine. Every now and then however I get a 6502: Numeric or value error. There is no pattern to be found (unless I have totally overlooked smomething). When the function is recompiled, it's fine again (note that the function is always valid, so there should be no need to recompile).

I'm using Oracle 7.3.2 on Windows NT 4.0.

If anyone has had similar experiences (or better yet: has a solution or workaround) I would be very grateful.

With regards,
Tony van der Prijt Received on Wed Jul 01 1998 - 02:02:51 CDT