General discussion

Locked

Oracle Form how to store BLOB in DB

By ajaypgoyal ·
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 conversation is currently closed to new comments.

0 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Back to Web Development Forum
0 total posts (Page 1 of 1)  

Related Discussions

Related Forums