Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> open cursors problem in trigger
Hi guys,
We're using OCI to connect Oracle database (Oracle 8.1.7 on Solaris/Linux),
everything seems fine except open cursors while we use triggers.
What we do just pass call OCIStmtExecute with a SQL statement, for example
"BEGIN INSERT ... INTO table;END;COMMIT;" and trigger will generate an audit
table for it. Technically all cursors should be closed after this
transaction, but while I "SELECT count(*) from v$open_cursor;" I found it
always increases, and eventually I will get an open cursors exceeds error.
Do you guys have any idea about that ?
Thanks very much.
Hugo
Received on Mon Mar 11 2002 - 19:10:03 CST