Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Trigger error 2

Trigger error 2

From: Peta Griffith <peta_at_dataspeed.com.au>
Date: Thu, 8 Mar 2001 10:05:55 +1100
Message-ID: <KZyp6.10326$v5.43021@newsfeeds.bigpond.com>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US