Home » SQL & PL/SQL » SQL & PL/SQL » ORA-06502: PL/SQL: numeric or value error in xmltype.getClobVal (Oracle 10g)
ORA-06502: PL/SQL: numeric or value error in xmltype.getClobVal [message #616494] Tue, 17 June 2014 09:32 Go to next message
rk_0711
Messages: 1
Registered: June 2014
Junior Member
Hi,

I am getting below error while performing 'xmltype.getClobVal'. If I limit the data in XMLTYPE to only few records the xml is properly getting generated? Any idea on how to overcome this error?

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

Thanks.
Re: ORA-06502: PL/SQL: numeric or value error in xmltype.getClobVal [message #616496 is a reply to message #616494] Tue, 17 June 2014 09:38 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
welcome to this forum.


Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/ and please read http://www.orafaq.com/forum/t/174502/102589/

06502, 00000, "PL/SQL: numeric or value error%s"
// *Cause: An arithmetic, numeric, string, conversion, or constraint error
//         occurred. For example, this error occurs if an attempt is made to
//         assign the value NULL to a variable declared NOT NULL, or if an
//         attempt is made to assign an integer larger than 99 to a variable
//         declared NUMBER(2).   
// *Action: Change the data, how it is manipulated, or how it is declared so
//          that values do not violate constraints. 
Previous Topic: IN Condition
Next Topic: Reqular expression
Goto Forum:
  


Current Time: Thu Apr 25 14:48:15 CDT 2024