General discussion

  • Creator
    Topic
  • #2175557

    Oracle Form how to store BLOB in DB

    Locked

    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;

All Comments