I am just reposting this to see if anyone has an idea about this. Any takers?
>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