I struggling to genearte and store a pdf in database table through Oracle Form 4.5 on Windows XP & NT. So far I am able to generate a pdf through report called through a form which gets generated on client side. Now the problem is to store it to database table through form code. Any help to resolve the issue is highly appreciated. Thanks APG
If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.
Oracle Form how to store BLOB in DB
I struggling to genearte and store a pdf in database table through Oracle Form 4.5 on Windows XP & NT.
So far I am able to generate a pdf through report called through a form which gets generated on client side. Now the problem is to store it to database table through form code.
Any help to resolve the issue is highly appreciated.
Thanks
APG
declare
report_id report_object;
report_job_id varchar2(100);
begin
report_id:=find_report_object('ETA');
SET_REPORT_OBJECT_PROPERTY(report_id,REPORT_EXECUTION_MODE,RUNTIME);
SET_REPORT_OBJECT_PROPERTY(report_id,REPORT_COMM_MODE,ASYNCHRONOUS);
SET_REPORT_OBJECT_PROPERTY(report_id,REPORT_DESTYPE,FILE);
SET_REPORT_OBJECT_PROPERTY(report_id,REPORT_SERVER,'');
SET_REPORT_OBJECT_PROPERTY(report_id,REPORT_DESFORMAT,'PDF');
SET_REPORT_OBJECT_PROPERTY(report_id,REPORT_DESNAME,'C:\\ETA\tester.pdf');
report_job_id:=run_report_object(report_id);
end;