Compound trigger in 11.1.0.6
Date: Thu, 19 Jun 2008 12:34:36 +0100
Message-ID: <5e317f310806190434mc6a391fx6db41e8b006143ad@mail.gmail.com>
Hi,
This is partly in desperation.
I have an SR open with Oracle since January 10th concerning a bug with
compound triggers.
I read up on them, looked at an article on the excellent Oracle-Base website
and went for it.
It all worked fine, until the real code in jdbc was run. All of a sudden the
client code got a disconnected and ORA-07445: exception encountered: core
dump [kkxtexe()+988] [SIGSEGV] showed up on the server. Oracle tell me the
problem is not jdbc related, its an rdbms problem but I could never
re-produce it using Sql*Plus. I narrowed it down in a jdbc example where any
more than 2 consecutive inserts re-produced the bug.
The problem appears at least in part to the use of PL a associative array or nested table.
Oracle tell me its fixed in 11.1.0.7, but I have been waiting for nearly 3 months since that statement was added to the SR.
So has anyone else come across this and a way of fixing it without having to fall back to coding a PL package solution that holds data at the session level?
Thanks
Pete
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Jun 19 2008 - 06:34:36 CDT