2 Replies Latest reply on Jan 14, 2020 5:30 PM by 3264593

    How to create a PDF file using RUN_REPORT_OBJECT?

    3264593
    3264593 Jan 13, 2020 6:39 PM

      Hi, i'm trying to generate a PDF file in a specific location using an Oracle Report and the RUN_REPORT_OBJECT built-in, but for some reasons it gives me the error FRM-41211: Integration errpr: SSL failure running another product.

       

      I'm doing something like this:

      DECLARE

      repid REPORT_OBJECT;

      v_rep VARCHAR2(100);

      rep_status VARCHAR2(20);

      plid ParamList;

      vParamValue number;

      BEGIN

       

       

      plid := Get_parameter_List('tmp');

       

       

      IF NOT Id_Null(plid) THEN

      Destroy_parameter_List( plid );

      END IF;

      plid := Create_parameter_List('tmp');

       

       

      Add_parameter(plid, 'PARAMFORM', TEXT_parameter, 'NO');

       

       

      repid := FIND_REPORT_OBJECT('REPORT_NAME');

       

       

      SET_REPORT_OBJECT_PROPERTY(repid,REPORT_COMM_MODE,SYNCHRONOUS);

      SET_REPORT_OBJECT_PROPERTY(repid,REPORT_DESTYPE,FILE);

      SET_REPORT_OBJECT_PROPERTY(repid,REPORT_DESNAME,'C\PDFS\');

      SET_REPORT_OBJECT_PROPERTY(repid,REPORT_FILENAME,'PDF_REPORT');

      SET_REPORT_OBJECT_PROPERTY(repid,REPORT_DESFORMAT,'PDF');

       

       

      SET_REPORT_OBJECT_PROPERTY(repid,REPORT_OTHER, 'paramform=no');

       

       

      v_rep := RUN_REPORT_OBJECT(repid,plid);

      rep_status := REPORT_OBJECT_STATUS(v_rep);

       

       

      WHILE rep_status in ('RUNNING','OPENING_REPORT','ENQUEUED') LOOP

      rep_status := report_object_status(v_rep);

      END LOOP;

      end;

       

      Any suggestion would be highly appreciated and an working example would be great.

       

      Thanks in advance.