Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Mutating Tables Workaround Problem

Status
Not open for further replies.

jonatan

Programmer
Mar 24, 2003
14
BR
I'm using the "classic" mutating table workaround, that uses an AFTER STATEMENT trigger to run the trigger ( But in my trigger I have an UPDATE in the same table from trigger. In this second UPDATE, the package data is redefined, and I cannot run the trigger for the remaining rows. How can I workaround this? Is there anyway to store a stack for the data in the package?

Thanks,

Jonatan Schroeder
aka Houston
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top