Deveel.Data.SelectRoutineTests.OnSetUp C# (CSharp) Method

        protected override bool OnSetUp(string testName, IQuery query)
        {
            procName = ObjectName.Parse("APP.proc1");
            var body = new PlSqlBlockStatement();
            body.Statements.Add(new CallStatement(ObjectName.Parse("proc2")));
            var procInfo = new PlSqlProcedureInfo(procName, new RoutineParameter[0], body);
            query.Access().CreateObject(procInfo);

            funcName = ObjectName.Parse("APP.func1");
            body = new PlSqlBlockStatement();
            body.Statements.Add(new ReturnStatement(SqlExpression.Constant(22)));
            var funcInfo = new PlSqlFunctionInfo(funcName, new RoutineParameter[0], PrimitiveTypes.Integer(), body);
            query.Access().CreateObject(funcInfo);

            return true;
        }