Sunday, June 14, 2015

Oracle the equavilant of run_product = RUN_REPORT_OBJECT in oracle 10g and 11g


 
DECLARE 
    Repid REPORT_OBJECT; 
    v_rep VARCHAR2(100); 
    rep_status VARCHAR2(20); 
BEGIN 
    repid := FIND_REPORT_OBJECT('REPORT5'); 
    set_report_object_property(repid, REPORT_EXECUTION_MODE, BATCH);
    set_report_object_property(repid, REPORT_SERVER, 'rep_synntm172_fr');
    set_report_object_property(repid, REPORT_COMM_MODE, SYNCHRONOUS);
    set_report_object_property(repid, REPORT_DESTYPE, CACHE);
    set_report_object_property(repid, REPORT_DESFORMAT, 'PDF');
    set_report_object_property(repid, REPORT_FILENAME, '\\synntm53\repogi\GAG_RPAC.RDF');

    v_rep := RUN_REPORT_OBJECT(repid);

END;

No comments:

Post a Comment