Table of Contents

Class TPlsqlCreateProcedure

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

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. 
public class TPlsqlCreateProcedure : TCommonStoredProcedureSqlStatement, Visitable
Inheritance
TPlsqlCreateProcedure
Implements
Inherited Members

Constructors

TPlsqlCreateProcedure(EDbVendor) 

public TPlsqlCreateProcedure(EDbVendor dbvendor)

Parameters

dbvendor EDbVendor

Properties

CallSpec 

public virtual TCallSpec CallSpec { get; set; }

Property Value

TCallSpec

call specification

InnerStatements 

public virtual TStatementList InnerStatements { get; set; }

Property Value

TStatementList

Oracle plsql inner statements in declared section before IS keyword.

InvokerRightsClause 

public virtual TInvokerRightsClause InvokerRightsClause { get; set; }

Property Value

TInvokerRightsClause

Kind 

public virtual int Kind { get; set; }

Property Value

int

ProcedureName

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

public virtual TObjectName ProcedureName { get; set; }

Property Value

TObjectName

StoredProcedureName 

public override TObjectName StoredProcedureName { get; }

Property Value

TObjectName

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

init(object)

Initialize a query tree node.

public override void init(object arg1)

Parameters

arg1 object
Edit this page