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 -> Help for 10g Table Trigger ----first post

Help for 10g Table Trigger ----first post

From: The Great Pawn Hunter <manusfealy_at_aol.com>
Date: 7 May 2007 11:03:36 -0700
Message-ID: <1178561016.800380.167220@h2g2000hsg.googlegroups.com>


Hi everyone,

This is my first post on the newsgroup so please be kind to a newbie. I have the following code for an Oracle 10g table trigger

create or replace trigger chk_multi_dup
  after insert or update on epics.actor_attribute   for each statement

SQL PLUS complains that it is expecting "for each row"...however, I truly do want it to be for each statement.

The Great Pawn Hunter Received on Mon May 07 2007 - 13:03:36 CDT

Original text of this message

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