| Automatically Attach RP2RRO [message #413206] |
Tue, 14 July 2009 15:20  |
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 #418374 is a reply to message #414225] |
Fri, 14 August 2009 07:44  |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
