## pSqlArgument
```mermaid
%%{init: {
'theme': 'base',
'themeVariables': {
'fontSize': '11px',
'nodePadding': '1',
'nodeBorder': '1',
'lineWidth': '0.8',
'fontFamily': 'Arial'
}
}}%%
flowchart LR
pSqlArgument_start([pSqlArgument])
pSqlArgument_start --> pSqlArgument_0_0[pSqlVariableName]
pSqlArgument_0_0 --> pSqlArgument_0_1[pSqlDataType]
pSqlArgument_0_1 --> pSqlArgument_end(( ))
```
## pSqlArgumentList
```mermaid
%%{init: {
'theme': 'base',
'themeVariables': {
'fontSize': '11px',
'nodePadding': '1',
'nodeBorder': '1',
'lineWidth': '0.8',
'fontFamily': 'Arial'
}
}}%%
flowchart LR
pSqlArgumentList_start([pSqlArgumentList])
pSqlArgumentList_start --> pSqlArgumentList_0_0[pSqlArgument]
pSqlArgumentList_0_0 --> pSqlArgumentList_0_1[COMMA]
pSqlArgumentList_0_1 --> pSqlArgumentList_0_2[pSqlArgument]
pSqlArgumentList_0_2 --> pSqlArgumentList_end(( ))
```
## pSqlVariableList
```mermaid
%%{init: {
'theme': 'base',
'themeVariables': {
'fontSize': '11px',
'nodePadding': '1',
'nodeBorder': '1',
'lineWidth': '0.8',
'fontFamily': 'Arial'
}
}}%%
flowchart LR
pSqlVariableList_start([pSqlVariableList])
pSqlVariableList_start --> pSqlVariableList_0_0[pSqlVariableName]
pSqlVariableList_0_0 --> pSqlVariableList_0_1[COMMA]
pSqlVariableList_0_1 --> pSqlVariableList_0_2[pSqlVariableName]
pSqlVariableList_0_2 --> pSqlVariableList_end(( ))
```
## pSqlBlock
```mermaid
%%{init: {
'theme': 'base',
'themeVariables': {
'fontSize': '11px',
'nodePadding': '1',
'nodeBorder': '1',
'lineWidth': '0.8',
'fontFamily': 'Arial'
}
}}%%
flowchart LR
pSqlBlock_start([pSqlBlock])
pSqlBlock_start --> pSqlBlock_0_0[DECLARE]
pSqlBlock_0_0 --> pSqlBlock_0_1[pSqlDeclareSection]
pSqlBlock_0_1 --> pSqlBlock_0_2[pSqlBody]
pSqlBlock_0_2 --> pSqlBlock_end(( ))
```
## pSqlBlockNoBatchSeparator
```mermaid
%%{init: {
'theme': 'base',
'themeVariables': {
'fontSize': '11px',
'nodePadding': '1',
'nodeBorder': '1',
'lineWidth': '0.8',
'fontFamily': 'Arial'
}
}}%%
flowchart LR
pSqlBlockNoBatchSeparator_start([pSqlBlockNoBatchSeparator])
pSqlBlockNoBatchSeparator_start --> pSqlBlockNoBatchSeparator_0_0[DECLARE]
pSqlBlockNoBatchSeparator_0_0 --> pSqlBlockNoBatchSeparator_0_1[pSqlDeclareSection]
pSqlBlockNoBatchSeparator_0_1 --> pSqlBlockNoBatchSeparator_0_2[pSqlBodyNoBatchSeparator]
pSqlBlockNoBatchSeparator_0_2 --> pSqlBlockNoBatchSeparator_end(( ))
```
## pSqlBlockOptionalDeclare
```mermaid
%%{init: {
'theme': 'base',
'themeVariables': {
'fontSize': '11px',
'nodePadding': '1',
'nodeBorder': '1',
'lineWidth': '0.8',
'fontFamily': 'Arial'
}
}}%%
flowchart LR
pSqlBlockOptionalDeclare_start([pSqlBlockOptionalDeclare])
pSqlBlockOptionalDeclare_start --> pSqlBlockOptionalDeclare_0_0[DECLARE]
pSqlBlockOptionalDeclare_0_0 --> pSqlBlockOptionalDeclare_0_1[pSqlDeclareSection]
pSqlBlockOptionalDeclare_0_1 --> pSqlBlockOptionalDeclare_0_2[pSqlBody]
pSqlBlockOptionalDeclare_0_2 --> pSqlBlockOptionalDeclare_end(( ))
```
## pSqlDeclareSection
```mermaid
%%{init: {
'theme': 'base',
'themeVariables': {
'fontSize': '11px',
'nodePadding': '1',
'nodeBorder': '1',
'lineWidth': '0.8',
'fontFamily': 'Arial'
}
}}%%
flowchart LR
Start(( )) --> pSqlDeclareSection
pSqlDeclareSection -->| | pSqlDeclaration
pSqlDeclaration --> End(( ))
```
## pSqlDeclaration
```mermaid
%%{init: {
'theme': 'base',
'themeVariables': {
'fontSize': '11px',
'nodePadding': '1',
'nodeBorder': '1',
'lineWidth': '0.8',
'fontFamily': 'Arial'
}
}}%%
flowchart LR
Start(( )) --> pSqlDeclaration
pSqlDeclaration -->| | pSqlItemDeclaration
pSqlItemDeclaration --> End(( ))
```
## pSqlItemDeclaration
```mermaid
%%{init: {
'theme': 'base',
'themeVariables': {
'fontSize': '11px',
'nodePadding': '1',
'nodeBorder': '1',
'lineWidth': '0.8',
'fontFamily': 'Arial'
}
}}%%
flowchart LR
pSqlItemDeclaration_start([pSqlItemDeclaration])
pSqlItemDeclaration_start --> pSqlItemDeclaration_0_0[pSqlVariableName]
pSqlItemDeclaration_0_0 --> pSqlItemDeclaration_0_1[CONSTANT]
pSqlItemDeclaration_0_1 --> pSqlItemDeclaration_0_2[pSqlDataType]
pSqlItemDeclaration_0_2 --> pSqlItemDeclaration_0_3[ASSIGNMENT_OPERATOR]
pSqlItemDeclaration_0_3 --> pSqlItemDeclaration_0_4[expression]
pSqlItemDeclaration_0_4 --> pSqlItemDeclaration_0_5[BATCHSEPARATOR]
pSqlItemDeclaration_0_5 --> pSqlItemDeclaration_0_6[pSqlCallProcedureStatement]
pSqlItemDeclaration_0_6 --> pSqlItemDeclaration_0_7[BATCHSEPARATOR]
pSqlItemDeclaration_0_7 --> pSqlItemDeclaration_end(( ))
```
## pSqlBodyNoBatchSeparator
```mermaid
%%{init: {
'theme': 'base',
'themeVariables': {
'fontSize': '11px',
'nodePadding': '1',
'nodeBorder': '1',
'lineWidth': '0.8',
'fontFamily': 'Arial'
}
}}%%
flowchart LR
pSqlBodyNoBatchSeparator_start([pSqlBodyNoBatchSeparator])
pSqlBodyNoBatchSeparator_start --> pSqlBodyNoBatchSeparator_0_0[BEGIN]
pSqlBodyNoBatchSeparator_0_0 --> pSqlBodyNoBatchSeparator_0_1[pSqlStatement]
pSqlBodyNoBatchSeparator_0_1 --> pSqlBodyNoBatchSeparator_0_2[pSqlExceptionBlock]
pSqlBodyNoBatchSeparator_0_2 --> pSqlBodyNoBatchSeparator_0_3[END]
pSqlBodyNoBatchSeparator_0_3 --> pSqlBodyNoBatchSeparator_end(( ))
```
## pSqlBody
```mermaid
%%{init: {
'theme': 'base',
'themeVariables': {
'fontSize': '11px',
'nodePadding': '1',
'nodeBorder': '1',
'lineWidth': '0.8',
'fontFamily': 'Arial'
}
}}%%
flowchart LR
pSqlBody_start([pSqlBody])
pSqlBody_start --> pSqlBody_0_0[pSqlBodyNoBatchSeparator]
pSqlBody_0_0 --> pSqlBody_0_1[BATCHSEPARATOR]
pSqlBody_0_1 --> pSqlBody_end(( ))
```
## pSqlExceptionBlock
```mermaid
%%{init: {
'theme': 'base',
'themeVariables': {
'fontSize': '11px',
'nodePadding': '1',
'nodeBorder': '1',
'lineWidth': '0.8',
'fontFamily': 'Arial'
}
}}%%
flowchart LR
pSqlExceptionBlock_start([pSqlExceptionBlock])
pSqlExceptionBlock_start --> pSqlExceptionBlock_0_0[EXCEPTION]
pSqlExceptionBlock_0_0 --> pSqlExceptionBlock_0_1[pSqlExceptionWhenName]
pSqlExceptionBlock_0_1 --> pSqlExceptionBlock_0_2[pSqlExceptionWhenOthers]
pSqlExceptionBlock_0_2 --> pSqlExceptionBlock_end(( ))
```
## pSqlExceptionWhenName
```mermaid
%%{init: {
'theme': 'base',
'themeVariables': {
'fontSize': '11px',
'nodePadding': '1',
'nodeBorder': '1',
'lineWidth': '0.8',
'fontFamily': 'Arial'
}
}}%%
flowchart LR
pSqlExceptionWhenName_start([pSqlExceptionWhenName])
pSqlExceptionWhenName_start --> pSqlExceptionWhenName_0_0[WHEN]
pSqlExceptionWhenName_0_0 --> pSqlExceptionWhenName_0_1[pSqlVariableName]
pSqlExceptionWhenName_0_1 --> pSqlExceptionWhenName_0_2[THEN]
pSqlExceptionWhenName_0_2 --> pSqlExceptionWhenName_0_3[pSqlStatement]
pSqlExceptionWhenName_0_3 --> pSqlExceptionWhenName_end(( ))
```
## pSqlExceptionWhenOthers
```mermaid
%%{init: {
'theme': 'base',
'themeVariables': {
'fontSize': '11px',
'nodePadding': '1',
'nodeBorder': '1',
'lineWidth': '0.8',
'fontFamily': 'Arial'
}
}}%%
flowchart LR
pSqlExceptionWhenOthers_start([pSqlExceptionWhenOthers])
pSqlExceptionWhenOthers_start --> pSqlExceptionWhenOthers_0_0[WHEN]
pSqlExceptionWhenOthers_0_0 --> pSqlExceptionWhenOthers_0_1[OTHERS]
pSqlExceptionWhenOthers_0_1 --> pSqlExceptionWhenOthers_0_2[THEN]
pSqlExceptionWhenOthers_0_2 --> pSqlExceptionWhenOthers_0_3[pSqlStatement]
pSqlExceptionWhenOthers_0_3 --> pSqlExceptionWhenOthers_end(( ))
```
## pSqlStatement
```mermaid
%%{init: {
'theme': 'base',
'themeVariables': {
'fontSize': '11px',
'nodePadding': '1',
'nodeBorder': '1',
'lineWidth': '0.8',
'fontFamily': 'Arial'
}
}}%%
flowchart LR
pSqlStatement_start([pSqlStatement])
pSqlStatement_start --> pSqlStatement_0_0[pSqlAssignmentStatement]
pSqlStatement_0_0 --> pSqlStatement_end(( ))
pSqlStatement_start --> pSqlStatement_1_0[pSqlContinueStatement]
pSqlStatement_1_0 --> pSqlStatement_end(( ))
pSqlStatement_start --> pSqlStatement_2_0[pSqlExecuteImmediateStatement]
pSqlStatement_2_0 --> pSqlStatement_end(( ))
pSqlStatement_start --> pSqlStatement_3_0[pSqlExecuteNativeStatement]
pSqlStatement_3_0 --> pSqlStatement_end(( ))
pSqlStatement_start --> pSqlStatement_4_0[pSqlExitStatement]
pSqlStatement_4_0 --> pSqlStatement_end(( ))
pSqlStatement_start --> pSqlStatement_5_0[pSqlGotoStatement]
pSqlStatement_5_0 --> pSqlStatement_end(( ))
pSqlStatement_start --> pSqlStatement_6_0[pSqlLabelStatement]
pSqlStatement_6_0 --> pSqlStatement_end(( ))
pSqlStatement_start --> pSqlStatement_7_0[pSqlIfStatement]
pSqlStatement_7_0 --> pSqlStatement_end(( ))
pSqlStatement_start --> pSqlStatement_8_0[pSqlLoopStatement]
pSqlStatement_8_0 --> pSqlStatement_end(( ))
pSqlStatement_start --> pSqlStatement_9_0[pSqlNullStatement]
pSqlStatement_9_0 --> pSqlStatement_end(( ))
pSqlStatement_start --> pSqlStatement_10_0[pSqlBlock]
pSqlStatement_10_0 --> pSqlStatement_end(( ))
pSqlStatement_start --> pSqlStatement_11_0[pSqlRaiseStatement]
pSqlStatement_11_0 --> pSqlStatement_end(( ))
pSqlStatement_start --> pSqlStatement_12_0[pSqlReturnStatement]
pSqlStatement_12_0 --> pSqlStatement_end(( ))
pSqlStatement_start --> pSqlStatement_13_0[pSqlProcedureStatement]
pSqlStatement_13_0 --> pSqlStatement_end(( ))
pSqlStatement_start --> pSqlStatement_14_0[pSqlCallProcedureStatement]
pSqlStatement_14_0 --> pSqlStatement_end(( ))
pSqlStatement_start --> pSqlStatement_15_0[sqlStatement]
pSqlStatement_15_0 --> pSqlStatement_15_1[";"]
pSqlStatement_15_1 --> pSqlStatement_end(( ))
```
## pSqlBlockOrStatement
```mermaid
%%{init: {
'theme': 'base',
'themeVariables': {
'fontSize': '11px',
'nodePadding': '1',
'nodeBorder': '1',
'lineWidth': '0.8',
'fontFamily': 'Arial'
}
}}%%
flowchart LR
Start(( )) --> pSqlBlockOrStatement
pSqlBlockOrStatement -->| | pSqlBlock
pSqlBlock --> End(( ))
pSqlBlockOrStatement -->| | pSqlStatement
pSqlStatement --> End(( ))
```
## pSqlBlockOrStatements
```mermaid
%%{init: {
'theme': 'base',
'themeVariables': {
'fontSize': '11px',
'nodePadding': '1',
'nodeBorder': '1',
'lineWidth': '0.8',
'fontFamily': 'Arial'
}
}}%%
flowchart LR
Start(( )) --> pSqlBlockOrStatements
pSqlBlockOrStatements -->| | pSqlBlockOrStatement
pSqlBlockOrStatement --> End(( ))
```
## pSqlNullStatement
```mermaid
%%{init: {
'theme': 'base',
'themeVariables': {
'fontSize': '11px',
'nodePadding': '1',
'nodeBorder': '1',
'lineWidth': '0.8',
'fontFamily': 'Arial'
}
}}%%
flowchart LR
pSqlNullStatement_start([pSqlNullStatement])
pSqlNullStatement_start --> pSqlNullStatement_0_0[NULL]
pSqlNullStatement_0_0 --> pSqlNullStatement_0_1[";"]
pSqlNullStatement_0_1 --> pSqlNullStatement_end(( ))
```
## pSqlReturnStatement
```mermaid
%%{init: {
'theme': 'base',
'themeVariables': {
'fontSize': '11px',
'nodePadding': '1',
'nodeBorder': '1',
'lineWidth': '0.8',
'fontFamily': 'Arial'
}
}}%%
flowchart LR
pSqlReturnStatement_start([pSqlReturnStatement])
pSqlReturnStatement_start --> pSqlReturnStatement_0_0[RETURN]
pSqlReturnStatement_0_0 --> pSqlReturnStatement_0_1[expression]
pSqlReturnStatement_0_1 --> pSqlReturnStatement_0_2[";"]
pSqlReturnStatement_0_2 --> pSqlReturnStatement_end(( ))
```
## pSqlAssignmentStatement
```mermaid
%%{init: {
'theme': 'base',
'themeVariables': {
'fontSize': '11px',
'nodePadding': '1',
'nodeBorder': '1',
'lineWidth': '0.8',
'fontFamily': 'Arial'
}
}}%%
flowchart LR
pSqlAssignmentStatement_start([pSqlAssignmentStatement])
pSqlAssignmentStatement_start --> pSqlAssignmentStatement_0_0[pSqlVariableName]
pSqlAssignmentStatement_0_0 --> pSqlAssignmentStatement_0_1[triggerRecordVariableExpression]
pSqlAssignmentStatement_0_1 --> pSqlAssignmentStatement_0_2[ASSIGNMENT_OPERATOR]
pSqlAssignmentStatement_0_2 --> pSqlAssignmentStatement_0_3[expression]
pSqlAssignmentStatement_0_3 --> pSqlAssignmentStatement_0_4[BATCHSEPARATOR]
pSqlAssignmentStatement_0_4 --> pSqlAssignmentStatement_0_5[pSqlCallProcedureStatement]
pSqlAssignmentStatement_0_5 --> pSqlAssignmentStatement_end(( ))
```
## pSqlContinueStatement
```mermaid
%%{init: {
'theme': 'base',
'themeVariables': {
'fontSize': '11px',
'nodePadding': '1',
'nodeBorder': '1',
'lineWidth': '0.8',
'fontFamily': 'Arial'
}
}}%%
flowchart LR
pSqlContinueStatement_start([pSqlContinueStatement])
pSqlContinueStatement_start --> pSqlContinueStatement_0_0[CONTINUE]
pSqlContinueStatement_0_0 --> pSqlContinueStatement_0_1[WHEN]
pSqlContinueStatement_0_1 --> pSqlContinueStatement_0_2[expression]
pSqlContinueStatement_0_2 --> pSqlContinueStatement_0_3[BATCHSEPARATOR]
pSqlContinueStatement_0_3 --> pSqlContinueStatement_end(( ))
```
## pSqlExecuteImmediateStatement
```mermaid
%%{init: {
'theme': 'base',
'themeVariables': {
'fontSize': '11px',
'nodePadding': '1',
'nodeBorder': '1',
'lineWidth': '0.8',
'fontFamily': 'Arial'
}
}}%%
flowchart LR
pSqlExecuteImmediateStatement_start([pSqlExecuteImmediateStatement])
pSqlExecuteImmediateStatement_start --> pSqlExecuteImmediateStatement_0_0[pSqlExecuteImmediateStatementNS]
pSqlExecuteImmediateStatement_0_0 --> pSqlExecuteImmediateStatement_0_1[BATCHSEPARATOR]
pSqlExecuteImmediateStatement_0_1 --> pSqlExecuteImmediateStatement_end(( ))
```
## pSqlExecuteImmediateStatementNS
```mermaid
%%{init: {
'theme': 'base',
'themeVariables': {
'fontSize': '11px',
'nodePadding': '1',
'nodeBorder': '1',
'lineWidth': '0.8',
'fontFamily': 'Arial'
}
}}%%
flowchart LR
pSqlExecuteImmediateStatementNS_start([pSqlExecuteImmediateStatementNS])
pSqlExecuteImmediateStatementNS_start --> pSqlExecuteImmediateStatementNS_0_0[EXECUTE]
pSqlExecuteImmediateStatementNS_0_0 --> pSqlExecuteImmediateStatementNS_0_1[IMMEDIATE]
pSqlExecuteImmediateStatementNS_0_1 --> pSqlExecuteImmediateStatementNS_0_2[expression]
pSqlExecuteImmediateStatementNS_0_2 --> pSqlExecuteImmediateStatementNS_0_3[into]
pSqlExecuteImmediateStatementNS_0_3 --> pSqlExecuteImmediateStatementNS_0_4[pSqlVariableList]
pSqlExecuteImmediateStatementNS_0_4 --> pSqlExecuteImmediateStatementNS_0_5[pSqlExecuteImmediateUsingClause]
pSqlExecuteImmediateStatementNS_0_5 --> pSqlExecuteImmediateStatementNS_end(( ))
```
## pSqlExecuteImmediateUsingClause
```mermaid
%%{init: {
'theme': 'base',
'themeVariables': {
'fontSize': '11px',
'nodePadding': '1',
'nodeBorder': '1',
'lineWidth': '0.8',
'fontFamily': 'Arial'
}
}}%%
flowchart LR
pSqlExecuteImmediateUsingClause_start([pSqlExecuteImmediateUsingClause])
pSqlExecuteImmediateUsingClause_start --> pSqlExecuteImmediateUsingClause_0_0[USING]
pSqlExecuteImmediateUsingClause_0_0 --> pSqlExecuteImmediateUsingClause_0_1[pSqlExecuteImmediateUsingItem]
pSqlExecuteImmediateUsingClause_0_1 --> pSqlExecuteImmediateUsingClause_0_2[COMMA]
pSqlExecuteImmediateUsingClause_0_2 --> pSqlExecuteImmediateUsingClause_0_3[pSqlExecuteImmediateUsingItem]
pSqlExecuteImmediateUsingClause_0_3 --> pSqlExecuteImmediateUsingClause_end(( ))
```
## pSqlExecuteImmediateUsingItem
```mermaid
%%{init: {
'theme': 'base',
'themeVariables': {
'fontSize': '11px',
'nodePadding': '1',
'nodeBorder': '1',
'lineWidth': '0.8',
'fontFamily': 'Arial'
}
}}%%
flowchart LR
pSqlExecuteImmediateUsingItem_start([pSqlExecuteImmediateUsingItem])
pSqlExecuteImmediateUsingItem_start --> pSqlExecuteImmediateUsingItem_0_0[IN]
pSqlExecuteImmediateUsingItem_0_0 --> pSqlExecuteImmediateUsingItem_0_1[OUT]
pSqlExecuteImmediateUsingItem_0_1 --> pSqlExecuteImmediateUsingItem_0_2[pSqlVariableName]
pSqlExecuteImmediateUsingItem_0_2 --> pSqlExecuteImmediateUsingItem_end(( ))
```
## pSqlExecuteNativeStatement
```mermaid
%%{init: {
'theme': 'base',
'themeVariables': {
'fontSize': '11px',
'nodePadding': '1',
'nodeBorder': '1',
'lineWidth': '0.8',
'fontFamily': 'Arial'
}
}}%%
flowchart LR
pSqlExecuteNativeStatement_start([pSqlExecuteNativeStatement])
pSqlExecuteNativeStatement_start --> pSqlExecuteNativeStatement_0_0[pSqlExecuteNativeStatementNS]
pSqlExecuteNativeStatement_0_0 --> pSqlExecuteNativeStatement_0_1[BATCHSEPARATOR]
pSqlExecuteNativeStatement_0_1 --> pSqlExecuteNativeStatement_end(( ))
```
## pSqlExecuteNativeStatementNS
```mermaid
%%{init: {
'theme': 'base',
'themeVariables': {
'fontSize': '11px',
'nodePadding': '1',
'nodeBorder': '1',
'lineWidth': '0.8',
'fontFamily': 'Arial'
}
}}%%
flowchart LR
pSqlExecuteNativeStatementNS_start([pSqlExecuteNativeStatementNS])
pSqlExecuteNativeStatementNS_start --> pSqlExecuteNativeStatementNS_0_0[EXECUTE]
pSqlExecuteNativeStatementNS_0_0 --> pSqlExecuteNativeStatementNS_0_1[NATIVE]
pSqlExecuteNativeStatementNS_0_1 --> pSqlExecuteNativeStatementNS_0_2[expression]
pSqlExecuteNativeStatementNS_0_2 --> pSqlExecuteNativeStatementNS_0_3[into]
pSqlExecuteNativeStatementNS_0_3 --> pSqlExecuteNativeStatementNS_0_4[pSqlVariableList]
pSqlExecuteNativeStatementNS_0_4 --> pSqlExecuteNativeStatementNS_0_5[DATACONTAINER]
pSqlExecuteNativeStatementNS_0_5 --> pSqlExecuteNativeStatementNS_0_6[stringConstant]
pSqlExecuteNativeStatementNS_0_6 --> pSqlExecuteNativeStatementNS_end(( ))
```
## pSqlExitStatement
```mermaid
%%{init: {
'theme': 'base',
'themeVariables': {
'fontSize': '11px',
'nodePadding': '1',
'nodeBorder': '1',
'lineWidth': '0.8',
'fontFamily': 'Arial'
}
}}%%
flowchart LR
pSqlExitStatement_start([pSqlExitStatement])
pSqlExitStatement_start --> pSqlExitStatement_0_0[EXIT]
pSqlExitStatement_0_0 --> pSqlExitStatement_0_1[WHEN]
pSqlExitStatement_0_1 --> pSqlExitStatement_0_2[expression]
pSqlExitStatement_0_2 --> pSqlExitStatement_0_3[BATCHSEPARATOR]
pSqlExitStatement_0_3 --> pSqlExitStatement_end(( ))
```
## pSqlGotoStatement
```mermaid
%%{init: {
'theme': 'base',
'themeVariables': {
'fontSize': '11px',
'nodePadding': '1',
'nodeBorder': '1',
'lineWidth': '0.8',
'fontFamily': 'Arial'
}
}}%%
flowchart LR
pSqlGotoStatement_start([pSqlGotoStatement])
pSqlGotoStatement_start --> pSqlGotoStatement_0_0[GOTO]
pSqlGotoStatement_0_0 --> pSqlGotoStatement_0_1[pSqlVariableName]
pSqlGotoStatement_0_1 --> pSqlGotoStatement_0_2[BATCHSEPARATOR]
pSqlGotoStatement_0_2 --> pSqlGotoStatement_end(( ))
```
## pSqlLabelStatement
```mermaid
%%{init: {
'theme': 'base',
'themeVariables': {
'fontSize': '11px',
'nodePadding': '1',
'nodeBorder': '1',
'lineWidth': '0.8',
'fontFamily': 'Arial'
}
}}%%
flowchart LR
pSqlLabelStatement_start([pSqlLabelStatement])
pSqlLabelStatement_start --> pSqlLabelStatement_0_0[LT]
pSqlLabelStatement_0_0 --> pSqlLabelStatement_0_1[LT]
pSqlLabelStatement_0_1 --> pSqlLabelStatement_0_2[pSqlVariableName]
pSqlLabelStatement_0_2 --> pSqlLabelStatement_0_3[GT]
pSqlLabelStatement_0_3 --> pSqlLabelStatement_0_4[GT]
pSqlLabelStatement_0_4 --> pSqlLabelStatement_end(( ))
```
## pSqlIfStatement
```mermaid
%%{init: {
'theme': 'base',
'themeVariables': {
'fontSize': '11px',
'nodePadding': '1',
'nodeBorder': '1',
'lineWidth': '0.8',
'fontFamily': 'Arial'
}
}}%%
flowchart LR
pSqlIfStatement_start([pSqlIfStatement])
pSqlIfStatement_start --> pSqlIfStatement_0_0[IF]
pSqlIfStatement_0_0 --> pSqlIfStatement_0_1[expression]
pSqlIfStatement_0_1 --> pSqlIfStatement_0_2[THEN]
pSqlIfStatement_0_2 --> pSqlIfStatement_0_3[pSqlBlockOrStatements]
pSqlIfStatement_0_3 --> pSqlIfStatement_0_4[pSqlElsIfExpression]
pSqlIfStatement_0_4 --> pSqlIfStatement_0_5[ELSE]
pSqlIfStatement_0_5 --> pSqlIfStatement_0_6[pSqlBlockOrStatements]
pSqlIfStatement_0_6 --> pSqlIfStatement_0_7[END]
pSqlIfStatement_0_7 --> pSqlIfStatement_0_8[IF]
pSqlIfStatement_0_8 --> pSqlIfStatement_0_9[BATCHSEPARATOR]
pSqlIfStatement_0_9 --> pSqlIfStatement_end(( ))
```
## pSqlElsIfExpression
```mermaid
%%{init: {
'theme': 'base',
'themeVariables': {
'fontSize': '11px',
'nodePadding': '1',
'nodeBorder': '1',
'lineWidth': '0.8',
'fontFamily': 'Arial'
}
}}%%
flowchart LR
pSqlElsIfExpression_start([pSqlElsIfExpression])
pSqlElsIfExpression_start --> pSqlElsIfExpression_0_0[ELSIF]
pSqlElsIfExpression_0_0 --> pSqlElsIfExpression_0_1[expression]
pSqlElsIfExpression_0_1 --> pSqlElsIfExpression_0_2[THEN]
pSqlElsIfExpression_0_2 --> pSqlElsIfExpression_0_3[pSqlBlockOrStatements]
pSqlElsIfExpression_0_3 --> pSqlElsIfExpression_end(( ))
```
## pSqlLoopStatement
```mermaid
%%{init: {
'theme': 'base',
'themeVariables': {
'fontSize': '11px',
'nodePadding': '1',
'nodeBorder': '1',
'lineWidth': '0.8',
'fontFamily': 'Arial'
}
}}%%
flowchart LR
Start(( )) --> pSqlLoopStatement
pSqlLoopStatement -->| | pSqlForNumberLoopStatement
pSqlForNumberLoopStatement --> End(( ))
pSqlLoopStatement -->| | pSqlForRecordLoopStatement
pSqlForRecordLoopStatement --> End(( ))
pSqlLoopStatement -->| | pSqlWhileLoopStatement
pSqlWhileLoopStatement --> End(( ))
pSqlLoopStatement -->| | pSqlRepeatUntilLoopStatement
pSqlRepeatUntilLoopStatement --> End(( ))
```
## pSqlForNumberLoopStatement
```mermaid
%%{init: {
'theme': 'base',
'themeVariables': {
'fontSize': '11px',
'nodePadding': '1',
'nodeBorder': '1',
'lineWidth': '0.8',
'fontFamily': 'Arial'
}
}}%%
flowchart LR
pSqlForNumberLoopStatement_start([pSqlForNumberLoopStatement])
pSqlForNumberLoopStatement_start --> pSqlForNumberLoopStatement_0_0[FOR]
pSqlForNumberLoopStatement_0_0 --> pSqlForNumberLoopStatement_0_1[pSqlVariableName]
pSqlForNumberLoopStatement_0_1 --> pSqlForNumberLoopStatement_0_2[IN]
pSqlForNumberLoopStatement_0_2 --> pSqlForNumberLoopStatement_0_3[REVERSE]
pSqlForNumberLoopStatement_0_3 --> pSqlForNumberLoopStatement_0_4[expression]
pSqlForNumberLoopStatement_0_4 --> pSqlForNumberLoopStatement_0_5[pSqlVariableName]
pSqlForNumberLoopStatement_0_5 --> pSqlForNumberLoopStatement_0_6[DOT]
pSqlForNumberLoopStatement_0_6 --> pSqlForNumberLoopStatement_0_7[DOT]
pSqlForNumberLoopStatement_0_7 --> pSqlForNumberLoopStatement_0_8[expression]
pSqlForNumberLoopStatement_0_8 --> pSqlForNumberLoopStatement_0_9[pSqlVariableName]
pSqlForNumberLoopStatement_0_9 --> pSqlForNumberLoopStatement_0_10[STEP]
pSqlForNumberLoopStatement_0_10 --> pSqlForNumberLoopStatement_0_11[expression]
pSqlForNumberLoopStatement_0_11 --> pSqlForNumberLoopStatement_0_12[pSqlVariableName]
pSqlForNumberLoopStatement_0_12 --> pSqlForNumberLoopStatement_0_13[LOOP]
pSqlForNumberLoopStatement_0_13 --> pSqlForNumberLoopStatement_0_14[pSqlBlockOrStatements]
pSqlForNumberLoopStatement_0_14 --> pSqlForNumberLoopStatement_0_15[END]
pSqlForNumberLoopStatement_0_15 --> pSqlForNumberLoopStatement_0_16[LOOP]
pSqlForNumberLoopStatement_0_16 --> pSqlForNumberLoopStatement_0_17[BATCHSEPARATOR]
pSqlForNumberLoopStatement_0_17 --> pSqlForNumberLoopStatement_end(( ))
```
## pSqlForRecordLoopStatement
```mermaid
%%{init: {
'theme': 'base',
'themeVariables': {
'fontSize': '11px',
'nodePadding': '1',
'nodeBorder': '1',
'lineWidth': '0.8',
'fontFamily': 'Arial'
}
}}%%
flowchart LR
pSqlForRecordLoopStatement_start([pSqlForRecordLoopStatement])
pSqlForRecordLoopStatement_start --> pSqlForRecordLoopStatement_0_0[FOR]
pSqlForRecordLoopStatement_0_0 --> pSqlForRecordLoopStatement_0_1[pSqlVariableName]
pSqlForRecordLoopStatement_0_1 --> pSqlForRecordLoopStatement_0_2[IN]
pSqlForRecordLoopStatement_0_2 --> pSqlForRecordLoopStatement_0_3[PARENTHESIS_OPEN]
pSqlForRecordLoopStatement_0_3 --> pSqlForRecordLoopStatement_0_4[selectStatement]
pSqlForRecordLoopStatement_0_4 --> pSqlForRecordLoopStatement_0_5[pSqlExecuteImmediateStatementNS]
pSqlForRecordLoopStatement_0_5 --> pSqlForRecordLoopStatement_0_6[pSqlExecuteNativeStatementNS]
pSqlForRecordLoopStatement_0_6 --> pSqlForRecordLoopStatement_0_7[PARENTHESIS_CLOSE]
pSqlForRecordLoopStatement_0_7 --> pSqlForRecordLoopStatement_0_8[LOOP]
pSqlForRecordLoopStatement_0_8 --> pSqlForRecordLoopStatement_0_9[pSqlBlockOrStatements]
pSqlForRecordLoopStatement_0_9 --> pSqlForRecordLoopStatement_0_10[END]
pSqlForRecordLoopStatement_0_10 --> pSqlForRecordLoopStatement_0_11[LOOP]
pSqlForRecordLoopStatement_0_11 --> pSqlForRecordLoopStatement_0_12[BATCHSEPARATOR]
pSqlForRecordLoopStatement_0_12 --> pSqlForRecordLoopStatement_end(( ))
```
## pSqlRepeatUntilLoopStatement
```mermaid
%%{init: {
'theme': 'base',
'themeVariables': {
'fontSize': '11px',
'nodePadding': '1',
'nodeBorder': '1',
'lineWidth': '0.8',
'fontFamily': 'Arial'
}
}}%%
flowchart LR
pSqlRepeatUntilLoopStatement_start([pSqlRepeatUntilLoopStatement])
pSqlRepeatUntilLoopStatement_start --> pSqlRepeatUntilLoopStatement_0_0[LOOP]
pSqlRepeatUntilLoopStatement_0_0 --> pSqlRepeatUntilLoopStatement_0_1[pSqlBlockOrStatements]
pSqlRepeatUntilLoopStatement_0_1 --> pSqlRepeatUntilLoopStatement_0_2[END]
pSqlRepeatUntilLoopStatement_0_2 --> pSqlRepeatUntilLoopStatement_0_3[LOOP]
pSqlRepeatUntilLoopStatement_0_3 --> pSqlRepeatUntilLoopStatement_0_4[BATCHSEPARATOR]
pSqlRepeatUntilLoopStatement_0_4 --> pSqlRepeatUntilLoopStatement_end(( ))
```
## pSqlWhileLoopStatement
```mermaid
%%{init: {
'theme': 'base',
'themeVariables': {
'fontSize': '11px',
'nodePadding': '1',
'nodeBorder': '1',
'lineWidth': '0.8',
'fontFamily': 'Arial'
}
}}%%
flowchart LR
pSqlWhileLoopStatement_start([pSqlWhileLoopStatement])
pSqlWhileLoopStatement_start --> pSqlWhileLoopStatement_0_0[WHILE]
pSqlWhileLoopStatement_0_0 --> pSqlWhileLoopStatement_0_1[expression]
pSqlWhileLoopStatement_0_1 --> pSqlWhileLoopStatement_0_2[LOOP]
pSqlWhileLoopStatement_0_2 --> pSqlWhileLoopStatement_0_3[pSqlBlockOrStatements]
pSqlWhileLoopStatement_0_3 --> pSqlWhileLoopStatement_0_4[END]
pSqlWhileLoopStatement_0_4 --> pSqlWhileLoopStatement_0_5[LOOP]
pSqlWhileLoopStatement_0_5 --> pSqlWhileLoopStatement_0_6[BATCHSEPARATOR]
pSqlWhileLoopStatement_0_6 --> pSqlWhileLoopStatement_end(( ))
```
## pSqlRaiseStatement
```mermaid
%%{init: {
'theme': 'base',
'themeVariables': {
'fontSize': '11px',
'nodePadding': '1',
'nodeBorder': '1',
'lineWidth': '0.8',
'fontFamily': 'Arial'
}
}}%%
flowchart LR
pSqlRaiseStatement_start([pSqlRaiseStatement])
pSqlRaiseStatement_start --> pSqlRaiseStatement_0_0[RAISE]
pSqlRaiseStatement_0_0 --> pSqlRaiseStatement_0_1[INVALID_NUMBER]
pSqlRaiseStatement_0_1 --> pSqlRaiseStatement_0_2[NO_DATA_FOUND]
pSqlRaiseStatement_0_2 --> pSqlRaiseStatement_0_3[PROGRAM_ERROR]
pSqlRaiseStatement_0_3 --> pSqlRaiseStatement_0_4[TOO_MANY_ROWS]
pSqlRaiseStatement_0_4 --> pSqlRaiseStatement_0_5[VALUE_ERROR]
pSqlRaiseStatement_0_5 --> pSqlRaiseStatement_0_6[ZERO_DIVIDE]
pSqlRaiseStatement_0_6 --> pSqlRaiseStatement_0_7[RAISE_APPLICATION_ERROR]
pSqlRaiseStatement_0_7 --> pSqlRaiseStatement_0_8[PARENTHESIS_OPEN]
pSqlRaiseStatement_0_8 --> pSqlRaiseStatement_0_9[numberedOrNamedExpressionList]
pSqlRaiseStatement_0_9 --> pSqlRaiseStatement_0_10[PARENTHESIS_CLOSE]
pSqlRaiseStatement_0_10 --> pSqlRaiseStatement_0_11[BATCHSEPARATOR]
pSqlRaiseStatement_0_11 --> pSqlRaiseStatement_end(( ))
```
## pSqlProcedureStatement
```mermaid
%%{init: {
'theme': 'base',
'themeVariables': {
'fontSize': '11px',
'nodePadding': '1',
'nodeBorder': '1',
'lineWidth': '0.8',
'fontFamily': 'Arial'
}
}}%%
flowchart LR
pSqlProcedureStatement_start([pSqlProcedureStatement])
pSqlProcedureStatement_start --> pSqlProcedureStatement_0_0[identifier]
pSqlProcedureStatement_0_0 --> pSqlProcedureStatement_0_1["("]
pSqlProcedureStatement_0_1 --> pSqlProcedureStatement_0_2[numberedOrNamedExpressionList]
pSqlProcedureStatement_0_2 --> pSqlProcedureStatement_0_3[")"]
pSqlProcedureStatement_0_3 --> pSqlProcedureStatement_0_4[";"]
pSqlProcedureStatement_0_4 --> pSqlProcedureStatement_end(( ))
```
## pSqlCallProcedureStatement
```mermaid
%%{init: {
'theme': 'base',
'themeVariables': {
'fontSize': '11px',
'nodePadding': '1',
'nodeBorder': '1',
'lineWidth': '0.8',
'fontFamily': 'Arial'
}
}}%%
flowchart LR
pSqlCallProcedureStatement_start([pSqlCallProcedureStatement])
pSqlCallProcedureStatement_start --> pSqlCallProcedureStatement_0_0[pSqlCallProcedureStatementNS]
pSqlCallProcedureStatement_0_0 --> pSqlCallProcedureStatement_0_1[BATCHSEPARATOR]
pSqlCallProcedureStatement_0_1 --> pSqlCallProcedureStatement_end(( ))
```
## pSqlCallProcedureStatementNS
```mermaid
%%{init: {
'theme': 'base',
'themeVariables': {
'fontSize': '11px',
'nodePadding': '1',
'nodeBorder': '1',
'lineWidth': '0.8',
'fontFamily': 'Arial'
}
}}%%
flowchart LR
pSqlCallProcedureStatementNS_start([pSqlCallProcedureStatementNS])
pSqlCallProcedureStatementNS_start --> pSqlCallProcedureStatementNS_0_0[identifier]
pSqlCallProcedureStatementNS_0_0 --> pSqlCallProcedureStatementNS_0_1["."]
pSqlCallProcedureStatementNS_0_1 --> pSqlCallProcedureStatementNS_0_2[identifier]
pSqlCallProcedureStatementNS_0_2 --> pSqlCallProcedureStatementNS_0_3[distributedAliasDirective]
pSqlCallProcedureStatementNS_0_3 --> pSqlCallProcedureStatementNS_0_4[parenthesisOpen]
pSqlCallProcedureStatementNS_0_4 --> pSqlCallProcedureStatementNS_0_5[numberedOrNamedExpressionList]
pSqlCallProcedureStatementNS_0_5 --> pSqlCallProcedureStatementNS_0_6[parenthesisClose]
pSqlCallProcedureStatementNS_0_6 --> pSqlCallProcedureStatementNS_end(( ))
```
## pSqlVariableName
```mermaid
%%{init: {
'theme': 'base',
'themeVariables': {
'fontSize': '11px',
'nodePadding': '1',
'nodeBorder': '1',
'lineWidth': '0.8',
'fontFamily': 'Arial'
}
}}%%
flowchart LR
Start(( )) --> pSqlVariableName
pSqlVariableName -->| | identifier
identifier --> End(( ))
```