Sunday, February 5, 2017

Oracle Forms 6i. My issue is that I want generate the report directly into a PDF format without demand me which output format




I have a report that I called from Oracle Forms 6i. My issue is that I want generate the report directly into a PDF format without demand me which output format I want.below the code used to call and generate the report from Oracle forms (trigger WHEN_BUTTON_PRESSED):

DECLARE 
p_list PARAMLIST
;
BEGIN
p_list
:=CREATE_PARAMETER_LIST('TEMP');
ADD_PARAMETER
(p_list,'PARAMFORM',TEXT_PARAMETER,'YES');
ADD_PARAMETER
(p_list,'ep',TEXT_PARAMETER,':exer');
ADD_PARAMETER
(p_list,'cc',TEXT_PARAMETER,':code');
ADD_PARAMETER
(p_list,'op',TEXT_PARAMETER,':ordr');
ADD_PARAMETER
(p_list,'nume',TEXT_PARAMETER,':nume');
ADD_PARAMETER
(p_list,'DESTYPE',TEXT_PARAMETER,'SCREEN');
RUN_PRODUCT
(REPORTS,'D:\Reports\MyReport6i.RDF',SYNCHRONOUS,RUNTIME,FILESYSTEM,p_list,null);
IF NOT(ID_NULL(p_list)) THEN
DESTROY_Parameter_List
(p_list);
END IF;
END;

No comments:

Post a Comment

How to install and configure Oracle Apex 24.1 with ORDS 22, Tomcat 9 and Jasper Report 7 on Oracle Linux 8.10

#########################Install Oracle  APEX 24.1################################ ----------------------------------------------------...