SEO

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_EXECUT ION_MODE,RUNTIME);
SET_REPORT_OBJECT_PROPERTY(report_id,REPORT_COMM_M ODE,ASYNCHRONOUS);
SET_REPORT_OBJECT_PROPERTY(report_id,REPORT_DESTYP E,FILE);
SET_REPORT_OBJECT_PROPERTY(report_id,REPORT_SERVER ,'');
SET_REPORT_OBJECT_PROPERTY(report_id,REPORT_DESFOR MAT,'PDF');

SET_REPORT_OBJECT_PROPERTY(report_id,REPORT_DESNAM E,'C:\\ETA\tester.pdf');

report_job_id:=run_report_object(report_id);

end;

--
Message posted via http://www.dbmonster.com