This discussion is archived
2 Replies Latest reply: Mar 12, 2013 8:18 AM by myluism RSS

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

myluism Newbie
Currently Being Moderated
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 .....!

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points