Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Storing Image from client to DB Server with PL/SQL

Storing Image from client to DB Server with PL/SQL

From: APG via DBMonster.com <forum_at_DBMonster.com>
Date: Tue, 15 Mar 2005 15:10:09 GMT
Message-ID: <91c1774294fd4edda8afc7ae87583153@DBMonster.com>


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.com
Received on Tue Mar 15 2005 - 09:10:09 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US