Hi Experts,
I am facing the Max open cursors exceeded error when I try to run a pl/sql program from c++ using pro c code.
I have enabled event trace to find the package. and below is the trace. App team claims that the cursors are closed in thsi package where as I see this package everytime when ORA-01000 error is captured.
Max open cursors are set to 2400 .
<code>
dbkedDefDump(): Starting a non-incident diagnostic dump (flags=0x0, level=3, mask=0x0)
----- Error Stack Dump -----
<error barrier> at 0x7ffc5f012930 placed dbkda.c@296
ORA-01000: maximum open cursors exceeded
----- Current SQL Statement for this session (sql_id=6vcmqng9wkpnd) -----
----- PL/SQL Stack -----
----- PL/SQL Call Stack -----
object line object
handle number name
0x726ff0f0 479 package body
0x72690638 1 anonymous block
</code>
Is there a way to drill down to the specific cursor name from where the cursors are leaking.
Guidance on this is very much helpful.
Thanks