Home » Developer & Programmer » Forms » Long Text Data (Forms 6i)
Long Text Data [message #671961] Wed, 26 September 2018 06:02 Go to next message
syedferhat
Messages: 15
Registered: February 2013
Location: Karachi, Pakistan
Junior Member
Dear All

I am using forms 6i and tried to store huge text data in Variable but getting error ora-06502. I also tried to used long instead of varcahr2 but still getting error.

Actually I just saved the entire results of the cursor into single variable

Can any one suggest what is the possible solution of the same

CODE OF THE PROGRAME
DECLARE 

CURSOR C1 IS 

 	SELECT ORD_DET.ASSIGN_TO,BRANCH.BRANCH_DESC,CUSTOMER.NAME,CATAG.CAT_NAME,
				ORD_DET.REP_NAME, MAST.INQ_DATE,ORD_DET.REP_CONT,ORD_DET.INQ_NO,INQ_ORD_CODE 
				 
				FROM CUSTOMER , MAST , ORD_DET,BRANCH,CATAG
				WHERE CUSTOMER.CODE = MAST.CUST_ID
				AND ORD_DET.INQ_NO = MAST.INQ_NO
				AND BRANCH.CODE=ORD_DET.ASSIGN_TO
				AND CATAG.CAT_CODE=ORD_DET.P_ID
				AND INQ_DATE  <=SYSDATE -1
				AND ORD_DET.STATUS IN ('OPERATION')
			  ---	AND ORD_DET.ASSIGN_TO in ('124','23')
			---- 	AND (ORD_DET.INQ_NO='113553' or ORD_DET.INQ_NO='342136')
				AND P_ID IN (	'013','054','049','018','057','089')
				ORDER BY ORD_DET.ASSIGN_TO,CUSTOMER.NAME,INQ_DATE,CATAG.CAT_NAME;
  l_html long ;

BEGIN
  For M in Inq_Pending
  Loop
    l_html := l_html||'<tr bgcolor="#BED8F7">'||'<TD>'||M.Inq_no||'</TD><TD>'||M.INQ_ORD_CODE||
              '</TD><TD>'||M.inq_date||'</TD><TD>'||M.Name||'</TD ><TD>'||M.Cat_Name||
              '</TD><TD>'||M.REP_NAME||'</TD>'||'<TD>'||M.REP_CONT||'</TD>';
  END LOOP;
I will be greatfull if somebody helps me with example
Thanks


[EDITED by LF: applied [code] tags & slightly formatted code]

[Updated on: Sat, 29 September 2018 09:37] by Moderator

Report message to a moderator

Re: Long Text Data [message #671975 is a reply to message #671961] Wed, 26 September 2018 09:37 Go to previous messageGo to next message
John Watson
Messages: 8544
Registered: January 2010
Location: Global Village
Senior Member
Your code makes no sense as written, for example what is this Inq_Pending cursor through which you are looping? You need to post the code that you are actually running with the error. And please use [code] tags to make the code easier to read.
Re: Long Text Data [message #672006 is a reply to message #671975] Thu, 27 September 2018 09:39 Go to previous message
cookiemonster
Messages: 13894
Registered: September 2008
Location: Rainy Manchester
Senior Member
And what are you planning on doing with this variable once it's populated?
Previous Topic: Display pdf file in Oracle Forms 10g
Next Topic: How to add animated buttons and analog clock in form
Goto Forum:
  


Current Time: Mon May 10 20:59:35 CDT 2021