Oracle Form how to store BLOB in DB - TechRepublic
General discussion
March 14, 2005 at 07:09 PM
ajaypgoyal

Oracle Form how to store BLOB in DB

by ajaypgoyal . Updated 21 years, 3 months ago

Hi,

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;

This discussion is locked

All Comments