gudusoft.gsqlparser.stmt.oracle

Class TPlsqlExecImmeStmt

java.lang.Object

gudusoft.gsqlparser.nodes.TParseTreeNode

gudusoft.gsqlparser.TCustomSqlStatement

gudusoft.gsqlparser.stmt.TBlockSqlStatement

gudusoft.gsqlparser.stmt.oracle.TPlsqlExecImmeStmt

All Implemented Interfaces:

Visitable

public class TPlsqlExecImmeStmt
extends TBlockSqlStatement

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

Field Summary

Fields inherited from class gudusoft.gsqlparser.TCustomSqlStatement

dbvendor, dummytag, isparsed, joins, parser, plsqlparser, rootNode, sourcetokenlist, sqlstatementtype, tables

Constructor Summary

Constructors

Constructor and Description
TPlsqlExecImmeStmt(EDbVendor dbvendor)

Method Summary

Modifier and Type	Method and Description
void	accept(TParseTreeVisitor v) Accept a visitor
void	acceptChildren(TParseTreeVisitor v) Accept a visitor to iterate this class and sub-nodes of this class
int	doParseStatement(TCustomSqlStatement psql)
TBindArgumentList	getBindArguments() bind arguments
String	getDynamicSQL()
TStatementList	getDynamicStatements()
TExpression	getDynamicStringExpr() String expr
TExpressionList	getIntoVariables() Into variable
TObjectNameList	getReturnNames() 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
void	setBindArguments(TBindArgumentList bindArguments)
void	setDynamicSQL(String dynamicSQL)
void	setDynamicStatements(TStatementList dynamicStatements)
void	setDynamicStringExpr(TExpression dynamicStringExpr)
void	setIntoVariables(TExpressionList intoVariables)
void	setReturnNames(TObjectNameList returnNames)

Methods inherited from class gudusoft.gsqlparser.stmt.TBlockSqlStatement

getBodyStatements, setBodyStatements

Methods inherited from class gudusoft.gsqlparser.TCustomSqlStatement

addToTables, addWhereClause, analyzeFromTable, analyzeJoin, analyzeTablename, checkNonQualifiedColumnReferenceInSubQueryOfUplevelStmt, clearError, dochecksyntax, findTable, fireOnMetaDatabaseTableColumn, getAncestorStmt, getCteList, getDaxFunctionStack, getEndlabelName, getErrorCount, getFirstPhysicalTable, getIndexColumns, getJoins, getLabelName, getOrphanColumns, getOutputClause, getParentStmt, getResultColumnList, getReturningClause, getStatements, getSymbolTable, getTables, getTargetTable, getTopClause, getTopStatement, getVariableStack, getWhereClause, isnzplsql, isoracleplsql, ispgplsql, isTableACTE, isverticaplsql, linkColumnReferenceToTable, linkColumnToTable, linkToFirstTable, locateVariableOrParameter, OracleStatementCanBeSeparatedByBeginEndPair, parseerrormessagehandle, parsestatement, searchCTEList, searchDaxVariableInStack, setCteList, setEndlabelName, setLabelName, setOutputClause, setParentStmt, setResultColumnList, setReturningClause, setTargetTable, setTopClause, setVariableStack, setWhereClause, VerticaStatementCanBeSeparatedByBeginEndPair

Methods inherited from class gudusoft.gsqlparser.nodes.TParseTreeNode

addAllMyTokensToTokenList, appendString, doParse, fastSetString, getColumnNo, getDummyTag, getEndToken, getGsqlparser, getLineNo, getNodeType, getStartToken, init, init, init, init, init, init, removeAllMyTokensFromTokenList, setDummyTag, setEndToken, setEndToken, setEndToken, setEndToken, setGsqlparser, setIncludingComment, setNodeType, setStartToken, setStartToken, setStartToken, setStartToken, setString, toScript, toString

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

Constructor Detail

TPlsqlExecImmeStmt

public TPlsqlExecImmeStmt(EDbVendor dbvendor)

Method Detail

getDynamicStatements

public TStatementList getDynamicStatements()

Returns:

sql statement instance that generated dynamically based on dynamicSQL

getDynamicSQL

public String getDynamicSQL()

Returns:

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

getBindArguments

public TBindArgumentList getBindArguments()

bind arguments

Returns:

bind arguments in using clause.

getDynamicStringExpr

public TExpression getDynamicStringExpr()

String expr

Returns:

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

getIntoVariables

public TExpressionList getIntoVariables()

Into variable

Returns:

variable names in the into clause.

getReturnNames

public TObjectNameList getReturnNames()

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

Returns:

doParseStatement

public int doParseStatement(TCustomSqlStatement psql)

Overrides:

doParseStatement in class TCustomSqlStatement

accept

public void accept(TParseTreeVisitor v)

Description copied from class: TParseTreeNode

Accept a visitor

Specified by:

accept in interface Visitable

Overrides:

accept in class TParseTreeNode

Parameters:

v - visitor is a descendant class of TParseTreeVisitor

acceptChildren

public void acceptChildren(TParseTreeVisitor v)

Description copied from class: TParseTreeNode

Accept a visitor to iterate this class and sub-nodes of this class

Specified by:

acceptChildren in interface Visitable

Overrides:

acceptChildren in class TParseTreeNode

Parameters:

v - visitor is a descendant class of TParseTreeVisitor

setDynamicStringExpr

public void setDynamicStringExpr(TExpression dynamicStringExpr)

setBindArguments

public void setBindArguments(TBindArgumentList bindArguments)

setIntoVariables

public void setIntoVariables(TExpressionList intoVariables)

setReturnNames

public void setReturnNames(TObjectNameList returnNames)

setDynamicSQL

public void setDynamicSQL(String dynamicSQL)

setDynamicStatements

public void setDynamicStatements(TStatementList dynamicStatements)