DevOps, CI/CD and Automation

Hi,

I am facing a problem while adding a new parameter n my JSP Report JDBC query based on a ref-cursor from a stored procedure define in a package in database.

No problem at database level, I have added the new parameter in package specification and Package body for that procedure and compile my package, it complies without any error and warning.

but when I open the report and add parameter in the report JDBC query window, then it is generating a error message,

"Err 62007: SQL Error: 99999 ORA-24338: Statement Handle not Executed "

and I am unable to add the new parameter in report.

e.g.
Actual which was working is:
My-package.My-procedure(:P1,:P2,:P3 ,:P4,:P5,:P6,:P7)

I want to do this:
My-package.My-procedure(:P1,:P2,:P3 ,:P4,:P5,:P6,:P7,:P8)

but unable to do due to this error message:

("Err 62007: SQL Error: 99999 ORA-24338: Statement Handle not Executed ")


Reports Builder 10g:
Database 10g:
Operating system windows XP:
using JDBC Query base on ref-cursor coming from the stored procedure define in the Package.

Regards,
Khan