Information générale
Catégorie:
Bases de données DAO/RDO/ODBC/ADO
Titre:
Creating a trigger in Oracle
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
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement