Example #1
0
        public void PlSqlTrigger()
        {
            var body = new PlSqlBlockStatement();

            body.Statements.Add(new CallStatement(ObjectName.Parse("system.output"), new[] {
                new InvokeArgument(SqlExpression.Constant("One row was inserted"))
            }));
            var triggerName = new ObjectName("trigger1");
            var tableName   = ObjectName.Parse("APP.test_table");

            AdminQuery.CreateTrigger(triggerName, tableName, body, TriggerEventTime.After, TriggerEventType.Insert);

            var exists = AdminQuery.Access().TriggerExists(ObjectName.Parse("APP.trigger1"));

            Assert.IsTrue(exists);
        }