Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

FRM-41214 when try to send output to printer

427501Aug 11 2004 — edited Aug 11 2004
If 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;

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 8 2004
Added on Aug 11 2004
4 comments
584 views