oracle.javatools.db.plsql

Class PlSqlBlock

java.lang.Object

oracle.javatools.db.AbstractDBObject

oracle.javatools.db.AbstractBuildableObject

oracle.javatools.db.AbstractChildBuildableObject

oracle.javatools.db.plsql.DBObjectPlSqlFragment

oracle.javatools.db.plsql.PlSqlCodeFragment

oracle.javatools.db.plsql.PlSqlStatement

oracle.javatools.db.plsql.PlSqlBlock

All Implemented Interfaces:

ChildDBObject, DBObject, Copyable

Direct Known Subclasses:

PlSqlSchemaObject, PlSqlSubProgram

public class PlSqlBlock
extends PlSqlStatement

When instantiated as a concrete class, this represents a PL/SQL Block. However it also acts as a generic superclass for any PL/SQL object that may contain declarations of variables, sub programs and datatypes, and references to other objects. As such it is in the class hierarchy of PlSqlSubProgram and all the SchemaObject types: Procedure, Function, Package, PackageBody, Type, TypeBody and Trigger.

Nested Class Summary

Nested classes/interfaces inherited from class oracle.javatools.db.plsql.PlSqlStatement

PlSqlStatement.Type

Nested classes/interfaces inherited from class oracle.javatools.db.AbstractDBObject

AbstractDBObject.ChildSupport, AbstractDBObject.ListenerSupport

Field Summary

Fields

Modifier and Type	Field and Description
static java.lang.String	TYPE

Fields inherited from interface oracle.javatools.db.DBObject

COMMENT

Constructor Summary

Constructors

Constructor and Description
PlSqlBlock()
PlSqlBlock(java.lang.String name, DBObject parent)

Method Summary

Modifier and Type	Method and Description
void	addBlock(PlSqlBlock block) Deprecated. Use super.addStatement()
void	addDatatype(PlSqlDatatype datatype) Adds the given PlSqlDatatype to the Datatypes property array
void	addSubProgram(PlSqlSubProgram subProgram) Adds the given PlSqlSubProgram to the SubPrograms property array
void	addVariable(PlSqlVariable variable) Adds the given PlSqlVariable to the Variables property array
DBObject	findOwnedObject(DBObjectID id, boolean strict) Returns a child of this object that has the given ID.
PlSqlBlock[]	getBlocks() Deprecated. Use super.getStatements()
PlSqlDatatype[]	getDatatypes() Get method for the Datatypes property
PlSqlSubProgram	getSubProgram(java.lang.String name) Gets a SubProgram of the given name
PlSqlSubProgram[]	getSubPrograms() Get method for the SubPrograms property
java.lang.String	getType() Returns the type of this object.
PlSqlVariable	getVariable(java.lang.String name) Gets a Variable of the given name
PlSqlVariable[]	getVariables() Get method for the Variables property
void	setBlocks(PlSqlBlock[] blocks) Deprecated. Use super.setStatements()
void	setDatatypes(PlSqlDatatype[] datatypes) Set method for the Datatypes property
void	setSubPrograms(PlSqlSubProgram[] subPrograms) Set method for the SubPrograms property
void	setVariables(PlSqlVariable[] variables) Set method for the Variables property

Methods inherited from class oracle.javatools.db.plsql.PlSqlStatement

addStatement, getStatements, getStatementType, setStatements, setStatementType

Methods inherited from class oracle.javatools.db.plsql.PlSqlCodeFragment

addComment, addPropertyReference, addReference, getComments, getPropertyReferences, getReferences, setComments, setPropertyReferences, setReferences

Methods inherited from class oracle.javatools.db.plsql.DBObjectPlSqlFragment

copyToImpl, getChildAtOffset, getDeclarationAtOffset, getEndOffset, getName, getReferenceAtOffset, getSource, getSourceID, getStartOffset, setEndOffset, setSource, setSourceImpl, setStartOffset

Methods inherited from class oracle.javatools.db.AbstractChildBuildableObject

setParent

Methods inherited from class oracle.javatools.db.AbstractBuildableObject

checkInit, checkInit, getOwnedObjectsImpl, getProperties, getReferenceIDsImpl, needsInitialization, processPropertyChange, setID

Methods inherited from class oracle.javatools.db.AbstractDBObject

addObjectListener, addObjectListener, addObjectListener, changeParent, compareToImpl, copyObject, copyTo, copyTo, copyTo, copyTo, equals, equalsImpl, findOwnedObject, findOwnedObject, findOwnedObject, findParent, fireObjectUpdated, firePropertyChanged, getChildSupport, getChildSupport, getID, getOwnedObjects, getOwnedObjects, getParent, getProperty, getProperty, getReferenceIDs, hashCode, includeOwnedObject, includesType, includesType, removeObjectListener, removeObjectListener, removeObjectListener, removeOwnedObject, removeThisAsParent, replaceReferenceIDs, setName, setProperties, setProperty, toString

Methods inherited from class java.lang.Object

clone, finalize, getClass, notify, notifyAll, wait, wait, wait

Methods inherited from interface oracle.javatools.db.ChildDBObject

getParent

Methods inherited from interface oracle.javatools.db.DBObject

addObjectListener, copyTo, copyTo, copyTo, equals, findOwnedObject, findOwnedObject, getID, getOwnedObjects, getOwnedObjects, getProperties, getProperty, getProperty, getReferenceIDs, hashCode, removeObjectListener, removeOwnedObject, replaceReferenceIDs, setID, setName, setProperties, setProperty

Field Detail

TYPE

public static final java.lang.String TYPE

See Also:

Constant Field Values

Constructor Detail

PlSqlBlock

public PlSqlBlock()

PlSqlBlock

public PlSqlBlock(java.lang.String name,
                  DBObject parent)

Method Detail

getType

public java.lang.String getType()

Description copied from interface: DBObject

Returns the type of this object. Valid types include things like tables, views, synonyms, and columns.

Specified by:

getType in interface DBObject

Overrides:

getType in class PlSqlStatement

Returns:

a string describing the type of object.

setBlocks

@Deprecated
public void setBlocks(PlSqlBlock[] blocks)

Deprecated. Use super.setStatements()

getBlocks

@Deprecated
public PlSqlBlock[] getBlocks()

Deprecated. Use super.getStatements()

addBlock

@Deprecated
public void addBlock(PlSqlBlock block)

Deprecated. Use super.addStatement()

setVariables

public void setVariables(PlSqlVariable[] variables)

Set method for the Variables property

Parameters:

variables - Variables defined within this PlSqlBlock

Since:

11.1.2.0.0

getVariables

public PlSqlVariable[] getVariables()

Get method for the Variables property

Returns:

Variables defined within this PlSqlBlock

Since:

11.1.2.0.0

getVariable

public PlSqlVariable getVariable(java.lang.String name)

Gets a Variable of the given name

Returns:

Variable of the given name defined within this PlSqlBlock, or null

Since:

11.1.2.0.0

addVariable

public void addVariable(PlSqlVariable variable)

Adds the given PlSqlVariable to the Variables property array

Parameters:

variable - Variables defined within this PlSqlBlock

Since:

11.1.2.0.0

setSubPrograms

public void setSubPrograms(PlSqlSubProgram[] subPrograms)

Set method for the SubPrograms property

Parameters:

subPrograms - SubPrograms (procedures and functions) defined within this PlSqlBlock

Since:

11.1.2.0.0

getSubPrograms

public PlSqlSubProgram[] getSubPrograms()

Get method for the SubPrograms property

Returns:

SubPrograms (procedures and functions) defined within this PlSqlBlock

Since:

11.1.2.0.0

getSubProgram

public PlSqlSubProgram getSubProgram(java.lang.String name)

Gets a SubProgram of the given name

Returns:

SubProgram (procedure or function) of the given name defined within this PlSqlBlock, or null

Since:

11.1.2.0.0

addSubProgram

public void addSubProgram(PlSqlSubProgram subProgram)

Adds the given PlSqlSubProgram to the SubPrograms property array

Parameters:

subProgram - SubProgram (procedure or function) of the given name defined within this PlSqlBlock

Since:

11.1.2.0.0

setDatatypes

public void setDatatypes(PlSqlDatatype[] datatypes)

Set method for the Datatypes property

Parameters:

datatypes - DataTypes defined within this PlSqlBlock

Since:

11.1.2.0.0

getDatatypes

public PlSqlDatatype[] getDatatypes()

Get method for the Datatypes property

Returns:

DataTypes defined within this PlSqlBlock

Since:

11.1.2.0.0

addDatatype

public void addDatatype(PlSqlDatatype datatype)

Adds the given PlSqlDatatype to the Datatypes property array

Parameters:

datatype - DataType defined within this PlSqlBlock

Since:

11.1.2.0.0

findOwnedObject

public DBObject findOwnedObject(DBObjectID id,
                                boolean strict)

Description copied from interface: DBObject

Returns a child of this object that has the given ID. The child is located by comparing IDs, not by calling resolveID() and is therefore the quickest way to locate a DBObject if you know its parent.

Note: an unstrict comparison can be time consuming, only request it if you need it (i.e. you are searching using a DBObjectID that did not originate in this object's heirarchy).

The method does not recurse to look for children of children.

This will not find SchemaObjects in a Schema, as in the API the Schema -> SchemaObject relationship is not an owner -> owned object relationship.

Specified by:

findOwnedObject in interface DBObject

Overrides:

findOwnedObject in class AbstractDBObject

Parameters:

id - the id to look for

strict - whether to stricly compare IDs or not

Returns:

a child object found with a matching id, or null if no child is found

See Also:

DBObjectID.equals(DBObjectID,boolean)