I am trying to implement ORARRP to print either text or pcl from web.show_document. This is ultimately to be able to print to a windows queue which is a redirect to a Doclink server to capture the report for document retention. The Doclink server can only read text or pcl and is able to decolate pages and self index for later retrieval.
My application server is on Windows Server 2003.
I have configured the httpd.conf with the following MIME types: (using Enterprise Manager Application Server Control)
application/x-orarrp-text .rrpt
application/x-orarrp-ps .rrpp
My form code is as follows: (directly from the white paper "Oracle Reports Remote Printing Utility - 1.3.4 with my parameters)
DECLARE
Report_Id report_object;
hTimer timer;
vcFile varchar2(255);
vcResult varchar2(30);
BEGIN
/* Generate a pseudo-unique filename */
vcFile := get_application_property(USERNAME)||TO_CHAR(SYSDATE,'YYYYMMDDHHMISS');
/* We will be producing Postscript output in this case so add a .rrpp extension */
vcFile := vcFile||'.rrpp';
/* Find an existing Report Object and set parameters */
report_id:=FIND_REPORT_OBJECT('test_report');
SET_REPORT_OBJECT_PROPERTY(report_id,REPORT_EXECUTION_MODE,BATCH);
SET_REPORT_OBJECT_PROPERTY(report_id,REPORT_DESTYPE,FILE);
/* Format to Postscript */
SET_REPORT_OBJECT_PROPERTY(report_id,REPORT_DESFORMAT,'ps');
/*Desname to our generated filename
Note: <PhysicalDir> refers to a location on the
Webserver which we read from with SHOW_DOCUMENT() */
SET_REPORT_OBJECT_PROPERTY(report_id,REPORT_DESNAME,'c:\runtime\'||vcFile);
/*Set the name of the Reports Server, again this would be softcoded */
SET_REPORT_OBJECT_PROPERTY(report_id,REPORT_SERVER,'rep_aporaapp_frhome1');
/* Save the Report Handle to a global as well */
:GLOBAL.ReportHandle := RUN_REPORT_OBJECT(report_id);
/* Save the generated Filename away for use in the When-Timer-Expired */
:GLOBAL.PrintOutPut := vcFile;
/* Create a timer to monitor the Report,
This one is set to check 4 times a minute */
hTimer := CREATE_TIMER('PRINTER_QUEUE','15000',REPEAT);
END;
When I run the form trigger I get:
FRM-41214: Unable to run report.
and if I run
http://aporaapp:7778/reports/rwservlet/showjobs
I get the following:
Terminated with error: <br>REP-826: Invalid printer driver 'ps' specified by parameter DESFORMAT.
I'm only able to get the report to compilete with REPORT_DESFORMAT,'pdf'
any help would be appreciated,
Louis
Edited by: user1065650 on Sep 29, 2009 2:26 PM
Edited by: user1065650 on Sep 29, 2009 3:24 PM