java.sql.Exception:ORA-00604:error occured at recursive SQL Level 1

[Former Member]

Hi Team,

     We are facing cursor issue due to many numbers of procedures(60) getting called during report generation. I am unable to locate the solution i have been struggling from a week to resolve the issue. As i don't know how the Crystal reports handles to close database connection.Please help me in this.

Ideas are highly Appreciated.

Thanks

Rao

[Former Member]

To close db connections, you would need to call reportclientdocument.close() method.

reportclientdocument is an object of ReportClientDocument class

Thanks,

Prithvi

[Former Member]

Hi Prithvi,

     I am already closing the same in my code still i am facing the issue when i deployed in Web sphere community edition server. But i didn't face any issue with Tomcat. Thats why i am bothering about how to fix the issue.

Thanks

Penchal