Re: PL/SQL: Numeric or value errorr. Que?

From: <vjoshi_at_pinnacle.co.uk>
Date: Fri, 03 Jul 1998 10:18:01 GMT
Message-ID: <6nib4n$o9c$1@nnrp1.dejanews.com>

Hi,
I would think this happens because in your input parameter list you have a parameter specified as number, but when the function is passed parameters, there is alphabets being passed across. eg . create or replace function F_test(ip_par1 in number,

                                       ip_par2 in number)

.....
And then you have something like
...

   select F_test('HELLO','2') from dual; ....
Then you are likely to get that error.

If you find that is the problem
please drop me an email at
vjoshi_at_pinnacle.co.uk

In article <01bda4be$29e77ca0$c12017ac_at_sherekahn>,   "T-Pro" <tprijt_at_bigfoot.com> wrote:
>
> 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
>
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Fri Jul 03 1998 - 05:18:01 CDT