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

From: Chow Hoi Ka, Eric <eric138_at_yahoo.com>
Date: Sat, 04 Sep 1999 23:22:10 +0800
Message-ID: <37D13922.4F44B9DB@yahoo.com>

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 Sat Sep 04 1999 - 10:22:10 CDT