Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » ORA-06502: PL/SQL: numeric or value error (Oracle 10g,Win 7 32 bit,Apex 4.0)
ORA-06502: PL/SQL: numeric or value error [message #626670] Thu, 30 October 2014 07:58 Go to next message
Xandot
Messages: 235
Registered: January 2014
Location: India
Senior Member
Hello,

I have one interactive report so when i click into the column link for filtering the data then the following error message coming ..

ORA-06502: PL/SQL: numeric or value error: character string buffer too small


What is the cause behind this error, please help me out.


Thanks,
Xandot
Re: ORA-06502: PL/SQL: numeric or value error [message #626676 is a reply to message #626670] Thu, 30 October 2014 10:10 Go to previous messageGo to next message
Michel Cadot
Messages: 67148
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

You tried to put some data in some buffer (variable) which is too small for this data.

Re: ORA-06502: PL/SQL: numeric or value error [message #626677 is a reply to message #626676] Thu, 30 October 2014 10:22 Go to previous message
Xandot
Messages: 235
Registered: January 2014
Location: India
Senior Member
Thanks Michel. Variable size problem, resolved.Smile

Previous Topic: Scroll top of the page
Next Topic: Validation of Item
Goto Forum:
  


Current Time: Tue Jun 02 20:22:14 CDT 2020