: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.
Firstly as :cli.id_cliente is a NUMBER then you need a to_char around it in your set_report_object_property command.
Secondly, I pass parameters by using the add_parameter() built-in and adding them to the paramlist that you pass in the run_report_object command. Then you don't have the problem of trying to string together a bunch of parameters. I think that this lets you keep the data types a little better typed when they are transferred to the report.