Heres what I have in the SQLExecutor :
FME_SQL_DELIMITER;
set define off
create or replace
trigger DECISION_ID_$(ENC_ID)
BEFORE INSERT ON DECISION$(ENC_ID)
FOR EACH ROW
BEGIN
SELECT SEQ_DECISION.nextval into :new.id from dual;
END;
heres what it looks like in the log :
SQLExecutor_DECISION_TRIGGER(QueryFactory): Performing query against ORACLE8I dataset `XXXX.net\\orcl'
Delimiter token must be declared at beginning of file. Ignoring delimiter and continuing. SQL is: 'FME_SQL_DELIMITER;
set define off
create or replace
trigger DECISION_ID_123
BEFORE INSERT ON DECISION123
FOR EACH ROW
BEGIN
SELECT SEQ_DECISION.nextval into :new.id from dual;
END;'
ORACLE Reader: Using Oracle 8 SC Reader to read tables from database `', server type `ORACLE8i', server name `XXXX\\orcl', user name `XXXX', password `***'
ORACLE Reader: Using Rich geometry.
ORACLE Reader: Executing SQL Statement `FME_SQL_DELIMITER;
set define off
create or replace
trigger DECISION_ID_123
BEFORE INSERT ON DECISION123
FOR EACH ROW
BEGIN
SELECT SEQ_DECISION.nextval into :new.id from dual;
END;' to obtain features for feature type `QueryFactory_SQLExecute'
FME Configuration: No destination coordinate system set
Writer `ORACLE8I_1' of type `ORACLE8I' using group definition keyword `ORACLE8I_1_DEF'
Using Oracle 8 SC Writer to write tables to database `', server type `ORACLE8I', server name `UKHO-test-XXXX.net\\orcl', user name `XXXX', password `***'
Oracle Writer: Starting at transaction 0 with a transaction interval of 1000
No real mention of am error but my trigger does not appear, the same SQL works fine in ORACLE, anyone know whay its not working?
(I have replaced usernames and address's with XXXX)