Home » Other » Test » test
test [message #294612] Fri, 18 January 2008 03:31 Go to next message
misragopal
Messages: 125
Registered: June 2005
Location: New Delhi, india
Senior Member

Quote:
select

trst
Re: test [message #294620 is a reply to message #294612] Fri, 18 January 2008 04:01 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Good test!

Regards
Michel
Re: test [message #294631 is a reply to message #294620] Fri, 18 January 2008 04:20 Go to previous messageGo to next message
misragopal
Messages: 125
Registered: June 2005
Location: New Delhi, india
Senior Member

sorry Michel,
Still i am learing.. how to follow orafaq rules.. Smile. I would like to say that i adore you because u are really maintaining a discipline in boxes.
great job. really.
Re: test [message #294639 is a reply to message #294631] Fri, 18 January 2008 04:47 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Why are you sorry? It was sincere, it is a good test.

Regards
Michel
Re: test [message #296151 is a reply to message #294639] Thu, 24 January 2008 21:12 Go to previous messageGo to next message
sasipalarivattom
Messages: 121
Registered: June 2007
Location: Cochin ( INDIA )
Senior Member
BEGIN
	v_report_server := cmsGetCounter.db_get_repserver;
	v_report_id := FIND_REPORT_OBJECT(p_rep_name);
	SET_REPORT_OBJECT_PROPERTY(v_report_id,REPORT_COMM_MODE,SYNCHRONOUS);
	SET_REPORT_OBJECT_PROPERTY(v_report_id,REPORT_DESTYPE,cache);
	SET_REPORT_OBJECT_PROPERTY(v_report_id,REPORT_DESFORMAT,'PDF');
	SET_REPORT_OBJECT_PROPERTY(v_report_id,REPORT_SERVER,v_report_server);
	SET_REPORT_OBJECT_PROPERTY(v_report_id,REPORT_OTHER,'p_start_date='||:param.date_from||' p_end_date='||:param.date_to);
	vc_ReportServerJob := RUN_REPORT_OBJECT(v_report_id);
	vjob_id := substr(vc_ReportServerJob,length(v_report_server)+2,length(vc_ReportServerJob));
	vc_rep_status := REPORT_OBJECT_STATUS(vc_ReportServerJob);
	
	IF vc_rep_status = 'FINISHED' THEN
	   WEB.SHOW_DOCUMENT ('/reports/rwservlet/getjobid'|| vjob_id||'?server='||v_report_server,'_blank');
	ELSE
		Alerts.stop_alert ('Report failed with error message '||vc_rep_status,choice);
	END IF;
	
	return (vc_rep_status);
END;



Quote:
Still i am learing.. how to follow orafaq rules.. Smile. I would like to say that i adore you because u are really maintaining a discipline in boxes.

[Updated on: Thu, 24 January 2008 21:13]

Report message to a moderator

Re: test [message #296749 is a reply to message #294612] Mon, 28 January 2008 23:24 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Edit Linesize.
Re: test [message #296778 is a reply to message #296749] Tue, 29 January 2008 01:03 Go to previous messageGo to next message
Frank
Messages: 7901
Registered: March 2000
Senior Member
Why?
Re: test [message #296887 is a reply to message #296778] Tue, 29 January 2008 07:11 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
To keep them below 80 characters.

Regards
Michel
Re: test [message #296953 is a reply to message #294612] Tue, 29 January 2008 11:09 Go to previous message
varu123
Messages: 754
Registered: October 2007
Senior Member
Thats a good test
BEGIN
  V_REPORT_SERVER := CMSGETCOUNTER.DB_GET_REPSERVER;
  
  V_REPORT_ID := FIND_REPORT_OBJECT(P_REP_NAME);
  
  SET_REPORT_OBJECT_PROPERTY(V_REPORT_ID,REPORT_COMM_MODE,SYNCHRONOUS);
  
  SET_REPORT_OBJECT_PROPERTY(V_REPORT_ID,REPORT_DESTYPE,CACHE);
  
  SET_REPORT_OBJECT_PROPERTY(V_REPORT_ID,REPORT_DESFORMAT,'PDF');
  
  SET_REPORT_OBJECT_PROPERTY(V_REPORT_ID,REPORT_SERVER,V_REPORT_SERVER);
  
  SET_REPORT_OBJECT_PROPERTY(V_REPORT_ID,REPORT_OTHER,'p_start_date=' ||: PARAM.DATE_FROM
                                                      ||' p_end_date=' ||: PARAM.DATE_TO);
  
  VC_REPORTSERVERJOB := RUN_REPORT_OBJECT(V_REPORT_ID);
  
  VJOB_ID := SUBSTR(VC_REPORTSERVERJOB,LENGTH(V_REPORT_SERVER) + 2,
                    LENGTH(VC_REPORTSERVERJOB));
  
  VC_REP_STATUS := REPORT_OBJECT_STATUS(VC_REPORTSERVERJOB);
  
  IF VC_REP_STATUS = 'FINISHED' THEN
    WEB.SHOW_DOCUMENT('/reports/rwservlet/getjobid'
                      ||VJOB_ID
                      ||'?server='
                      ||V_REPORT_SERVER,'_blank');
  ELSE
    ALERTS.STOP_ALERT('Report failed with error message '
                      ||VC_REP_STATUS,CHOICE);
  END IF;
  
  RETURN (VC_REP_STATUS);
END;

Previous Topic: test
Next Topic: test2
Goto Forum:
  


Current Time: Thu Mar 28 07:34:33 CDT 2024