Trigger error
From: Peta Griffith <peta_at_dataspeed.com.au>
Date: Wed, 7 Mar 2001 16:31:22 +1100
Message-ID: <8xjp6.9770$v5.40042_at_newsfeeds.bigpond.com>
Date: Wed, 7 Mar 2001 16:31:22 +1100
Message-ID: <8xjp6.9770$v5.40042_at_newsfeeds.bigpond.com>
Trigger Error
using the oracle oledb provider and ado with visual basic
when creating a trigger
this statement will return then error 'No value given for one or more required parameters'
con.execute "CREATE OR REPLACE TRIGGER SYLOGIN.TRI_SEQ_ERRORLOG BEFORE INSERT ON SYLOGIN.ERRORLOG FOR EACH ROW BEGIN SELECT SYLOGIN.SEQ_ERRORLOG.nextval INTO : new.ID FROM dual; END;"
this statement will create trigger with no error but the trigger will be invalid as there is no colon in the statement
con.execute "CREATE OR REPLACE TRIGGER SYLOGIN.TRI_SEQ_ERRORLOG BEFORE INSERT ON SYLOGIN.ERRORLOG FOR EACH ROW BEGIN SELECT SYLOGIN.SEQ_ERRORLOG.nextval INTO new.ID FROM dual; END;"
help Received on Wed Mar 07 2001 - 06:31:22 CET