Deveel.Data.CreateProcedureTests.SimpleCallFunction C# (CSharp) Method

        public void SimpleCallFunction()
        {
            var block = new PlSqlBlockStatement();
            block.Declarations.Add(new DeclareVariableStatement("a", PrimitiveTypes.String()));
            block.Statements.Add(new AssignVariableStatement(SqlExpression.VariableReference("a"), SqlExpression.FunctionCall("user")));

            var procName = ObjectName.Parse("APP.proc1");
            AdminQuery.CreateProcedure(procName, block);

            var exists = AdminQuery.Access().RoutineExists(procName);

            Assert.IsTrue(exists);

            var procedure = AdminQuery.Access().GetObject(DbObjectType.Routine, procName);

            Assert.IsNotNull(procedure);
            Assert.IsInstanceOf<Procedure>(procedure);
        }