Re: HELP : ORA-06502: PL/SQL: numeric or value error

From: John Chiu <johnymc_at_netscape.com>
Date: Sun, 05 Sep 1999 07:18:25 -0400
Message-ID: <37D25181.D328ADED@netscape.com>

Are you using java stored procedure? make sure the data type matches in your procedure/function/package spec.

john chiu
johnymc_at_netscape.net

Chow Hoi Ka, Eric wrote:

> Hello,
>
> I am using Oracle8i.
> When I use PL/SQL, a error occured : ORA-06502: PL/SQL: numeric or value
> error
> I don't know what's wrong with my query. And I tried to run the query in
> SQLPLUS,
> it can run successfully. But failed in PL/SQL program.
> Would you please to tell me what's the problem if I met this error ?
>
> Best regards,
> Eric
>
> --
> _ _
> / ) |~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ( \
> / / | | \ \
> _( /_ | _ Chow Hoi Ka, Eric _ | _) )_
> (((\ \> |/ ) ( \| </ /)))
> (\\\\ \_/ / \ \_/ ////)
> \ / E-Mail : eric138_at_yahoo.com \ /
> \ _/ \_ /
> / / |____________________________________________| \ \
> / / \ \
Received on Sun Sep 05 1999 - 06:18:25 CDT