Bewarse Talk Discussion Board: Oracle Trigger issue

Bewarse Talk Discussion Board Archives - 2011 Cine Talk - Reviews, Gossips, Insider Info etc. Archive through November 17, 2011 Oracle Trigger issue - pls help

< Previous Next >

Author

Message

Dobbey
Kurra Bewarse
Username: Dobbey

Post Number: 3847
Registered: 03-2011
Posted From: 99.119.215.125

Rating: N/A
Votes: 0 (Vote!)

Posted on Tuesday, November 15, 2011 - 10:02 pm:

no idea blaze uncle
why dont you take a pl/sql anonymous block -- insert into a temp table .. do the rollback
and then find out the currval of that sequence

Health is Happiness

Blazewada
Mudiripoyina Bewarse
Username: Blazewada

Post Number: 17658
Registered: 08-2008
Posted From: 66.54.64.236

Rating: N/A
Votes: 0 (Vote!)

Posted on Tuesday, November 15, 2011 - 9:53 pm:

For audit purpose created trigger for all CRUD operations.
On update of any record trigger will make 2 inserts (old & new) . Both records will have same audit ID but different log ID. using sequence.nextval for ID.

Doubt:
in case when trigger insert fails (any reason) can sequence value be rolled back to previous value. If yes how can we do that?

Do What you believe.. Love What You do...

Administration