Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Storing Image from client to DB Server with PL/SQL
I would like to seek your help in my struggle to generate and store a PDF
in database table through Oracle Form 4.5 on Windows XP & NT.
Oracle server version is 8.1.7
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.
The pdf which gets generated through form resides on client machine, I am thinking somehow the pdf should be generated on filesystem of oracle db server or it should be possible to read the pdf from client and store it in db table through sql/pl-sql ?
Any help to resolve the issue is highly appreciated.
Thanks in advance,
APG Below is the code I am using to generate pdf through oracle form:
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;
-- Message posted via http://www.dbmonster.comReceived on Tue Mar 15 2005 - 09:10:09 CST