Deveel.Data.PlSqlBlockTests.DeclareAndOpenCursor C# (CSharp) Method

        public void DeclareAndOpenCursor()
        {
            var query = (SqlQueryExpression) SqlExpression.Parse("SELECT * FROM test_table");
            var block = new PlSqlBlockStatement();
            block.Declarations.Add(new DeclareCursorStatement("c1", query));
            block.Statements.Add(new OpenStatement("c1"));

            AdminQuery.ExecuteStatement(block);

            Assert.IsTrue(AdminQuery.Context.CursorExists("c1"));

            var cursor = AdminQuery.Context.FindCursor("c1");
            Assert.AreEqual(CursorStatus.Open, cursor.Status);
        }