I am unable to call stored procedure to generate reports in oracle

[c.chavda]

Hello All,

 

I am new to jasper reports. have to generate report from stored procedure. I am using oracle. had tried to call stored procedure but getting error as below :

Error: General problem: Parameter "ORACLE_REF_CURSOR" does not exist.Check username and password; is the DBMS active ?!

I had tested jdbc connection and it says "Connection Test Successful!"

Please help.

Thank in advance

[dnaboka]

Hi,

We regularly update our wiki knowledge base to answer questions like this:

http://community.jaspersoft.com/wiki/how-execute-oracle-stored-procedure-jasper-report-ireport-editor-environment

There's also a related article with instructions on how to enable usage of stored procedures on JasperReports Server