Hello,

I need to insert or update records in a table (TEST1) when the employes will be inserted or updated in tccom001. I´ve created a table and 2 triggers:

CREATE TABLE TEST1 (t$emno number primary key , t$nama varchar2(35))

create or replace trigger test_update
after update
on BAAN.TTCCOM001900
for each row
begin
update test1 set t$nama = :new.t$nama WHERE t$emno= :new.t$emno;
END;

create or replace trigger test_INSERT
after insert
on BAAN.TTCCOM001900
for each row
begin
insert into TEST1 values(:new.t$emno,:new.t$nama);
END;


When I insert or change the records in tccom001, I get next errors:

/baan/bse/log>tail log.oracle8
2010-04-07[13:30:58]:E:mpl: ******* S T A R T of Error message *******
2010-04-07[13:30:58]:E:mpl: Log message called from /view/port.6.1c.07.09/vobs/tt/servers/ORACLE_2/ora_native.c: #1822 keyword: Oracle Error
2010-04-07[13:30:58]:E:mpl: Pid 614648 Uid 311 Euid 311 Gid 203 Egid 203
2010-04-07[13:30:58]:E:mpl: user_type S language 5 user_name mpl tty ote locale ISO88591/NULL
2010-04-07[13:30:58]:E:mpl: Errno 0 bdb_errno 110 (End of file reached)
2010-04-07[13:30:58]:E:mpl:
2010-04-07[13:30:58]:E:mpl: dbs_errno = 0, Error 2003 occurred:
2010-04-07[13:30:58]:E:mpl: Error ORA-1003 occurred during execute.
2010-04-07[13:30:58]:E:mpl: ORA-01003: ninguna sentencia analizada
2010-04-07[13:30:58]:E:mpl:
2010-04-07[13:30:58]:E:mpl: Error BDB-2003 returned.
2010-04-07[13:30:58]:E:mpl: Might be caused by an invalidated Oracle cursor due to an earlier error.
2010-04-07[13:30:58]:E:mpl: See fatal SQL statement in '/baan/bse/log/log.ora.sql'.
2010-04-07[13:30:58]:E:mpl: Flushed at /view/port.6.1c.07.09/vobs/tt/servers/ORACLE_2/ora_cursor.c : #536.
2010-04-07[13:30:58]:E:mpl: ******* E N D of Error message *******


/baan/bse/log>tail log.ora.sql
------ Log Fatal SQL Statement -----
User : mpl (pid 614648)
Date : 2010-04-07[12:07:15]
SQL :
UPDATE /*+ index(a ttccom001900$idx1) */ baan.ttccom001900 SET t$nama=:1 WHERE t$emno=:2
------ End of Log Message -----


/baan/bse/log>tail log.bshell
2010-04-07[13:30:58]:E:mpl: ******* S T A R T of Error message *******
2010-04-07[13:30:58]:E:mpl: Log message called from /view/port.6.1c.07.09/vobs/tt/mir/mir/bdb_fun.c: #1127 keyword: DB error
2010-04-07[13:30:58]:E:mpl: Pid 590052 Uid 311 Euid 311 Gid 203 Egid 203
2010-04-07[13:30:58]:E:mpl: user_type S language 5 user_name mpl tty ote locale ISO88591/NULL
2010-04-07[13:30:58]:E:mpl: Errno 0 bdb_errno 2003 (bdb_errno 2003)
2010-04-07[13:30:58]:E:mpl: Log_mesg: Error 2003 (bdb_errno 2003) on tccom001900 in db_update(51)
2010-04-07[13:30:58]:E:mpl: ******* E N D of Error message *******


Thanks,

María

i need to know where to put this trigger to run on baan ERP??????????????????/

i have a trigger but dont know where to put it ???? on the ERP