seo_katalogy
New Member
I am calling a function that returns a reference cursor, and I am using \[code\]XMLType.createxml\[/code\] to convert the results to XML, e.g.\[code\]select XMLType.createxml(package_name.storedProcName('PARAM1', 'PARAM2', 'PARAM3')) as sresult from dual;\[/code\]However, I have found this to have an unwelcome side-effect. It seems that the cursor used to retrieve the data for the XMLType is never closed. After calling the function many times using this technique, I always run into the following error:\[code\]ORA-01000: maximum open cursors exceeded\[/code\]I do not have a handle to the cursor, thus I cannot manually close it. Also, we are using pooled connections, so there is connection reset where these cursors can be automatically released. What can be done about this?Here is my Oracle version (as returned from v$version):\[code\]Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64biPL/SQL Release 10.2.0.5.0 - Production CORE 10.2.0.5.0 Production TNS for HPUX: Version 10.2.0.5.0 - Production NLSRTL Version 10.2.0.5.0 - Production\[/code\](For those interested, here is a link to my previous question related to XMLType.)