oracle.javatools.db
Class PlSqlSubprogram

java.lang.Object
  oracle.javatools.db.AbstractDBObject
      oracle.javatools.db.AbstractBuildableObject
          oracle.javatools.db.AbstractSchemaObject
              oracle.javatools.db.PlSql
                  oracle.javatools.db.PlSqlSubprogram

All Implemented Interfaces:

DBObject, DeclarativePlSql, SchemaObject, SourceObject, SystemObject, Copyable, DynamicPropertySet

Direct Known Subclasses:

Function, Procedure

public abstract class PlSqlSubprogram
extends PlSql
implements DeclarativePlSql

Abstract implementation of PlSql for objects that are a simple subprogram (e.g. function or procedure).

Nested Class Summary

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

AbstractDBObject.ChildSupport

Field Summary

Fields inherited from class oracle.javatools.db.PlSql

BLOCK_TYPE

Fields inherited from interface oracle.javatools.db.DBObject

COMMENT

Constructor Summary

PlSqlSubprogram()

PlSqlSubprogram(java.lang.String name, Schema schema)

Method Summary

void	addParameter(int index, PlSqlParameter param) Adds one parameter to this Pl/SQL subprogram at the given index.
void	addParameter(PlSqlParameter p) Adds one parameter to this PlSql subprogram.
protected void	copyToImpl(PlSqlSubprogram copy, DBObject copyParent, IDPolicy idPolicy)
protected boolean	equalsImpl(PlSqlSubprogram target)
java.lang.String	getBody() Deprecated.
protected void	getOwnedObjectsImpl(java.util.Collection<DBObject> c, java.lang.String[] types) Implementation first checks that the object has been built - then returns the collection from suprt.getOwnedObjectsImpl().
PlSqlParameter	getParameter(java.lang.String name) Retrieves one parameter by name.
PlSqlParameter[]	getParameters() Retrieves the list of parameters going into the PlSql subprogram
protected void	getReferenceIDsImpl(java.util.Collection<DBObjectID> refs) Implementation first checks that the object has been built - then returns the collection from suprt.getReferenceIDsImpl().
DataType	getReturnType() Deprecated. - use getReturnTypeID()
DBObjectID	getReturnTypeID()
java.lang.String	getSignature()
void	removeParameter(PlSqlParameter param) Removes a parameter from this Pl/Sql subprogram.
void	setBody(java.lang.String body) Deprecated.
void	setParameters(PlSqlParameter[] newParams) Sets the entire list of parameters, replacing any that have previously been added.
void	setReturnType(DataType returnType) Deprecated. - use setReturnTypeID()
void	setReturnTypeID(DBObjectID returnTypeID)

Methods inherited from class oracle.javatools.db.PlSql

copyToImpl, equalsImpl, getSource, getSourceInterrogator, isPlSql, setSource

Methods inherited from class oracle.javatools.db.AbstractSchemaObject

addObjectListener, copyToImpl, equalsImpl, getParent, getSchema, removeObjectListener, setSchema

Methods inherited from class oracle.javatools.db.AbstractBuildableObject

addObjectListener, checkInit, checkInit, checkInitEx, copyToImpl, equalsImpl, fireObjectUpdated, getProperties, getProperty, getProperty, needsInitialization, removeObjectListener, setProperties, setProperty

Methods inherited from class oracle.javatools.db.AbstractDBObject

changeParent, compareToImpl, copyObject, copyTo, copyTo, copyTo, copyTo, copyToImpl, equalsImpl, findOwnedObject, findOwnedObject, findOwnedObject, getChildSupport, getID, getName, getOwnedObjects, getOwnedObjects, getReferenceIDs, hashCode, includeOwnedObject, includesType, includesType, removeThisAsParent, replaceReferenceIDs, setID, setName, toString

Methods inherited from class java.lang.Object

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

Methods inherited from interface oracle.javatools.db.DBObject

copyTo, copyTo, copyTo, findOwnedObject, findOwnedObject, getID, getName, getOwnedObjects, getOwnedObjects, getParent, getReferenceIDs, getType, replaceReferenceIDs, setID, setName

Methods inherited from interface oracle.javatools.util.DynamicPropertySet

getProperties, getProperty, getProperty, setProperties, setProperty

Methods inherited from interface oracle.javatools.db.SchemaObject

addObjectListener, getSchema, removeObjectListener, setSchema

Methods inherited from interface oracle.javatools.db.SystemObject

addObjectListener, fireObjectUpdated, removeObjectListener

Constructor Detail

PlSqlSubprogram

public PlSqlSubprogram()

PlSqlSubprogram

public PlSqlSubprogram(java.lang.String name,
                       Schema schema)

Method Detail

copyToImpl

protected void copyToImpl(PlSqlSubprogram copy,
                          DBObject copyParent,
                          IDPolicy idPolicy)

equalsImpl

protected boolean equalsImpl(PlSqlSubprogram target)

getReturnType

@Deprecated
public DataType getReturnType()

Deprecated. - use getReturnTypeID()

setReturnType

@Deprecated
public void setReturnType(DataType returnType)

Deprecated. - use setReturnTypeID()

getReturnTypeID

public DBObjectID getReturnTypeID()

Specified by:

getReturnTypeID in interface DeclarativePlSql

setReturnTypeID

public void setReturnTypeID(DBObjectID returnTypeID)

Specified by:

setReturnTypeID in interface DeclarativePlSql

setParameters

public void setParameters(PlSqlParameter[] newParams)

Sets the entire list of parameters, replacing any that have previously been added.

Specified by:

setParameters in interface DeclarativePlSql

Parameters:

newParams - an array containing the new list of parameters

getParameters

public PlSqlParameter[] getParameters()

Retrieves the list of parameters going into the PlSql subprogram

Specified by:

getParameters in interface DeclarativePlSql

Returns:

an array containing the list of parameters

addParameter

public void addParameter(PlSqlParameter p)

Adds one parameter to this PlSql subprogram.

Specified by:

addParameter in interface DeclarativePlSql

Parameters:

p - the new parameter to add

addParameter

public void addParameter(int index,
                         PlSqlParameter param)

Adds one parameter to this Pl/SQL subprogram at the given index. Shift the PlSqlParameter at that position (and any subesquent PlSqlParameters) down one place.

Specified by:

addParameter in interface DeclarativePlSql

Parameters:

index - the index to add the new parameter at

param - the new parameter to add

getParameter

public PlSqlParameter getParameter(java.lang.String name)

Retrieves one parameter by name.

Specified by:

getParameter in interface DeclarativePlSql

Parameters:

a - string containing the desired parameter

Returns:

The parameter requested or null

removeParameter

public void removeParameter(PlSqlParameter param)

Removes a parameter from this Pl/Sql subprogram.

Specified by:

removeParameter in interface DeclarativePlSql

Parameters:

param - the parameter to remove

getBody

@Deprecated
public java.lang.String getBody()

Deprecated.

Specified by:

getBody in interface DeclarativePlSql

setBody

@Deprecated
public void setBody(java.lang.String body)

Deprecated.

Specified by:

setBody in interface DeclarativePlSql

getSignature

public java.lang.String getSignature()

Specified by:

getSignature in interface DeclarativePlSql

getReferenceIDsImpl

protected void getReferenceIDsImpl(java.util.Collection<DBObjectID> refs)

Description copied from class: AbstractBuildableObject

Implementation first checks that the object has been built - then returns the collection from suprt.getReferenceIDsImpl(). All overrides must call this first to ensure the object has been built.

Overrides:

getReferenceIDsImpl in class AbstractBuildableObject

Parameters:

refs - the collection of ids this object references

getOwnedObjectsImpl

protected void getOwnedObjectsImpl(java.util.Collection<DBObject> c,
                                   java.lang.String[] types)

Description copied from class: AbstractBuildableObject

Implementation first checks that the object has been built - then returns the collection from suprt.getOwnedObjectsImpl(). All overrides must call this first to ensure the object has been built.

Overrides:

getOwnedObjectsImpl in class AbstractBuildableObject

Parameters:

c - a Collection of the apppropriate children.

types - a vararg of the type(s) to search for

See Also:

AbstractDBObject.includesType(java.lang.String, java.lang.String...)