Home » Developer & Programmer » Forms » Variable can't hold 4000 characters
Variable can't hold 4000 characters [message #536773] Thu, 22 December 2011 16:07 Go to next message
Messages: 20
Registered: November 2006
Location: rockville, MD
Junior Member
I have error message when running duplicate : FRM-21011: PL/SQL unhandled exception ORA-06502

I'm trying to hold 4000 characters in a variable like what do below:
if s_str is NULL then
s_str := eachcol.column_name||'{{'||
s_str := s_str||eachcol.column_name||'{{'||
end if;

Not sure what i do wrong? It's simple variable to hold value but still can't get by large string though.

Any input would be greatly appreciated.

Re: Variable can't hold 4000 characters [message #536779 is a reply to message #536773] Fri, 23 December 2011 00:05 Go to previous message
Messages: 21127
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Where and how is S_STR declared? What software version do you use?
Previous Topic: Dynamic table in form
Next Topic: checking for password verification for 3 counts
Goto Forum:

Current Time: Thu Jul 20 23:45:42 CDT 2017

Total time taken to generate the page: 0.06412 seconds