Report no generate pages when call procedure

Hi,

I created a procedure into mysql, when I try to call the procedure, the result not generate pages, this its the call that I add into Reqport Query:

 call hourly_gas_change($P{DATE}, $P{TANK})   Date its String and Tank its Integer

But if I tried to call the procedure and send directly the data of params, the report show me a correctly result

ex: call hourly_gas_change('2015-10-27', 3) 

 

 

juankav89's picture
Joined: Feb 19 2015 - 1:19pm
Last seen: 7 years 5 months ago

Are you sure the parameters are the correct data type? Also that the date's format is the same as the one you are using the MySQL's stored procedure?

javier.ggi90 - 7 years 5 months ago

0 Answers:

No answers yet
Feedback