Home » RDBMS Server » Server Administration » Re: triggers and sequences
Re: triggers and sequences [message #370449] Fri, 24 September 1999 16:37 Go to next message
Amy
Messages: 29
Registered: September 1999
Junior Member
The after has to be there since I'm updating numbers that are 0 in the table. I didn't think
you needed to do a commit from a trigger.
I always commit after I do the insert and the number that is in the table (ie 40) doesn't match
what the current value says in the OEM.
Clueless!

Report message to a moderator

Re: triggers and sequences [message #370454 is a reply to message #370449] Sun, 26 September 1999 13:08 Go to previous message
sonik chopra
Messages: 4
Registered: September 1999
Junior Member
dear amy,
as you mentioned you use commit with a trigger,this is a wrong syntax.
keep in touch sonik

Report message to a moderator

Previous Topic: Primary key Vs Unique+Not null
Next Topic: Want more info about Raise_Application_Error Func.
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Aug 20 23:27:36 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.