Skip to Main Content

Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Please ask technical questions in the appropriate category. Thank you!

how to save a report in the local system in Oracle 12c

user-bj2nlOct 5 2023 — edited Oct 5 2023

how to save a report in the local system in Oracle Forms 12c. Like in Forms 6i, we are using the run_product() procedure to save a report in the local system

    pl_id := create_parameter_list('us00300p');
        add_parameter(pl_id,'paramform',text_parameter,'no');
        add_parameter(pl_id,'xiposl',text_parameter,sl_no); 
           and so on
    run_product(reports,filepath&filename,synchronous,runtime,filesystem,pl_id,null);

how to replace this procedure in Forms 12c instead of using it to save files in the local system. This is Forms 6i code how to write like this in Forms 12c

    select ora_12c,report_server,rep_str into m_12c,vc_reportserver,mrep_str from table_name; 
    
    if m_12c = 1 then
        v_report_id := find_report_object('rat');
    
           SET_REPORT_OBJECT_PROPERTY(report_id,REPORT_COMM_MODE,SYNCHRONOUS);
         SET_REPORT_OBJECT_PROPERTY(report_id,REPORT_DESTYPE,CACHE);
           SET_REPORT_OBJECT_PROPERTY(report_id, REPORT_DESFORMAT,'pdf');
           SET_REPORT_OBJECT_PROPERTY(report_id,REPORT_SERVER,vc_reportserver);
           SET_REPORT_OBJECT_PROPERTY(report_id,report_filename,Filepath&FileName);
           v_ReportServerJob := run_report_object(report_id,pl_id);
           vjob_id := substr(ReportServerJob,instr(ReportServerJob,'_',-1)+1);
           vc_rep_status := REPORT_OBJECT_STATUS(ReportServerJob);
           
    IF  vc_rep_status = 'FINISHED' THEN
    
      --WEB.SHOW_DOCUMENT (serverURL,Servername,Jobid,'_blank');
           How to replace this for save a report in the local system without opening browser
This post has been answered by user-bj2nl on Oct 26 2023
Jump to Answer
Comments
Post Details
Added on Oct 5 2023
11 comments
333 views