Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Trigger error 2
Trigger Error
using the oracle oledb provider and ado with visual basic
when creating a trigger
these 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 REFERENCING NEW AS NEW OLD AS OLD FOR EACH ROW BEGIN :NEW.ID := SYLOGIN.SEQ_ERRORLOG.NEXTVAL; END;" con.execute "CREATE OR REPLACE TRIGGER SYLOGIN.TRI_SEQ_ERRORLOG BEFORE INSERT ON SYLOGIN.ERRORLOG FOR EACH ROW BEGIN :NEW.ID := SYLOGIN.SEQ_ERRORLOG.NEXTVAL; END;" con.execute "CREATE OR REPLACE TRIGGER SYLOGIN.TRI_SEQ_ERRORLOG BEFORE INSERT ON SYLOGIN.ERRORLOG REFERENCING NEW AS NEW OLD AS OLD FOR EACH ROW BEGIN SELECT SYLOGIN.SEQ_ERRORLOG.nextval INTO :new.ID FROM dual; END;" Received on Wed Mar 07 2001 - 17:05:55 CST
![]() |
![]() |