REP-300: invalid number when calling reports from forms using run_report_ob
myluismMar 12 2013 — edited Mar 12 2013Hi 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 .....!