New Trigger at run-time
-
Hi all, I'm tryng to create trigger at run time. I'm using Oracle database. This is my code: -------------------------------------------------------------------------------- Dim CmdTmp As OleDbCommand = New OleDbCommand With CmdTmp .Connection = oConn 'change_status Trigger .CommandText = "CREATE TRIGGER change_status AFTER INSERT ON invoices " & _ "REFERENCING NEW AS newRow FOR EACH ROW " & _ "BEGIN update orders set orders.order_status='Close' where orders.orderID = :newRow.orderID; " & _ "END change_status;" .CommandType = CommandType.Text Try .ExecuteNonQuery() Catch ex As Exception HasErr = True Err += ex.Message + Chr(13) End Try ... -------------------------------------------------------------------------------- I dont get exceptions but the triggger wasn't created... does anyone know what is wrong with my code..? Thank you. RoyRose