OraFAQ Forum: Forms » Variable can't hold 4000 characters

Home » Developer & Programmer » Forms » Variable can't hold 4000 characters

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Variable can't hold 4000 characters [message #536773]

Thu, 22 December 2011 16:07

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.

Report message to a moderator