In article <20010323.3241400_at_linux.local>, bhogak <bhogak_at_yahoo.com>
writes:
>I know that we cannot use Commits/ Rollbacks in regular Database=20
>Triggers. I am planning to use a Trigger at Database Startup. (I am usin=
>g=20
>Oracle 8i). I need to update my Job Control table inside this trigger.
>
>How do I save my change if I don't use Commit?
>
>Thx.
>bhogak
Interesting question. I haven't actually tried to use a database level
trigger for anything yet so I am not sure, and unfortunately I do not have
time to test this before posting. But I believe that you can perform an
autonomous transaction within a trigger so this should allow you to get
around the problem. It shouldn't take you more than a few minutes to test
this out. It would be appreciated if you posted back if this works.
- Posted via NewsOne.Net: Free (anonymous) Usenet News via the Web -----
http://newsone.net/ -- Free reading and anonymous posting to 60,000+ groups
NewsOne.Net prohibits users from posting spam. If this or other posts
made through NewsOne.Net violate posting guidelines, email abuse_at_newsone.net
Received on Fri Mar 23 2001 - 09:04:39 CST
