Table of Contents

Class TPlsqlExecImmeStmt

Namespace
gudusoft.gsqlparser.stmt.oracle
Assembly
gudusoft.gsqlparser.dll

The EXECUTE IMMEDIATE statement builds and executes a dynamic SQL statement in a single operation.

public class TPlsqlExecImmeStmt : TBlockSqlStatement, Visitable
Inheritance
TPlsqlExecImmeStmt
Implements
Inherited Members

Constructors

TPlsqlExecImmeStmt(EDbVendor) 

public TPlsqlExecImmeStmt(EDbVendor dbvendor)

Parameters

dbvendor EDbVendor

Properties

BindArguments 

public virtual TBindArgumentList BindArguments { get; set; }

Property Value

TBindArgumentList

bind arguments in using clause.

DynamicSQL 

public virtual string DynamicSQL { get; set; }

Property Value

string

String representation of dynamic sql statement. if there is a variable in gudusoft.gsqlparser.stmt.oracle.TPlsqlExecImmeStmt.dynamicStringExpr, value of this variable will be returned.

DynamicStatements 

public virtual TStatementList DynamicStatements { get; set; }

Property Value

TStatementList

sql statement instance that generated dynamically based on gudusoft.gsqlparser.stmt.oracle.TPlsqlExecImmeStmt.dynamicSQL

DynamicStringExpr 

public virtual TExpression DynamicStringExpr { get; set; }

Property Value

TExpression

A string literal, string variable, or string expression that represents any SQL statement. this is the original string of dynamic sql statement.

IntoVariables 

public virtual TExpressionList IntoVariables { get; set; }

Property Value

TExpressionList

variable names in the into clause.

ReturnNames

Used if and only if dynamic_sql_stmt has a RETURNING INTO clause, this clause returns the column values of the rows affected by dynamic_sql_stmt, in either individual variables or records

@return

public virtual TObjectNameList ReturnNames { get; set; }

Property Value

TObjectNameList

Methods

accept(TParseTreeVisitor) 

public override void accept(TParseTreeVisitor v)

Parameters

v TParseTreeVisitor

acceptChildren(TParseTreeVisitor) 

public override void acceptChildren(TParseTreeVisitor v)

Parameters

v TParseTreeVisitor

doParseStatement(TCustomSqlStatement)

analyze SQL

public override int doParseStatement(TCustomSqlStatement psql)

Parameters

psql TCustomSqlStatement

Returns

int
Edit this page