Package gudusoft.gsqlparser.stmt.oracle

Class TPlsqlCreateProcedure

Object

gudusoft.gsqlparser.nodes.TParseTreeNode

gudusoft.gsqlparser.TCustomSqlStatement

gudusoft.gsqlparser.stmt.TBlockSqlStatement

gudusoft.gsqlparser.stmt.TStoredProcedureSqlStatement

gudusoft.gsqlparser.stmt.TCommonStoredProcedureSqlStatement

gudusoft.gsqlparser.stmt.oracle.TPlsqlCreateProcedure

All Implemented Interfaces:

IRelation, Visitable, Iterator<TSourceToken>

public class TPlsqlCreateProcedure
extends TCommonStoredProcedureSqlStatement

This class represents 3 types of SQL statement:

• Create procedure statement, creates or replaces a standalone stored procedure or a call specification.
• Declare a procedure inside a PL/SQL block or package.
• Define a procedure inside a PL/SQL block or package.

See Also:

• TBlockSqlStatement.declareStatements
• TBlockSqlStatement.bodyStatements

Nested Class Summary

Nested classes/interfaces inherited from class gudusoft.gsqlparser.TCustomSqlStatement

TCustomSqlStatement.SqlNormalizationProfile

Field Summary

Fields inherited from class gudusoft.gsqlparser.stmt.TBlockSqlStatement

blockBody, bodyStatements, declareStatements, exceptionClause

Fields inherited from class gudusoft.gsqlparser.TCustomSqlStatement

dummytag, fromClause, fromSourceJoin, fromSourceTable, isctequery, isparsed, joins, parser, plsqlparser, relationAttributes, rootNode, semicolonended, sourcetokenlist, sqlstatementtype, stmtScope, tables

Fields inherited from class gudusoft.gsqlparser.nodes.TParseTreeNode

dbvendor, doubleLinkedTokenListToString, nodeActionAppend, nodeActionInsert, nodeActionRemove, nodeActionUnknown, nodeActionUpdate, nodeActionUpdateText, nodeChangeEndToken, nodeChangeStartToken

Constructor Summary

Constructors

Constructor	Description
TPlsqlCreateProcedure(EDbVendor dbvendor)

Method Summary

Modifier and Type	Method	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)
TCallSpec	getCallSpec()
TStatementList	getInnerStatements()
TInvokerRightsClause	getInvokerRightsClause()
int	getKind()	Indicates what's kind of SQL statement this class represents for, create proceure, declare a procudure or define a procedure.
TObjectName	getProcedureName()	The name that you give to the procedure that you are declaring or defining.
TObjectName	getStoredProcedureName()
void	init(Object arg1)	Initialize a query tree node.
void	setCallSpec(TCallSpec callSpec)
void	setInnerStatements(TStatementList innerStatements)
void	setInvokerRightsClause(TInvokerRightsClause invokerRightsClause)
void	setKind(int kind)
void	setProcedureName(TObjectName procedureName)

Methods inherited from class gudusoft.gsqlparser.stmt.TCommonStoredProcedureSqlStatement

isWrapped, setWrapped

Methods inherited from class gudusoft.gsqlparser.stmt.TStoredProcedureSqlStatement

getParameterDeclarations, getProcHandle, setParameterDeclarations, setProcHandle

Methods inherited from class gudusoft.gsqlparser.stmt.TBlockSqlStatement

getBlockBody, getBodyStatements, getDeclareStatements, getEndlabelName, getExceptionClause, getLabelName, getLabelNameStr, setBodyStatements, setDeclareStatements, setExceptionClause

Methods inherited from class gudusoft.gsqlparser.TCustomSqlStatement

addToTables, addWhereClause, analyzeFromTable, analyzeFromTable, analyzeJoin, analyzeTablename, analyzeTableOrJoin, asCanonical, checkNonQualifiedColumnReferenceInSubQueryOfUplevelStmt, clearError, computeSqlHash, dochecksyntax, findTable, fireOnMetaDatabaseTableColumn, getAncestorStmt, getAttributes, getColumnsInTable, getColumnsInTable, getCteIncludeThisStmt, getCteList, getDaxFunctionStack, getErrorCount, getErrormessage, getExpandedResultColumns, getFirstPhysicalTable, getFrameStack, getFromClause, getFromSourceJoin, getFromSourceTable, getGlobalScope, getIndexColumns, getJoins, getOrphanColumns, getOutputClause, getParentObjectName, getParentStmt, getQueryId, getRelationName, getRelations, getResultColumnList, getReturningClause, getSqlEnv, getSqlHash, getSqlHash, getStatements, getStmtScope, getSymbolTable, getSyntaxErrors, getSyntaxHints, getTables, getTargetTable, getTokenList, getTopClause, getTopStatement, getUsingVariableList, getVariableStack, getWhereClause, isathenaplsql, isBigQueryplsql, isdatabricksplsql, isGaussDBStoredProcedure, isgreeplumplsql, isnzplsql, isoracleplsql, ispgplsql, isprestoplsql, issnowflakeplsql, isTableACTE, isverticaplsql, linkColumnReferenceToTable, linkColumnToTable, linkToFirstTable, locateVariableOrParameter, locateVariableOrParameter, OracleStatementCanBeSeparatedByBeginEndPair, parseerrormessagehandle, parsestatement, parsestatement, searchCTEList, searchDaxVariableInStack, searchFunctionInSQLEnv, setAlreadyAddToParent, setCteIncludeThisStmt, setCteList, setEndlabelName, setFrameStack, setFromClause, setLabelName, setOutputClause, setParentStmt, setParentStmtToNull, setQueryId, setResultColumnList, setReturningClause, setSqlHash, setStmtScope, setTargetTable, setTopClause, setUsingVariableList, setVariableStack, setWhereClause, size, toNormalizedSql, toScript, VerticaStatementCanBeSeparatedByBeginEndPair

Methods inherited from class gudusoft.gsqlparser.nodes.TParseTreeNode

addAllMyTokensToTokenList, addToTokenChain, appendNewNode, calculateTokenCount, doAppendNewNode, doParse, fastSetString, getAnchorNode, getColumnNo, getCommentAfterNode, getCommentBeforeNode, getCompactString, getDummyTag, getEndToken, getEvaluateDatatype, getEvalValue, getGsqlparser, getLineNo, getLocation, getMd5, getNodeStatus, getNodeType, getPlainText, getStartToken, getTokenCount, hasNext, init, init, init, init, init, insertAfterAToken, insertNewNodeBeforeMe, isChanged, isTokensInChain, next, refreshAllNodesTokenCount, remove, removeAllMyTokensFromTokenList, removeTokens, removeTokensBetweenNodes, removeTokensBetweenToken, replaceWithNewNode, resetIterator, setAnchorNode, setChanged, setDummyTag, setEndToken, setEndToken, setEndToken, setEndToken, setEndToken, setEndTokenDirectly, setEvaluateDatatype, setEvalValue, setGsqlparser, setIncludingComment, setLocation, setNewSubNode, setNodeStatus, setNodeType, setParent, setPlainText, setStartToken, setStartToken, setStartToken, setStartToken, setStartTokenDirectly, setString, setString2, subNodeInNode, toString, toString2

Methods inherited from class java.lang.Object

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

Methods inherited from interface java.util.Iterator

forEachRemaining

Constructor Details

TPlsqlCreateProcedure

public TPlsqlCreateProcedure(EDbVendor dbvendor)

Method Details

setInvokerRightsClause

public void setInvokerRightsClause(TInvokerRightsClause invokerRightsClause)

getInvokerRightsClause

public TInvokerRightsClause getInvokerRightsClause()

getStoredProcedureName

public TObjectName getStoredProcedureName()

Overrides:

getStoredProcedureName in class TStoredProcedureSqlStatement

setKind

public void setKind(int kind)

getKind

public int getKind()

Indicates what's kind of SQL statement this class represents for, create proceure, declare a procudure or define a procedure.

Returns:

getProcedureName

public TObjectName getProcedureName()

The name that you give to the procedure that you are declaring or defining.

Returns:

getInnerStatements

public TStatementList getInnerStatements()

Returns:

Oracle plsql inner statements in declared section before IS keyword.

getCallSpec

public TCallSpec getCallSpec()

Returns:

call specification

doParseStatement

public int doParseStatement(TCustomSqlStatement psql)

Overrides:

doParseStatement in class TCommonStoredProcedureSqlStatement

init

public void init(Object arg1)

Description copied from class: TParseTreeNode

Initialize a query tree node. Used internally

Overrides:

init in class TParseTreeNode

Parameters:

arg1 - first argument

accept

public void accept(TParseTreeVisitor v)

Description copied from class: TParseTreeNode

Accept a visitor

Specified by:

accept in interface Visitable

Overrides:

accept in class TBlockSqlStatement

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 TBlockSqlStatement

Parameters:

v - visitor is a descendant class of TParseTreeVisitor

setProcedureName

public void setProcedureName(TObjectName procedureName)

setInnerStatements

public void setInnerStatements(TStatementList innerStatements)

setCallSpec

public void setCallSpec(TCallSpec callSpec)