Discussion Locked

Oracle Form how to store BLOB in DB

0 helpful
0 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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;

0 replies

No replies were posted before this discussion closed.

This discussion is closed to new replies.