Hi All,
I am getting the below error in my report.
RQP-DEF-0177 - An error occured while performing operation 'sqlPrepareWithOptions' status='-9'
In the details window the following are shown:
UDA_SQL-0107 - a general exception occured during the operation "prepare"
ORA-00604 - error occured at recursive SQL level 1
ORA-01000 - maximum open cursors exceeded.
This report is using many joins and unions and has quite a lengthy query structure.
Apart from that i have set the following properties to the query
Cross Product :Allowed. The cross join is happening with a table that has one row, we need to use this table for a measure calculation.
Processing : Limited Local . This was needed because the query was throwing an error. i have set this property only at the final level.
I have 15 pages all of which have to be shown, when i run the individual pages they work fine but when i run the report as a whole the above error occurs. What is the reason for this and what could be the workaround? Any suggestions would help.
Thanks.
I don't use Oracle, so I don't know if this is useful, but a quick google search on that error code returned this:
http://www.orafaq.com/wiki/ORA-01000
Thanks.. I will pass the link on to the DBA i.e. if we get the permission to alter the cursors etc.