2 Replies Latest reply: Mar 12, 2013 10:18 AM by myluism RSS

    REP-300: invalid number when calling reports from forms using run_report_ob

    myluism
      Hi all.

      I'm using Foms / Reports 11g Rel2 on my Windows 7 box.

      When trying to call a reports from forms using run_report_object i get REP-300 passing a single parameter.


      set_report_object_property(v_report_id,REPORT_OTHER,*'P_CLIENTE='||:cli.id_cliente*||'paramform=no');

      :cli.id_cliente is a NUMBER parameter of precision 8 (Data Length Semantics NULL).

      the report fails and this is found on showjobs:

           
           The report terminated with error:
      REP-300: invalid number WHERE ORD.ID_CLIENTE = CLI.ID_CLIENTE AND ORD.ID_REPRESENTANTE_VENTAS = EMP.ID_EMPLEADO AND ORD.ID_ORDEN = DET.ID_ORDEN AND
      DET.ID_PRODUCTO = PRD.ID_PRODUCTO AND ORD.ID_CLIENTE = : ==> P_CLIENTE ORDER BY 1 ASC,2 ASC,3 ASC,4 ASC,5 ASC,6 ASC , ORD.ID_ORD .

      I have tried several changes like running RDF o REP file, changing P_CLIENTE report parameter from NUMBER to CHARACTER back and forth, but there is no way i can make it run.

      If report is run from builder works fine.

      What seems to be the problem here ....?????

      Best regards, luis .....!