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

Home -> Community -> Usenet -> c.d.o.tools -> TRIGGER ERROR 2

TRIGGER ERROR 2

From: Peta Griffith <peta_at_dataspeed.com.au>
Date: Thu, 8 Mar 2001 10:05:23 +1100
Message-ID: <fZyp6.10325$v5.43049@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:23 CST

Original text of this message

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