PL/SQL (MOSC)

MOSC Banner

Do I need to write commit inside the trigger?

edited May 6, 2010 6:23AM in PL/SQL (MOSC) 10 commentsAnswered
 I have the following trigger:

create or replace trigger TRITON.AFTER_INSERT_UPDATE_ITM001100
after insert or update on TRITON.TTIITM001100
for each row
declare
v_reflag char(1) :='0';
begin
if INSERTING then
insert into ticcrm.ttiitm001100_copy
(T$ITEM,
 T$DSCA,
 T$DSCB,
 T$DSCC,
 T$DSCD,
 T$WGHT,
 T$SEAK,
 T$SEAB,
 T$KITM,
 T$CITG,
 T$CTYP,
 T$CSEL,
 T$CSIG,
 T$CVAT,
 T$TXTA,
 T$USET,
 T$CUNI,
 T$STGU,
 T$CWAR,
 T$KLTC,
 T$OBPR,
 T$KPSL,
 T$NPSL,
 T$PICS,
 T$ABCC,
 T$USCU,
 T$USAB,
 T$SLMP,
 T$SERV,
 T$SFST,
 T$MAXS,

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center