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_at_yahoo.com>

Hello,

I am using Oracle8i.
[Quoted] [Quoted] When I use PL/SQL, a error occured : ORA-06502: PL/SQL: numeric or value error
[Quoted] I don't know what's wrong with my query. And I tried to run the query in SQLPLUS,
[Quoted] 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 - 17:22:10 CEST

This message: [ Message body ]
Next message: Chris Klingman: "JOB:CA-Moutain View-Director Product Management (correction)"
Previous message: Chris Klingman: "JOB:CA-Mountain View-Product Marketing Director"
Next in thread: Yar: "Re: HELP : ORA-06502: PL/SQL: numeric or value error"
Reply: Yar: "Re: HELP : ORA-06502: PL/SQL: numeric or value error"
Reply: John Chiu: "Re: HELP : ORA-06502: PL/SQL: numeric or value error"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message