Can't do PLSQL procedure with Parameter in a SubReport

Hi all,

I've a main report with a single query like this : select id from etc...

After this I create a subreport (passing like a parameter the ID), in this subreport I execute a pl/sql procedure like this:

{call p_survey_report($P{ID},$P{REF_Cursor})}

 

But I can't see the result fields of the procedure, instead if  I insert the procedure in the Main Report with parameter I obtain the result.

The error is: "ORA-00909 number of argument is invalid" but I haven't changed any parameter/argument between the subreport and the main report

If I insert a number instead a P{ID} the procedure works well


Someone could help me please?

Thank You

Best Regards

 

valeroma88's picture
Joined: Jul 6 2016 - 6:09am
Last seen: 7 years 2 months ago

0 Answers:

No answers yet
Feedback