Hi all,

I have a friend who is trying to create a trigger in Oracle.

He is using the MDAC version 2.5 with Oralce 8i Client with the following connection string:
"Provider=OraOLEDB.Oracle;User ID=INTERNAL;Password=oracle;DataSource=DATASP;FetchSize=500;"

He is trying to create the following trigger via VB:
CREATE OR REPLACE TRIGGER SCHEMA.TRIGGERNAME BEFORE INSERT ON
SCHEMA.TBLNAME
FOR EACH ROW BEGIN SELECT SCHEMA.SEQUENCENAME.nextval INTO
:new.FIELDNAME
FROM dual; END;

When he tries to run this, he gets an error. If he removes the colon and semi colons, the errors go away, but the trigger won't work.... Any ideas?

Thanks,

Fletcher