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
michaelv
Messages: 20
Registered: November 2006
Location: rockville, MD
Junior Member
Hi
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||'{{'||
name_in(name_in('system.cursor_block')||'.'||eachcol.column_name)||'{{';
else
s_str := s_str||eachcol.column_name||'{{'||
name_in(name_in('system.cursor_block')||'.'||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.

Thanks.
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
Littlefoot
Messages: 19314
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: Fri Jul 25 14:18:16 CDT 2014

Total time taken to generate the page: 0.21832 seconds