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

Report message to a moderator

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: 68641
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.

Report message to a moderator

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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 18 17:35:30 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.