Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: What's wrong with the trigger?

Re: What's wrong with the trigger?

From: Arjan van Bentem <avbentem_at_DONT-YOU-DAREdds.nl>
Date: Thu, 20 Aug 1998 07:05:03 +0200
Message-ID: <6rgaog$bum$1@pascal.a2000.nl> 





Type



    show errors ins_accept



to have Oracle tell you what's wrong! In general, just typing 'show errors'
after an error occured will do.



Your problem is that you have a commit in your code. You can not use commit
or rollback inside a trigger.



Arjan.


Received on Thu Aug 20 1998 - 00:05:03 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US