slt a tous ,
j'ai pas reussi a finaliser un trigger
"create or replace trigger agence after insert on agence
for each row
Begin
connect as kairouan/sa@telecomp ;
insert all INTO testagence
( OPERATION , CODENEW , CODEOLD , BANQUE , jour , UTILISATEUR , DUPLICATION ) values
( 'Insert' , :NEW.id , ' ' , :NEW.IDINSTITUTION , sysdate , sys_context('USERENV',
'CURRENT_USER' ) , 'OK ' ) into agenece (id,idinstitution,IDCENTREREGIONAL) values
( :NEW.id , :NEW.IDINSTITUTION , :new.IDCENTREREGIONAL ) select * from dual; dis ;end if ;
end;
/
"
comment pourrais je le modifier? merci
__________________________
toutou