Package gudusoft.gsqlparser.resolver2.scope

Class PlsqlBlockScope

Object

gudusoft.gsqlparser.resolver2.scope.AbstractScope

gudusoft.gsqlparser.resolver2.scope.PlsqlBlockScope

All Implemented Interfaces:

IScope

public class PlsqlBlockScope
extends AbstractScope

Scope for PL/SQL blocks (Oracle, PostgreSQL PL/pgSQL).

PL/SQL blocks can have labels (<>) that allow referencing variables declared within the block using the label as a qualifier:

 <<main>>
 DECLARE
   ename VARCHAR2(10) := 'KING';
 BEGIN
   DELETE FROM emp WHERE ename = main.ename;  -- main.ename references the block variable
 END;
 

This scope:

• Contains a PlsqlVariableNamespace for declared variables
• Uses the block label as the namespace alias
• Allows name resolution to distinguish block variables from table columns

Field Summary

Fields inherited from class gudusoft.gsqlparser.resolver2.scope.AbstractScope

node, parent, scopeType

Constructor Summary

Constructors

Constructor	Description
PlsqlBlockScope(IScope parent, TBlockSqlNode blockNode)	Create a new PL/SQL block scope for a labeled block.
PlsqlBlockScope(IScope parent, TCustomSqlStatement stmt, String procedureName)	Create a new PL/SQL block scope for a stored procedure or function.

Method Summary

Modifier and Type	Method	Description
void	addChild(INamespace namespace, String alias, boolean nullable)	Default implementation: not supported (most scopes don't have children)
String	getBlockLabel()	Get the block label.
TBlockSqlNode	getBlockNode()	Get the block node.
List<ScopeChild>	getChildren()	Default implementation: empty list
PlsqlVariableNamespace	getVariableNamespace()	Get the variable namespace for this block.
List<INamespace>	getVisibleNamespaces()	Default implementation: delegate to parent
void	resolve(List<String> names, INameMatcher matcher, boolean deep, IResolved resolved)	Default implementation: delegate to parent
INamespace	resolveTable(String tableName)	Default implementation: delegate to parent
String	toString()

Methods inherited from class gudusoft.gsqlparser.resolver2.scope.AbstractScope

fullyQualify, getNode, getParent, getScopeType, isWithin

Methods inherited from class java.lang.Object

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

Constructor Details

PlsqlBlockScope

public PlsqlBlockScope(IScope parent,
 TBlockSqlNode blockNode)

Create a new PL/SQL block scope for a labeled block.

Parameters:

parent - The parent scope

blockNode - The block AST node (TBlockSqlNode)

PlsqlBlockScope

public PlsqlBlockScope(IScope parent,
 TCustomSqlStatement stmt,
 String procedureName)

Create a new PL/SQL block scope for a stored procedure or function. This constructor is used when there's no TBlockSqlNode (e.g., CREATE PROCEDURE).

Parameters:

parent - The parent scope

stmt - The stored procedure/function statement

procedureName - The name of the procedure/function (used as the block label)

Method Details

getBlockLabel

public String getBlockLabel()

Get the block label.

Returns:

The block label, or null for anonymous blocks

getVariableNamespace

public PlsqlVariableNamespace getVariableNamespace()

Get the variable namespace for this block.

Returns:

The PlsqlVariableNamespace containing declared variables

getBlockNode

public TBlockSqlNode getBlockNode()

Get the block node.

Returns:

The TBlockSqlNode AST node

addChild

public void addChild(INamespace namespace,
 String alias,
 boolean nullable)

Description copied from class: AbstractScope

Default implementation: not supported (most scopes don't have children)

Specified by:

addChild in interface IScope

Overrides:

addChild in class AbstractScope

Parameters:

namespace - The namespace to add

alias - The alias for this namespace

nullable - Whether this namespace is nullable (e.g., RIGHT side of LEFT JOIN)

getChildren

public List<ScopeChild> getChildren()

Description copied from class: AbstractScope

Default implementation: empty list

Specified by:

getChildren in interface IScope

Overrides:

getChildren in class AbstractScope

Returns:

List of scope children

resolveTable

public INamespace resolveTable(String tableName)

Description copied from class: AbstractScope

Default implementation: delegate to parent

Specified by:

resolveTable in interface IScope

Overrides:

resolveTable in class AbstractScope

Parameters:

tableName - Table name or alias

Returns:

Namespace if found, null otherwise

resolve

public void resolve(List<String> names,
 INameMatcher matcher,
 boolean deep,
 IResolved resolved)

Description copied from class: AbstractScope

Default implementation: delegate to parent

Specified by:

resolve in interface IScope

Overrides:

resolve in class AbstractScope

Parameters:

names - Name parts (e.g., ["schema", "table", "column"])

matcher - Name matcher for case sensitivity rules

deep - Whether to recursively resolve into record fields

resolved - Callback to collect all matches

getVisibleNamespaces

public List<INamespace> getVisibleNamespaces()

Description copied from class: AbstractScope

Default implementation: delegate to parent

Specified by:

getVisibleNamespaces in interface IScope

Overrides:

getVisibleNamespaces in class AbstractScope

Returns:

List of visible namespaces

toString

public String toString()

Overrides:

toString in class AbstractScope