 How to store file in database table through Form [message #111236] |
Mon, 14 March 2005 19:22  |
APG
Messages: 2
Registered: June 2003
|
Junior Member |
|
|
Hi,
I struggling to generate and store a pdf in database table through Oracle Form 4.5
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;
|
|
|
|
| Re: How to store file in database table through Form [message #111249 is a reply to message #111236] |
Tue, 15 March 2005 00:08  |
 |
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
|
Senior Member
Account Moderator |
|
|
Quick reply is get the file and store it in a long field in a table. I assume that as you are using Forms 4.5 you are not running a 9i or 10i AS and will not have Oracle's IFS (Internet(?) File Server) running. I will look at a couple of books and get some code for you.
David
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
