Hello Gurus,
I am using dbms_xmlgen.getxml function to generate xmltype output for a dynamic select statement.
Whenever the SELECT statement is well formed i.e., no parsing errors, it works fine for me. but, if at all the select statement will raise any parsing errors, the oracle opens a cursor select statement and doesn't close the cursor. Hence, it causes cursor leak and tries to kill the memory. I have written dbms_xmlgen.closecontext function in When others handler.
Please let me know, how to close the open cursor, which is being opened for a parsing failed SELECT query.
Thanks,
Rajendra