Re: I can't find the right trigger
From: Kuba Flejmer <jflejmer_at_safo.com.pl>
Date: Wed, 3 Jan 2001 14:57:15 +0100
Message-ID: <92vb4c$dvj$1_at_news.tpi.pl>
Date: Wed, 3 Jan 2001 14:57:15 +0100
Message-ID: <92vb4c$dvj$1_at_news.tpi.pl>
Hello,
You can make another table only with two columns:
SESSION_ID from table V$SESSION (column SID) and the max(code) from table A.
Then update or insert this table in the procedure. Then read it in
POST_INSERT trigger.
This is the method to read from stored procedure.
Another, and the faster method is: add column SID to table A and ..., but
it's not "nice" idea.
Greetings
Kuba
Received on Wed Jan 03 2001 - 14:57:15 CET