FRM-41214 when try to send output to printer
427501Aug 11 2004 — edited Aug 11 2004If anyone can solve this problem, I will be VERY grateful!!!
I have setup OracleAS 10g on win2k server. I can use my web browser to run a report either cache to PDF that shows in the browser or print to a network printer installed on the OracleAS win2k server. So that part works fine.
Now when I try to run the same report from a forms module, I can can get web.show_document to send a PDF file to a browser window. But I cannot get run_report_object to send the output to the network printer on the OracleAS win2k server. It keeps giving error FRM-41214 Unable to run report.
Below is the code the I am using. In this case, I know that the run_report_object works because the report is returned to a new browser window. I'm just now sure what the parameters should be to get the report to go directly to the network printer like it does when I run the report via a browser. Any ideas? Thanks is advance for your help!!!
Declare
repid report_object;
v_rep varchar2(100);
v_repserver varchar2(20);
v_jobid varchar2(10);
v_repstat varchar2(20);
BEGIN
if :rec_no is null then
message ('Payment has not been accepted.');
BELL;
else
repid := find_report_object('REPORT55');
v_repserver := 'repserver';
set_report_object_property(repid,REPORT_DESTYPE, CACHE);
set_report_object_property(repid,REPORT_DESFORMAT, 'PDF');
set_report_object_property(repid,REPORT_SERVER, v_repserver);
set_report_object_property(repid,report_filename, 'pay_receipt.rdf');
set_report_object_property(repid,report_other, 'paramform=no sel_rec_no='||:rec_no);
v_rep := RUN_REPORT_OBJECT(repid);
if v_rep is not null then
v_jobid := substr(v_rep,(instr(v_rep,'_',-1)+1));
v_repstat := report_object_status(v_rep);
end if;
if v_jobid > 0 then
web.show_document ('/reports/rwservlet/getjobid'|| v_jobid ||'?server='|| v_repserver,'_blank');
end if;
end if;
end;