Home » Developer & Programmer » Forms » Automatically Attach RP2RRO (Forms 10g)
Automatically Attach RP2RRO [message #413206] Tue, 14 July 2009 15:20 Go to next message
igorcb
Messages: 27
Registered: October 2008
Junior Member
Automatically Attach RP2RRO

I have 2,000 forms to migrate from 6i to 10g.
My first problem is that when I use Forms Migration Assistant the sentences that I use for calling report is replaced with RP2RRO.setDestype and rp2rro.rp2rro_run_product, that would be great if Forms Migration Assistant also would attach rp2rro.pll automatically, but it doesn't.

Is there any way to automatically attach this PLL?

How about webutil.pll? I'm also having problems with forms that use sentences like 'GET_FILE_NAME'

Thanks on advance for your answer

Igor
Re: Automatically Attach RP2RRO [message #413367 is a reply to message #413206] Wed, 15 July 2009 07:27 Go to previous messageGo to next message
igorcb
Messages: 27
Registered: October 2008
Junior Member
Help
Re: Automatically Attach RP2RRO [message #414225 is a reply to message #413206] Tue, 21 July 2009 01:54 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
How many forms call a report? I suggest changing them to 'web.show_document'.

With which part of 'get_file_name' are you having a problem? Remember you are now in a 3-tier environment and may need to get the file from either the server or the client. Different location = different command.

David
Re: Automatically Attach RP2RRO [message #418374 is a reply to message #414225] Fri, 14 August 2009 07:44 Go to previous message
igorcb
Messages: 27
Registered: October 2008
Junior Member
Thanks for your answer I have been working with this and the problem was fixed.

What I did was apply the patch to forms, and configure correctly following steps I found in Metalink, after that Forms Migration Assistant attached the library automatically.

I developped a proccess that I manually attach to each form, just to make the forms call the report correctly:

PROCEDURE PR_EJECUTAREPORTE (p_reporte in varchar2, pl_id in ParamList)IS
v_rep VARCHAR2(100);
rep_status Varchar2(20);
begin
SET_REPORT_OBJECT_PROPERTY('RP2RRO',REPORT_FILENAME,p_reporte);
SET_REPORT_OBJECT_PROPERTY('RP2RRO',REPORT_OTHER,'paramform=no');
SET_REPORT_OBJECT_PROPERTY('RP2RRO',REPORT_DESTYPE,CACHE);
SET_REPORT_OBJECT_PROPERTY('RP2RRO',REPORT_EXECUTION_MODE,BATCH);
SET_REPORT_OBJECT_PROPERTY('RP2RRO',REPORT_COMM_MODE,SYNCHRONOUS);
SET_REPORT_OBJECT_PROPERTY('RP2RRO',REPORT_DESFORMAT,:formato);
SET_REPORT_OBJECT_PROPERTY('RP2RRO',REPORT_SERVER,'rep_serv');

v_rep := RUN_REPORT_OBJECT('RP2RRO', pl_id);
rep_status := report_object_status(v_rep);
WHILE rep_status in ('RUNNING','OPENING_REPORT','ENQUEUED') LOOP
rep_status := report_object_status(v_rep);
END LOOP;
if rep_status = 'FINISHED' then
WEB.SHOW_DOCUMENT('/reports/rwservlet/getjobid'||substr(v_rep,instr(v_rep,'_',-1)+1)||'?'||'server=rep_serv','_blank');
else
message('error en la ejecuciĆ³n');
end if;
END;
thanks for your help
Previous Topic: Passing Parameters-form to report, print to csv (merged)
Next Topic: FRM-50016: Legal characters are 0-9-+E
Goto Forum:
  


Current Time: Sat Dec 03 01:36:36 CST 2016

Total time taken to generate the page: 0.25089 seconds