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 -> CREATING TRIGGER ERROR

CREATING TRIGGER ERROR

From: Peta Griffith <peta_at_dataspeed.com.au>
Date: Wed, 7 Mar 2001 16:29:24 +1100
Message-ID: <hvjp6.9768$v5.39967@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 Tue Mar 06 2001 - 23:29:24 CST

Original text of this message

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