org.eclipse.persistence.platform.database.oracle.plsql
Class PLSQLStoredProcedureCall

java.lang.Object
  org.eclipse.persistence.internal.databaseaccess.DatasourceCall
      org.eclipse.persistence.internal.databaseaccess.DatabaseCall
          org.eclipse.persistence.queries.StoredProcedureCall
              org.eclipse.persistence.platform.database.oracle.plsql.PLSQLStoredProcedureCall

All Implemented Interfaces:

java.io.Serializable, java.lang.Cloneable, Call

public class PLSQLStoredProcedureCall
extends StoredProcedureCall

Purpose: Generates an Anonymous PL/SQL block to invoke the specified Stored Procedure with arguments that may or may not have JDBC equivalents

See Also:

Serialized Form

Field Summary

protected java.util.List<PLSQLargument>	arguments
static java.lang.String	BEGIN_BEGIN_BLOCK
static java.lang.String	BEGIN_DECLARE_BLOCK
static java.lang.String	END_BEGIN_BLOCK
protected int	originalIndex
protected org.eclipse.persistence.internal.sessions.AbstractRecord	translationRow

Fields inherited from class org.eclipse.persistence.queries.StoredProcedureCall

procedureArgumentNames, procedureName

Fields inherited from class org.eclipse.persistence.internal.databaseaccess.DatabaseCall

fields, firstResult, FIRSTRESULT_FIELD, hasOptimisticLock, ignoreFirstRowMaxResultsSettings, isCallableStatementRequired, isCursorOutputProcedure, isFieldMatchingRequired, isNativeConnectionRequired, isResultSetScrollable, MAXROW_FIELD, maxRows, queryTimeout, result, resultSetConcurrency, resultSetFetchSize, resultSetType, returnsResultSet, shouldBuildOutputRow, shouldCacheStatement, sqlString, statement, usesBinding

Fields inherited from class org.eclipse.persistence.internal.databaseaccess.DatasourceCall

CUSTOM_MODIFY, IN, INOUT, isPrepared, LITERAL, MODIFY, NO_RETURN, OUT, OUT_CURSOR, parameters, parameterTypes, query, RETURN_CURSOR, RETURN_MANY_ROWS, RETURN_ONE_ROW, returnType, shouldProcessTokenInQuotes, shouldUnwrapConnection, TRANSLATION

Constructor Summary

PLSQLStoredProcedureCall()

Method Summary

void	addNamedArgument(java.lang.String procedureParameterAndArgumentFieldName) PUBLIC: Define the argument to the stored procedure and the field/argument name to be substitute for it.
void	addNamedArgument(java.lang.String procedureParameterName, org.eclipse.persistence.internal.helper.DatabaseType databaseType) PUBLIC: Add a named IN argument to the stored procedure.
void	addNamedArgument(java.lang.String procedureParameterName, org.eclipse.persistence.internal.helper.DatabaseType databaseType, int length) PUBLIC: Add a named IN argument to the stored procedure.
void	addNamedArgument(java.lang.String procedureParameterName, org.eclipse.persistence.internal.helper.DatabaseType databaseType, int precision, int scale) PUBLIC: Add a named IN argument to the stored procedure.
void	addNamedArgument(java.lang.String procedureParameterName, java.lang.String argumentFieldName) PUBLIC: Define the argument to the stored procedure and the field/argument name to be substitute for it.
void	addNamedArgument(java.lang.String procedureParameterName, java.lang.String argumentFieldName, int type) PUBLIC: Define the input argument to the stored procedure and the field/argument name to be substitute for it.
void	addNamedArgument(java.lang.String procedureParameterName, java.lang.String argumentFieldName, int type, java.lang.String typeName) PUBLIC: Define the output argument to the stored procedure and the field/argument name to be substitute for it.
void	addNamedArgumentValue(java.lang.String procedureParameterName, java.lang.Object argumentValue) PUBLIC: Define the argument to the stored procedure and the value to be substitute for it.
void	addNamedInOutputArgument(java.lang.String procedureParameterAndArgumentFieldName) PUBLIC: Define the inoutput argument to the stored procedure and the field/argument name to be substitute for it on the way in and out.
void	addNamedInOutputArgument(java.lang.String procedureParameterName, org.eclipse.persistence.internal.helper.DatabaseType databaseType) PUBLIC: Add a named IN OUT argument to the stored procedure.
void	addNamedInOutputArgument(java.lang.String procedureParameterName, org.eclipse.persistence.internal.helper.DatabaseType databaseType, int length) PUBLIC: Add a named IN OUT argument to the stored procedure.
void	addNamedInOutputArgument(java.lang.String procedureParameterName, org.eclipse.persistence.internal.helper.DatabaseType databaseType, int precision, int scale) PUBLIC: Add a named IN OUT argument to the stored procedure.
void	addNamedInOutputArgument(java.lang.String procedureParameterName, java.lang.String argumentFieldName) PUBLIC: Define the inoutput argument to the stored procedure and the field/argument name to be substitute for it on the way in and out.
void	addNamedInOutputArgument(java.lang.String procedureParameterName, java.lang.String argumentFieldName, java.lang.Class type) PUBLIC: Define the inoutput argument to the stored procedure and the field/argument name to be substitute for it on the way in and out.
void	addNamedInOutputArgument(java.lang.String procedureParameterName, java.lang.String inArgumentFieldName, java.lang.String outArgumentFieldName, java.lang.Class type) PUBLIC: Define the inoutput argument to the stored procedure and the field/argument name to be substitute for it on the way in and out.
void	addNamedInOutputArgument(java.lang.String procedureParameterName, java.lang.String inArgumentFieldName, java.lang.String outArgumentFieldName, int type) PUBLIC: Define the inoutput argument to the stored procedure and the field/argument name to be substitute for it on the way in and out.
void	addNamedInOutputArgument(java.lang.String procedureParameterName, java.lang.String inArgumentFieldName, java.lang.String outArgumentFieldName, int type, java.lang.String typeName) PUBLIC: Define the inoutput argument to the stored procedure and the field/argument name to be substitute for it on the way in and out.
void	addNamedInOutputArgument(java.lang.String procedureParameterName, java.lang.String inArgumentFieldName, java.lang.String outArgumentFieldName, int type, java.lang.String typeName, java.lang.Class classType) PUBLIC: Define the inoutput argument to the stored procedure and the field/argument name to be substitute for it on the way in and out.
void	addNamedInOutputArgument(java.lang.String procedureParameterName, java.lang.String inArgumentFieldName, java.lang.String outArgumentFieldName, int type, java.lang.String typeName, java.lang.Class javaType, org.eclipse.persistence.internal.helper.DatabaseField nestedType) PUBLIC: Define the inoutput argument to the stored procedure and the field/argument name to be substitute for it on the way in and out.
void	addNamedInOutputArgumentValue(java.lang.String procedureParameterName, java.lang.Object inArgumentValue, java.lang.String outArgumentFieldName, java.lang.Class type) PUBLIC: Define the inoutput argument to the stored procedure and the field/argument name to be substitute for it on the way in and out.
void	addNamedOutputArgument(java.lang.String procedureParameterAndArgumentFieldName) PUBLIC: Define the output argument to the stored procedure and the field/argument name to be substitute for it.
void	addNamedOutputArgument(java.lang.String procedureParameterName, org.eclipse.persistence.internal.helper.DatabaseType databaseType) PUBLIC: Add a named OUT argument to the stored procedure.
void	addNamedOutputArgument(java.lang.String procedureParameterName, org.eclipse.persistence.internal.helper.DatabaseType databaseType, int length) PUBLIC: Add a named OUT argument to the stored procedure.
void	addNamedOutputArgument(java.lang.String procedureParameterName, org.eclipse.persistence.internal.helper.DatabaseType databaseType, int precision, int scale) PUBLIC: Add a named OUT argument to the stored procedure.
void	addNamedOutputArgument(java.lang.String procedureParameterName, java.lang.String argumentFieldName) PUBLIC: Define the output argument to the stored procedure and the field/argument name to be substitute for it.
void	addNamedOutputArgument(java.lang.String procedureParameterName, java.lang.String argumentFieldName, java.lang.Class type) PUBLIC: Define the output argument to the stored procedure and the field/argument name to be substitute for it.
void	addNamedOutputArgument(java.lang.String procedureParameterName, java.lang.String argumentFieldName, int type) PUBLIC: Define the output argument to the stored procedure and the field/argument name to be substitute for it.
void	addNamedOutputArgument(java.lang.String procedureParameterName, java.lang.String argumentFieldName, int type, java.lang.String typeName) PUBLIC: Define the output argument to the stored procedure and the field/argument name to be substitute for it.
void	addNamedOutputArgument(java.lang.String procedureParameterName, java.lang.String argumentFieldName, int jdbcType, java.lang.String typeName, java.lang.Class javaType) PUBLIC: Define the output argument to the stored procedure and the field/argument name to be substitute for it.
void	addNamedOutputArgument(java.lang.String procedureParameterName, java.lang.String argumentFieldName, int jdbcType, java.lang.String typeName, java.lang.Class javaType, org.eclipse.persistence.internal.helper.DatabaseField nestedType) PUBLIC: Define the output argument to the stored procedure and the field/argument name to be substitute for it.
void	addUnamedArgument(java.lang.String argumentFieldName) PUBLIC: Define the field/argument name to be substitute for the index argument.
void	addUnamedArgument(java.lang.String argumentFieldName, java.lang.Class type) PUBLIC: Define the argument to the stored procedure for the index argument.
void	addUnamedArgument(java.lang.String argumentFieldName, int type) PUBLIC: Define the argument to the stored procedure for the index argument.
void	addUnamedArgument(java.lang.String argumentFieldName, int type, java.lang.String typeName) PUBLIC: Define the argument to the stored procedure for the index argument.
void	addUnamedArgument(java.lang.String argumentFieldName, int type, java.lang.String typeName, org.eclipse.persistence.internal.helper.DatabaseField nestedType) PUBLIC: Define the argument to the stored procedure for the index argument.
void	addUnamedArgumentValue(java.lang.Object argumentValue) PUBLIC: Define the argument to the stored procedure for the index argument.
void	addUnamedInOutputArgument(java.lang.String argumentFieldName) PUBLIC: Define the inoutput argument to the stored procedure for the index argument and the field/argument name to be substitute for it on the way in and out.
void	addUnamedInOutputArgument(java.lang.String argumentFieldName, java.lang.Class type) PUBLIC: Define the inoutput argument to the stored procedure for the index argument and the field/argument name to be substitute for it on the way in and out.
void	addUnamedInOutputArgument(java.lang.String inArgumentFieldName, java.lang.String outArgumentFieldName, java.lang.Class type) PUBLIC: Define the argument to the stored procedure for the index argument.
void	addUnamedInOutputArgument(java.lang.String inArgumentFieldName, java.lang.String outArgumentFieldName, int type) PUBLIC: Define the argument to the stored procedure for the index argument.
void	addUnamedInOutputArgument(java.lang.String inArgumentFieldName, java.lang.String outArgumentFieldName, int type, java.lang.String typeName) PUBLIC: Define the inoutput argument to the stored procedure for the index argument and the field/argument name to be substitute for it on the way in and out.
void	addUnamedInOutputArgument(java.lang.String inArgumentFieldName, java.lang.String outArgumentFieldName, int type, java.lang.String typeName, java.lang.Class collection) PUBLIC: Define the inoutput argument to the stored procedure for the index argument and the field/argument name to be substitute for it on the way in and out.
void	addUnamedInOutputArgument(java.lang.String inArgumentFieldName, java.lang.String outArgumentFieldName, int type, java.lang.String typeName, java.lang.Class collection, org.eclipse.persistence.internal.helper.DatabaseField nestedType) PUBLIC: Define the inoutput argument to the stored procedure for the index argument and the field/argument name to be substitute for it on the way in and out.
void	addUnamedInOutputArgumentValue(java.lang.Object inArgumentValue, java.lang.String outArgumentFieldName, java.lang.Class type) PUBLIC: Define the inoutput argument to the stored procedure for the index argument and the field/argument name to be substitute for it on the way in and out.
void	addUnamedOutputArgument(java.lang.String argumentFieldName) PUBLIC: Define the field/argument name to be substitute for the index output argument.
void	addUnamedOutputArgument(java.lang.String argumentFieldName, java.lang.Class type) PUBLIC: Define the field/argument name to be substitute for the index output argument.
void	addUnamedOutputArgument(java.lang.String argumentFieldName, int type) PUBLIC: Define the field/argument name to be substitute for the index output argument.
void	addUnamedOutputArgument(java.lang.String argumentFieldName, int type, java.lang.String typeName) PUBLIC: Define the field/argument name to be substitute for the index output argument.
void	addUnamedOutputArgument(java.lang.String argumentFieldName, int jdbcType, java.lang.String typeName, java.lang.Class javaType) PUBLIC: Define the field/argument name to be substitute for the index output argument.
void	addUnamedOutputArgument(java.lang.String argumentFieldName, int jdbcType, java.lang.String typeName, java.lang.Class javaType, org.eclipse.persistence.internal.helper.DatabaseField nestedType) PUBLIC: Define the field/argument name to be substitute for the index output argument.
protected void	assignIndices() INTERNAL compute the re-ordered indices - Do the IN args first, then the 'IN-half' of the INOUT args next, the OUT args, then the 'OUT-half' of the INOUT args
protected void	buildBeginBlock(java.lang.StringBuilder sb) INTERNAL Generate portion of the Anonymous PL/SQL block that assigns fields at the beginning of the BEGIN block (before invoking the target procedure)
protected void	buildDeclareBlock(java.lang.StringBuilder sb) INTERNAL Generate portion of the Anonymous PL/SQL block that declares the temporary variables in the DECLARE section
protected void	buildOutAssignments(java.lang.StringBuilder sb) INTERNAL Generate portion of the Anonymous PL/SQL block after the target procedures has been invoked and OUT parameters must be handled
org.eclipse.persistence.internal.sessions.AbstractRecord	buildOutputRow(java.sql.CallableStatement statement)
protected void	buildProcedureInvocation(java.lang.StringBuilder sb) INTERNAL Generate portion of the Anonymous PL/SQL block that invokes the target procedure
protected static java.util.List<PLSQLargument>	getArguments(java.util.List<PLSQLargument> args, java.lang.Integer direction) INTERNAL
java.lang.String	getLogString(org.eclipse.persistence.internal.databaseaccess.Accessor accessor) INTERNAL: Return a string appropriate for the session log.
protected void	prepareInternal(org.eclipse.persistence.internal.sessions.AbstractSession session) Generate the Anonymous PL/SQL block
void	translate(org.eclipse.persistence.internal.sessions.AbstractRecord translationRow, org.eclipse.persistence.internal.sessions.AbstractRecord modifyRow, org.eclipse.persistence.internal.sessions.AbstractSession session)
void	useNamedCursorOutputAsResultSet(java.lang.String argumentName) PUBLIC: Used for Oracle result sets through procedures.
void	useNamedCursorOutputAsResultSet(java.lang.String argumentName, org.eclipse.persistence.internal.helper.DatabaseType databaseType) PUBLIC: Add a named OUT cursor argument to the stored procedure.
void	useUnnamedCursorOutputAsResultSet() PUBLIC: Used for Oracle result sets through procedures.

Methods inherited from class org.eclipse.persistence.queries.StoredProcedureCall

addNamedArgument, addNamedArgument, getCallHeader, getFirstParameterIndexForCallString, getProcedureArgumentNames, getProcedureName, isStoredProcedureCall, setProcedureArgumentNames, setProcedureName, toString

Methods inherited from class org.eclipse.persistence.internal.databaseaccess.DatabaseCall

addContext, appendIn, appendInOut, appendInOut, appendLogParameters, appendOut, appendOutCursor, appendParameter, bindParameter, buildNewQueryMechanism, buildQueryMechanism, createInOutParameter, getCallString, getContexts, getCursorOutIndex, getFields, getFieldWithTypeFromDescriptor, getFirstResult, getMaxRows, getOutputRowFields, getQueryString, getQueryTimeout, getResult, getResultSetConcurrency, getResultSetFetchSize, getResultSetType, getReturnsResultSet, getSQLString, getStatement, hasOptimisticLock, isCallableStatementRequired, isCursorOutputProcedure, isCursorReturned, isDynamicCall, isFieldMatchingRequired, isFinished, isLOBLocatorNeeded, isNativeConnectionRequired, isNonCursorOutputProcedure, isResultSetScrollable, matchFieldOrder, prepare, prepareInternalParameters, prepareStatement, setContexts, setFields, setFirstResult, setHasOptimisticLock, setIgnoreFirstRowMaxResultsSettings, setIsCallableStatementRequired, setIsCursorOutputProcedure, setIsFieldMatchingRequired, setIsNativeConnectionRequired, setIsResultSetScrollable, setMaxRows, setQueryString, setQueryTimeout, setResult, setResultSetConcurrency, setResultSetFetchSize, setResultSetType, setReturnsResultSet, setShouldBuildOutputRow, setShouldCacheStatement, setSQLStringInternal, setStatement, setUsesBinding, shouldBuildOutputRow, shouldCacheStatement, shouldCacheStatement, shouldIgnoreFirstRowMaxResultsSettings, translateQueryStringForParameterizedIN, usesBinding, usesBinding

Methods inherited from class org.eclipse.persistence.internal.databaseaccess.DatasourceCall

appendIn, appendInOut, appendLiteral, appendModify, appendOut, appendTranslation, areManyRowsReturned, argumentMarker, clone, createField, getParameters, getParameterTypes, getQuery, getReturnType, getValueForInOutParameter, getValueForInParameter, hasParameters, isEISInteraction, isJPQLCall, isNothingReturned, isOneRowReturned, isOutputParameterType, isPrepared, isQueryStringCall, isSQLCall, isStoredFunctionCall, returnCursor, returnManyRows, returnNothing, returnOneRow, setIsPrepared, setParameters, setParameterTypes, setQuery, setReturnType, translateCustomQuery, translatePureSQLCustomQuery, translateQueryString, whitespace

Methods inherited from class java.lang.Object

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

Field Detail

BEGIN_DECLARE_BLOCK

public static final java.lang.String BEGIN_DECLARE_BLOCK

See Also:

Constant Field Values

BEGIN_BEGIN_BLOCK

public static final java.lang.String BEGIN_BEGIN_BLOCK

See Also:

Constant Field Values

END_BEGIN_BLOCK

public static final java.lang.String END_BEGIN_BLOCK

See Also:

Constant Field Values

arguments

protected java.util.List<PLSQLargument> arguments

originalIndex

protected int originalIndex

translationRow

protected org.eclipse.persistence.internal.sessions.AbstractRecord translationRow

Constructor Detail

PLSQLStoredProcedureCall

public PLSQLStoredProcedureCall()

Method Detail

addNamedArgument

public void addNamedArgument(java.lang.String procedureParameterName,
                             org.eclipse.persistence.internal.helper.DatabaseType databaseType)

PUBLIC: Add a named IN argument to the stored procedure. The databaseType parameter classifies the parameter (JDBCType vs. OraclePLSQLType, simple vs. complex)

addNamedArgument

public void addNamedArgument(java.lang.String procedureParameterName,
                             org.eclipse.persistence.internal.helper.DatabaseType databaseType,
                             int length)

PUBLIC: Add a named IN argument to the stored procedure. The databaseType parameter classifies the parameter (JDBCType vs. OraclePLSQLType, simple vs. complex). The extra length parameter indicates that this parameter, when used in an Anonymous PL/SQL block, requires a length.

addNamedArgument

public void addNamedArgument(java.lang.String procedureParameterName,
                             org.eclipse.persistence.internal.helper.DatabaseType databaseType,
                             int precision,
                             int scale)

PUBLIC: Add a named IN argument to the stored procedure. The databaseType parameter classifies the parameter (JDBCType vs. OraclePLSQLType, simple vs. complex). The extra scale and precision parameters indicates that this parameter, when used in an Anonymous PL/SQL block, requires scale and precision specification

addNamedArgument

public void addNamedArgument(java.lang.String procedureParameterName,
                             java.lang.String argumentFieldName,
                             int type)

Description copied from class: StoredProcedureCall

PUBLIC: Define the input argument to the stored procedure and the field/argument name to be substitute for it. The procedureParameterName is the name of the procedure argument expected. The argumentFieldName is the field or argument name to be used to pass to the user. If these names are the same (as they normally are) this method can be called with a single argument. The type is the JDBC type code, this is dependent on the type required by the procedure.

Overrides:

addNamedArgument in class StoredProcedureCall

addNamedArgument

public void addNamedArgument(java.lang.String procedureParameterName,
                             java.lang.String argumentFieldName,
                             int type,
                             java.lang.String typeName)

Description copied from class: StoredProcedureCall

PUBLIC: Define the output argument to the stored procedure and the field/argument name to be substitute for it. The procedureParameterName is the name of the procedure argument expected. The argumentFieldName is the field or argument name to be used to pass to the procedure. If these names are the same (as they normally are) this method can be called with a single argument. The type is the JDBC type code, this is dependent on the type required by the procedure. The typeName is the JDBC type name, this may be required for ARRAY or STRUCT types.

Overrides:

addNamedArgument in class StoredProcedureCall

addNamedInOutputArgument

public void addNamedInOutputArgument(java.lang.String procedureParameterName,
                                     org.eclipse.persistence.internal.helper.DatabaseType databaseType)

PUBLIC: Add a named IN OUT argument to the stored procedure. The databaseType parameter classifies the parameter (JDBCType vs. OraclePLSQLType, simple vs. complex)

addNamedInOutputArgument

public void addNamedInOutputArgument(java.lang.String procedureParameterName,
                                     org.eclipse.persistence.internal.helper.DatabaseType databaseType,
                                     int length)

PUBLIC: Add a named IN OUT argument to the stored procedure. The databaseType parameter classifies the parameter (JDBCType vs. OraclePLSQLType, simple vs. complex). The extra length parameter indicates that this parameter, when used in an Anonymous PL/SQL block, requires a length.

addNamedInOutputArgument

public void addNamedInOutputArgument(java.lang.String procedureParameterName,
                                     org.eclipse.persistence.internal.helper.DatabaseType databaseType,
                                     int precision,
                                     int scale)

PUBLIC: Add a named IN OUT argument to the stored procedure. The databaseType parameter classifies the parameter (JDBCType vs. OraclePLSQLType, simple vs. complex). The extra scale and precision parameters indicates that this parameter, when used in an Anonymous PL/SQL block, requires scale and precision specification

addNamedInOutputArgument

public void addNamedInOutputArgument(java.lang.String procedureParameterName,
                                     java.lang.String inArgumentFieldName,
                                     java.lang.String outArgumentFieldName,
                                     int type)

Description copied from class: StoredProcedureCall

PUBLIC: Define the inoutput argument to the stored procedure and the field/argument name to be substitute for it on the way in and out. The procedureParameterName is the name of the procedure argument expected. The inArgumentFieldName is the field or argument name to be used to pass to the procedure. The outArgumentFieldName is the field or argument name to be used is the result of the output row. If these names are the same (as they normally are) this method can be called with a single argument. The type is the JDBC type code, this dependent on the type returned from the procedure.

Overrides:

addNamedInOutputArgument in class StoredProcedureCall

addNamedInOutputArgument

public void addNamedInOutputArgument(java.lang.String procedureParameterName,
                                     java.lang.String inArgumentFieldName,
                                     java.lang.String outArgumentFieldName,
                                     int type,
                                     java.lang.String typeName)

Description copied from class: StoredProcedureCall

PUBLIC: Define the inoutput argument to the stored procedure and the field/argument name to be substitute for it on the way in and out. The procedureParameterName is the name of the procedure argument expected. The inArgumentFieldName is the field or argument name to be used to pass to the procedure. The outArgumentFieldName is the field or argument name to be used is the result of the output row. If these names are the same (as they normally are) this method can be called with a single argument. The type is the JDBC type code, this dependent on the type returned from the procedure. The typeName is the JDBC type name, this may be required for ARRAY or STRUCT types.

Overrides:

addNamedInOutputArgument in class StoredProcedureCall

addNamedInOutputArgument

public void addNamedInOutputArgument(java.lang.String procedureParameterName,
                                     java.lang.String inArgumentFieldName,
                                     java.lang.String outArgumentFieldName,
                                     int type,
                                     java.lang.String typeName,
                                     java.lang.Class classType)

Description copied from class: StoredProcedureCall

PUBLIC: Define the inoutput argument to the stored procedure and the field/argument name to be substitute for it on the way in and out. The procedureParameterName is the name of the procedure argument expected. The inArgumentFieldName is the field or argument name to be used to pass to the procedure. The outArgumentFieldName is the field or argument name to be used is the result of the output row. If these names are the same (as they normally are) this method can be called with a single argument. The type is the JDBC type code, this dependent on the type returned from the procedure. The typeName is the JDBC type name, this may be required for STRUCT and ARRAY types. The classType is the type of Java class desired back from the procedure, this is dependent on the type returned from the procedure.

Overrides:

addNamedInOutputArgument in class StoredProcedureCall

addNamedInOutputArgument

public void addNamedInOutputArgument(java.lang.String procedureParameterName,
                                     java.lang.String inArgumentFieldName,
                                     java.lang.String outArgumentFieldName,
                                     int type,
                                     java.lang.String typeName,
                                     java.lang.Class javaType,
                                     org.eclipse.persistence.internal.helper.DatabaseField nestedType)

Description copied from class: StoredProcedureCall

PUBLIC: Define the inoutput argument to the stored procedure and the field/argument name to be substitute for it on the way in and out. The procedureParameterName is the name of the procedure argument expected. The inArgumentFieldName is the field or argument name to be used to pass to the procedure. The outArgumentFieldName is the field or argument name to be used is the result of the output row. If these names are the same (as they normally are) this method can be called with a single argument. The type is the JDBC type code, this dependent on the type returned from the procedure. The typeName is the JDBC type name, this may be required for ARRAY types. The javaType is the java class to return instead of the ARRAY and STRUCT types if a conversion is possible. The nestedType is a DatabaseField with type information set to match the VARRAYs object types

Overrides:

addNamedInOutputArgument in class StoredProcedureCall

addNamedOutputArgument

public void addNamedOutputArgument(java.lang.String procedureParameterName,
                                   org.eclipse.persistence.internal.helper.DatabaseType databaseType)

PUBLIC: Add a named OUT argument to the stored procedure. The databaseType parameter classifies the parameter (JDBCType vs. OraclePLSQLType, simple vs. complex)

addNamedOutputArgument

public void addNamedOutputArgument(java.lang.String procedureParameterName,
                                   org.eclipse.persistence.internal.helper.DatabaseType databaseType,
                                   int length)

PUBLIC: Add a named OUT argument to the stored procedure. The databaseType parameter classifies the parameter (JDBCType vs. OraclePLSQLType, simple vs. complex). The extra length parameter indicates that this parameter, when used in an Anonymous PL/SQL block, requires a length.

addNamedOutputArgument

public void addNamedOutputArgument(java.lang.String procedureParameterName,
                                   org.eclipse.persistence.internal.helper.DatabaseType databaseType,
                                   int precision,
                                   int scale)

PUBLIC: Add a named OUT argument to the stored procedure. The databaseType parameter classifies the parameter (JDBCType vs. OraclePLSQLType, simple vs. complex). The extra scale and precision parameters indicates that this parameter, when used in an Anonymous PL/SQL block, requires scale and precision specification

addNamedOutputArgument

public void addNamedOutputArgument(java.lang.String procedureParameterName,
                                   java.lang.String argumentFieldName,
                                   int jdbcType,
                                   java.lang.String typeName,
                                   java.lang.Class javaType)

Description copied from class: StoredProcedureCall

PUBLIC: Define the output argument to the stored procedure and the field/argument name to be substitute for it. The procedureParameterName is the name of the procedure argument expected. The argumentFieldName is the field or argument name to be used is the result of the output row. The jdbcType is the JDBC type code, this dependent on the type returned from the procedure. The typeName is the JDBC type name, this may be required for ARRAY and STRUCT types. The javaType is the java class to return instead of the ARRAY and STRUCT types if a conversion is possible.

Overrides:

addNamedOutputArgument in class StoredProcedureCall

addNamedOutputArgument

public void addNamedOutputArgument(java.lang.String procedureParameterName,
                                   java.lang.String argumentFieldName,
                                   int jdbcType,
                                   java.lang.String typeName,
                                   java.lang.Class javaType,
                                   org.eclipse.persistence.internal.helper.DatabaseField nestedType)

Description copied from class: StoredProcedureCall

PUBLIC: Define the output argument to the stored procedure and the field/argument name to be substitute for it. The procedureParameterName is the name of the procedure argument expected. The argumentFieldName is the field or argument name to be used is the result of the output row. The jdbcType is the JDBC type code, this dependent on the type returned from the procedure. The typeName is the JDBC type name, this may be required for ARRAY and STRUCT types. The javaType is the java class to return instead of the ARRAY and STRUCT types if a conversion is possible. The nestedType is a DatabaseField with type information set to match the VARRAYs object types

Overrides:

addNamedOutputArgument in class StoredProcedureCall

addNamedOutputArgument

public void addNamedOutputArgument(java.lang.String procedureParameterName,
                                   java.lang.String argumentFieldName,
                                   int type,
                                   java.lang.String typeName)

Description copied from class: StoredProcedureCall

PUBLIC: Define the output argument to the stored procedure and the field/argument name to be substitute for it. The procedureParameterName is the name of the procedure argument expected. The argumentFieldName is the field or argument name to be used to pass to the procedure. If these names are the same (as they normally are) this method can be called with a single argument. The type is the JDBC type code, this is dependent on the type returned from the procedure. The typeName is the JDBC type name, this may be required for ARRAY or STRUCT types.

Overrides:

addNamedOutputArgument in class StoredProcedureCall

addNamedOutputArgument

public void addNamedOutputArgument(java.lang.String procedureParameterName,
                                   java.lang.String argumentFieldName,
                                   int type)

Description copied from class: StoredProcedureCall

PUBLIC: Define the output argument to the stored procedure and the field/argument name to be substitute for it. The procedureParameterName is the name of the procedure argument expected. The argumentFieldName is the field or argument name to be used to pass to the procedure. If these names are the same (as they normally are) this method can be called with a single argument. The type is the JDBC type code, this is dependent on the type returned from the procedure.

Overrides:

addNamedOutputArgument in class StoredProcedureCall

addNamedArgument

public void addNamedArgument(java.lang.String procedureParameterAndArgumentFieldName)

Description copied from class: StoredProcedureCall

PUBLIC: Define the argument to the stored procedure and the field/argument name to be substitute for it. The procedureParameterAndArgumentFieldName is the name of the procedure argument expected, and is the field or argument name to be used to pass to the procedure. These names are assumed to be the same, if not this method can be called with two arguments.

Overrides:

addNamedArgument in class StoredProcedureCall

addNamedArgumentValue

public void addNamedArgumentValue(java.lang.String procedureParameterName,
                                  java.lang.Object argumentValue)

Description copied from class: StoredProcedureCall

PUBLIC: Define the argument to the stored procedure and the value to be substitute for it. The procedureParameterName is the name of the procedure argument expected. The argumentValue is the value of the argument to be used to pass to the procedure.

Overrides:

addNamedArgumentValue in class StoredProcedureCall

addNamedArgument

public void addNamedArgument(java.lang.String procedureParameterName,
                             java.lang.String argumentFieldName)

Description copied from class: StoredProcedureCall

PUBLIC: Define the argument to the stored procedure and the field/argument name to be substitute for it. The procedureParameterName is the name of the procedure argument expected. The argumentFieldName is the field or argument name to be used to pass to the procedure. If these names are the same (as they normally are) this method can be called with a single argument.

Overrides:

addNamedArgument in class StoredProcedureCall

addNamedInOutputArgument

public void addNamedInOutputArgument(java.lang.String procedureParameterAndArgumentFieldName)

Description copied from class: StoredProcedureCall

PUBLIC: Define the inoutput argument to the stored procedure and the field/argument name to be substitute for it on the way in and out. The procedureParameterAndArgumentFieldName is the name of the procedure argument expected, the field or argument name to be used to pass to the procedure and, the field or argument name to be used is the result of the output row.

Overrides:

addNamedInOutputArgument in class StoredProcedureCall

addNamedInOutputArgument

public void addNamedInOutputArgument(java.lang.String procedureParameterName,
                                     java.lang.String argumentFieldName)

Description copied from class: StoredProcedureCall

PUBLIC: Define the inoutput argument to the stored procedure and the field/argument name to be substitute for it on the way in and out. The procedureParameterName is the name of the procedure argument expected. The argumentFieldName is the field or argument name to be used to pass to the procedure and is the result of the output row.

Overrides:

addNamedInOutputArgument in class StoredProcedureCall

addNamedInOutputArgument

public void addNamedInOutputArgument(java.lang.String procedureParameterName,
                                     java.lang.String argumentFieldName,
                                     java.lang.Class type)

Description copied from class: StoredProcedureCall

PUBLIC: Define the inoutput argument to the stored procedure and the field/argument name to be substitute for it on the way in and out. The procedureParameterName is the name of the procedure argument expected. The argumentFieldName is the field or argument name to be used to pass to the procedure and is the result of the output row. The type is the type of Java class desired back from the procedure, this is dependent on the type returned from the procedure.

Overrides:

addNamedInOutputArgument in class StoredProcedureCall

addNamedInOutputArgument

public void addNamedInOutputArgument(java.lang.String procedureParameterName,
                                     java.lang.String inArgumentFieldName,
                                     java.lang.String outArgumentFieldName,
                                     java.lang.Class type)

Description copied from class: StoredProcedureCall

PUBLIC: Define the inoutput argument to the stored procedure and the field/argument name to be substitute for it on the way in and out. The procedureParameterName is the name of the procedure argument expected. The inArgumentFieldName is the field or argument name to be used to pass to the procedure. The outArgumentFieldName is the field or argument name to be used is the result of the output row. If these names are the same (as they normally are) this method can be called with a single argument. The type the Java class desired back from the procedure, if a struct is returned and the class has an ObjectRelationalDataTypeDescriptor defined .

Overrides:

addNamedInOutputArgument in class StoredProcedureCall

addNamedInOutputArgumentValue

public void addNamedInOutputArgumentValue(java.lang.String procedureParameterName,
                                          java.lang.Object inArgumentValue,
                                          java.lang.String outArgumentFieldName,
                                          java.lang.Class type)

Description copied from class: StoredProcedureCall

PUBLIC: Define the inoutput argument to the stored procedure and the field/argument name to be substitute for it on the way in and out. The procedureParameterName is the name of the procedure argument expected. The inArgumentValue is the value of the argument to be used to pass to the procedure. The outArgumentFieldName is the field or argument name to be used is the result of the output row. If these names are the same (as they normally are) this method can be called with a single argument. The type is the type of Java class desired back from the procedure, this is dependent on the type returned from the procedure.

Overrides:

addNamedInOutputArgumentValue in class StoredProcedureCall

addNamedOutputArgument

public void addNamedOutputArgument(java.lang.String procedureParameterAndArgumentFieldName)

Description copied from class: StoredProcedureCall

PUBLIC: Define the output argument to the stored procedure and the field/argument name to be substitute for it. The procedureParameterAndArgumentFieldName is the name of the procedure argument expected, and is the field or argument name to be used to pass to the procedure. These names are assumed to be the same, if not this method can be called with two arguments.

Overrides:

addNamedOutputArgument in class StoredProcedureCall

addNamedOutputArgument

public void addNamedOutputArgument(java.lang.String procedureParameterName,
                                   java.lang.String argumentFieldName)

Description copied from class: StoredProcedureCall

PUBLIC: Define the output argument to the stored procedure and the field/argument name to be substitute for it. The procedureParameterName is the name of the procedure argument expected. The argumentFieldName is the field or argument name to be used to pass to the procedure. If these names are the same (as they normally are) this method can be called with a single argument.

Overrides:

addNamedOutputArgument in class StoredProcedureCall

addNamedOutputArgument

public void addNamedOutputArgument(java.lang.String procedureParameterName,
                                   java.lang.String argumentFieldName,
                                   java.lang.Class type)

Description copied from class: StoredProcedureCall

PUBLIC: Define the output argument to the stored procedure and the field/argument name to be substitute for it. The procedureParameterName is the name of the procedure argument expected. The argumentFieldName is the field or argument name to be used to pass to the procedure. If these names are the same (as they normally are) this method can be called with a single argument. The type is the type of Java class desired back from the procedure, this is dependent on the type returned from the procedure.

Overrides:

addNamedOutputArgument in class StoredProcedureCall

useNamedCursorOutputAsResultSet

public void useNamedCursorOutputAsResultSet(java.lang.String argumentName)

Description copied from class: StoredProcedureCall

PUBLIC: Used for Oracle result sets through procedures. This can only be used if the arguments are not named but ordered.

Overrides:

useNamedCursorOutputAsResultSet in class StoredProcedureCall

addUnamedArgument

public void addUnamedArgument(java.lang.String argumentFieldName,
                              java.lang.Class type)

Description copied from class: StoredProcedureCall

PUBLIC: Define the argument to the stored procedure for the index argument. This method is used if the procedure is not named and the order is explicit, arguments must be added in the correct order. The argumentFieldName is the field or argument name to be used to pass to the user. The type is the type of Java class for the field, and is dependent on the type required by the procedure. This is used to set the type in case null is passed in.

Overrides:

addUnamedArgument in class StoredProcedureCall

addUnamedArgument

public void addUnamedArgument(java.lang.String argumentFieldName,
                              int type,
                              java.lang.String typeName,
                              org.eclipse.persistence.internal.helper.DatabaseField nestedType)

Description copied from class: StoredProcedureCall

PUBLIC: Define the argument to the stored procedure for the index argument. This method is used if the procedure is not named and the order is explicit, arguments must be added in the correct order. The argumentFieldName is the field or argument name to be used to pass to the procedure. If these names are the same (as they normally are) this method can be called with a single argument. The type is the JDBC type code, this is dependent on the type required by the procedure. The typeName is the JDBC type name, as required for STRUCT and ARRAY types. The nestedType is a DatabaseField with type information set to match the VARRAYs object types

Overrides:

addUnamedArgument in class StoredProcedureCall

addUnamedArgument

public void addUnamedArgument(java.lang.String argumentFieldName,
                              int type,
                              java.lang.String typeName)

Description copied from class: StoredProcedureCall

PUBLIC: Define the argument to the stored procedure for the index argument. This method is used if the procedure is not named and the order is explicit, arguments must be added in the correct order. The argumentFieldName is the field or argument name to be used to pass to the procedure. If these names are the same (as they normally are) this method can be called with a single argument. The type is the JDBC type code, this is dependent on the type required by the procedure. The typeName is the JDBC type name, this may be required for ARRAY or STRUCT types.

Overrides:

addUnamedArgument in class StoredProcedureCall

addUnamedArgument

public void addUnamedArgument(java.lang.String argumentFieldName,
                              int type)

Description copied from class: StoredProcedureCall

PUBLIC: Define the argument to the stored procedure for the index argument. This method is used if the procedure is not named and the order is explicit, arguments must be added in the correct order. The argumentFieldName is the field or argument name to be used to pass to the user. If these names are the same (as they normally are) this method can be called with a single argument. The type is the JDBC type code, this is dependent on the type required by the procedure.

Overrides:

addUnamedArgument in class StoredProcedureCall

addUnamedArgument

public void addUnamedArgument(java.lang.String argumentFieldName)

Description copied from class: StoredProcedureCall

PUBLIC: Define the field/argument name to be substitute for the index argument. This method is used if the procedure is not named and the order is explicit, names must be added in the correct order. The argumentFieldName is the field or argument name to be used to pass to the procedure.

Overrides:

addUnamedArgument in class StoredProcedureCall

addUnamedArgumentValue

public void addUnamedArgumentValue(java.lang.Object argumentValue)

Description copied from class: StoredProcedureCall

PUBLIC: Define the argument to the stored procedure for the index argument. This method is used if the procedure is not named and the order is explicit, arguments must be added in the correct order. The argumentValue is the value of the argument to be used to pass to the procedure.

Overrides:

addUnamedArgumentValue in class StoredProcedureCall

addUnamedInOutputArgument

public void addUnamedInOutputArgument(java.lang.String argumentFieldName,
                                      java.lang.Class type)

Description copied from class: StoredProcedureCall

PUBLIC: Define the inoutput argument to the stored procedure for the index argument and the field/argument name to be substitute for it on the way in and out. This method is used if the procedure is not named and the order is explicit, arguments must be added in the correct order. The argumentFieldName is the field name of the argument to be used to pass to the procedure and to be used is the result of the output row. The type is the type of Java class desired back from the procedure, this is dependent on the type returned from the procedure.

Overrides:

addUnamedInOutputArgument in class StoredProcedureCall

addUnamedInOutputArgument

public void addUnamedInOutputArgument(java.lang.String inArgumentFieldName,
                                      java.lang.String outArgumentFieldName,
                                      java.lang.Class type)

Description copied from class: StoredProcedureCall

PUBLIC: Define the argument to the stored procedure for the index argument. This method is used if the procedure is not named and the order is explicit, arguments must be added in the correct order. The inArgumentFieldName is the field name of the argument to be used to pass to the procedure. The outArgumentFieldName is the field or argument name to be used is the result of the output row. If these names are the same (as they normally are) this method can be called with a single argument. The type is the type of Java class desired back from the procedure, this is dependent on the type returned from the procedure.

Overrides:

addUnamedInOutputArgument in class StoredProcedureCall

addUnamedInOutputArgument

public void addUnamedInOutputArgument(java.lang.String inArgumentFieldName,
                                      java.lang.String outArgumentFieldName,
                                      int type,
                                      java.lang.String typeName,
                                      java.lang.Class collection,
                                      org.eclipse.persistence.internal.helper.DatabaseField nestedType)

Description copied from class: StoredProcedureCall

PUBLIC: Define the inoutput argument to the stored procedure for the index argument and the field/argument name to be substitute for it on the way in and out. This method is used if the procedure is not named and the order is explicit, arguments must be added in the correct order. The argumentFieldName is the field or argument name to be used is the result of the output row. The jdbcType is the JDBC type code, this dependent on the type returned from the procedure. The typeName is the JDBC type name, this may be required for ARRAY and STRUCT types. The javaType is the java class to return instead of the ARRAY and STRUCT types if a conversion is possible. The nestedType is a DatabaseField with type information set to match the VARRAYs object types

Overrides:

addUnamedInOutputArgument in class StoredProcedureCall

addUnamedInOutputArgument

public void addUnamedInOutputArgument(java.lang.String inArgumentFieldName,
                                      java.lang.String outArgumentFieldName,
                                      int type,
                                      java.lang.String typeName,
                                      java.lang.Class collection)

Description copied from class: StoredProcedureCall

PUBLIC: Define the inoutput argument to the stored procedure for the index argument and the field/argument name to be substitute for it on the way in and out. This method is used if the procedure is not named and the order is explicit, arguments must be added in the correct order. The inArgumentFieldName is the field or argument name to be used to pass to the procedure. The outArgumentFieldName is the field or argument name to be used is the result of the output row. If these names are the same (as they normally are) this method can be called with a single argument. The type is the JDBC type code, this dependent on the type returned from the procedure. The typeName is the JDBC type name, this may be required for ARRAY types. The collectionClass is the java class to return instead of the ARRAY type.

Overrides:

addUnamedInOutputArgument in class StoredProcedureCall

addUnamedInOutputArgument

public void addUnamedInOutputArgument(java.lang.String inArgumentFieldName,
                                      java.lang.String outArgumentFieldName,
                                      int type,
                                      java.lang.String typeName)

Description copied from class: StoredProcedureCall

PUBLIC: Define the inoutput argument to the stored procedure for the index argument and the field/argument name to be substitute for it on the way in and out. This method is used if the procedure is not named and the order is explicit, arguments must be added in the correct order. The inArgumentFieldName is the field name of the argument to be used to pass to the procedure. The outArgumentFieldName is the field or argument name to be used is the result of the output row. If these names are the same (as they normally are) this method can be called with a single argument. The type is the JDBC type code, this is dependent on the type returned from the procedure. The typeName is the JDBC type name, this may be required for ARRAY or STRUCT types.

Overrides:

addUnamedInOutputArgument in class StoredProcedureCall

addUnamedInOutputArgument

public void addUnamedInOutputArgument(java.lang.String inArgumentFieldName,
                                      java.lang.String outArgumentFieldName,
                                      int type)

Description copied from class: StoredProcedureCall

PUBLIC: Define the argument to the stored procedure for the index argument. This method is used if the procedure is not named and the order is explicit, arguments must be added in the correct order. The inArgumentFieldName is the field name of the argument to be used to pass to the procedure. The outArgumentFieldName is the field or argument name to be used is the result of the output row. If these names are the same (as they normally are) this method can be called with a single argument. The type is the JDBC type code, this is dependent on the type returned from the procedure.

Overrides:

addUnamedInOutputArgument in class StoredProcedureCall

addUnamedInOutputArgument

public void addUnamedInOutputArgument(java.lang.String argumentFieldName)

Description copied from class: StoredProcedureCall

PUBLIC: Define the inoutput argument to the stored procedure for the index argument and the field/argument name to be substitute for it on the way in and out. This method is used if the procedure is not named and the order is explicit, arguments must be added in the correct order. The argumentFieldName is the field name of the argument to be used to pass to the procedure and to be used is the result of the output row.

Overrides:

addUnamedInOutputArgument in class StoredProcedureCall

addUnamedInOutputArgumentValue

public void addUnamedInOutputArgumentValue(java.lang.Object inArgumentValue,
                                           java.lang.String outArgumentFieldName,
                                           java.lang.Class type)

Description copied from class: StoredProcedureCall

PUBLIC: Define the inoutput argument to the stored procedure for the index argument and the field/argument name to be substitute for it on the way in and out. This method is used if the procedure is not named and the order is explicit, arguments must be added in the correct order. The inArgumentValue is the value of the argument to be used to pass to the procedure. The outArgumentFieldName is the field or argument name to be used is the result of the output row. If these names are the same (as they normally are) this method can be called with a single argument. The type is the type of Java class desired back from the procedure, this is dependent on the type returned from the procedure.

Overrides:

addUnamedInOutputArgumentValue in class StoredProcedureCall

addUnamedOutputArgument

public void addUnamedOutputArgument(java.lang.String argumentFieldName,
                                    java.lang.Class type)

Description copied from class: StoredProcedureCall

PUBLIC: Define the field/argument name to be substitute for the index output argument. This method is used if the procedure is not named and the order is explicit, names must be added in the correct order. The argumentFieldName is the field or argument name to be used to pass to the procedure. The type is the type of Java class desired back from the procedure, this is dependent on the type returned from the procedure.

Overrides:

addUnamedOutputArgument in class StoredProcedureCall

addUnamedOutputArgument

public void addUnamedOutputArgument(java.lang.String argumentFieldName,
                                    int jdbcType,
                                    java.lang.String typeName,
                                    java.lang.Class javaType,
                                    org.eclipse.persistence.internal.helper.DatabaseField nestedType)

Description copied from class: StoredProcedureCall

PUBLIC: Define the field/argument name to be substitute for the index output argument. This method is used if the procedure is not named and the order is explicit, names must be added in the correct order. The argumentFieldName is the field or argument name to be used is the result of the output row. The jdbcType is the JDBC type code, this dependent on the type returned from the procedure. The typeName is the JDBC type name, this may be required for ARRAY and STRUCT types. The javaType is the java class to return instead of the ARRAY and STRUCT types if a conversion is possible. The nestedType is a DatabaseField with type information set to match the VARRAYs object types

Overrides:

addUnamedOutputArgument in class StoredProcedureCall

addUnamedOutputArgument

public void addUnamedOutputArgument(java.lang.String argumentFieldName,
                                    int jdbcType,
                                    java.lang.String typeName,
                                    java.lang.Class javaType)

Description copied from class: StoredProcedureCall

PUBLIC: Define the field/argument name to be substitute for the index output argument. This method is used if the procedure is not named and the order is explicit, names must be added in the correct order. The argumentFieldName is the field or argument name to be used is the result of the output row. The jdbcType is the JDBC type code, this dependent on the type returned from the procedure. The typeName is the JDBC type name, this may be required for ARRAY and STRUCT types. The javaType is the java class to return instead of the ARRAY and STRUCT types if a conversion is possible.

Overrides:

addUnamedOutputArgument in class StoredProcedureCall

addUnamedOutputArgument

public void addUnamedOutputArgument(java.lang.String argumentFieldName,
                                    int type,
                                    java.lang.String typeName)

Description copied from class: StoredProcedureCall

PUBLIC: Define the field/argument name to be substitute for the index output argument. This method is used if the procedure is not named and the order is explicit, names must be added in the correct order. The argumentFieldName is the field or argument name to be used to pass to the procedure. The type is the JDBC type code, this is dependent on the type returned from the procedure. The typeName is the JDBC type name, this may be required for ARRAY or STRUCT types.

Overrides:

addUnamedOutputArgument in class StoredProcedureCall

addUnamedOutputArgument

public void addUnamedOutputArgument(java.lang.String argumentFieldName,
                                    int type)

Description copied from class: StoredProcedureCall

PUBLIC: Define the field/argument name to be substitute for the index output argument. This method is used if the procedure is not named and the order is explicit, names must be added in the correct order. The argumentFieldName is the field or argument name to be used to pass to the procedure. The type is the JDBC type code, this is dependent on the type returned from the procedure.

Overrides:

addUnamedOutputArgument in class StoredProcedureCall

addUnamedOutputArgument

public void addUnamedOutputArgument(java.lang.String argumentFieldName)

Description copied from class: StoredProcedureCall

PUBLIC: Define the field/argument name to be substitute for the index output argument. This method is used if the procedure is not named and the order is explicit, names must be added in the correct order. The argumentFieldName is the field or argument name to be used to pass to the procedure. The type is the type of Java class desired back from the procedure, this is dependent on the type returned from the procedure.

Overrides:

addUnamedOutputArgument in class StoredProcedureCall

useUnnamedCursorOutputAsResultSet

public void useUnnamedCursorOutputAsResultSet()

Description copied from class: StoredProcedureCall

PUBLIC: Used for Oracle result sets through procedures. This can only be used if the arguments are not named but ordered.

Overrides:

useUnnamedCursorOutputAsResultSet in class StoredProcedureCall

useNamedCursorOutputAsResultSet

public void useNamedCursorOutputAsResultSet(java.lang.String argumentName,
                                            org.eclipse.persistence.internal.helper.DatabaseType databaseType)

PUBLIC: Add a named OUT cursor argument to the stored procedure. The databaseType parameter classifies the parameter (JDBCType vs. OraclePLSQLType, simple vs. complex).

assignIndices

protected void assignIndices()

INTERNAL compute the re-ordered indices - Do the IN args first, then the 'IN-half' of the INOUT args next, the OUT args, then the 'OUT-half' of the INOUT args

buildDeclareBlock

protected void buildDeclareBlock(java.lang.StringBuilder sb)

INTERNAL Generate portion of the Anonymous PL/SQL block that declares the temporary variables in the DECLARE section

Parameters:

sb -

buildBeginBlock

protected void buildBeginBlock(java.lang.StringBuilder sb)

INTERNAL Generate portion of the Anonymous PL/SQL block that assigns fields at the beginning of the BEGIN block (before invoking the target procedure)

Parameters:

sb -

buildProcedureInvocation

protected void buildProcedureInvocation(java.lang.StringBuilder sb)

INTERNAL Generate portion of the Anonymous PL/SQL block that invokes the target procedure

Parameters:

sb -

buildOutAssignments

protected void buildOutAssignments(java.lang.StringBuilder sb)

INTERNAL Generate portion of the Anonymous PL/SQL block after the target procedures has been invoked and OUT parameters must be handled

Parameters:

sb -

prepareInternal

protected void prepareInternal(org.eclipse.persistence.internal.sessions.AbstractSession session)

Generate the Anonymous PL/SQL block

Overrides:

prepareInternal in class StoredProcedureCall

translate

public void translate(org.eclipse.persistence.internal.sessions.AbstractRecord translationRow,
                      org.eclipse.persistence.internal.sessions.AbstractRecord modifyRow,
                      org.eclipse.persistence.internal.sessions.AbstractSession session)

Overrides:

translate in class org.eclipse.persistence.internal.databaseaccess.DatabaseCall

buildOutputRow

public org.eclipse.persistence.internal.sessions.AbstractRecord buildOutputRow(java.sql.CallableStatement statement)
                                                                        throws java.sql.SQLException

Overrides:

buildOutputRow in class org.eclipse.persistence.internal.databaseaccess.DatabaseCall

Throws:

java.sql.SQLException

getLogString

public java.lang.String getLogString(org.eclipse.persistence.internal.databaseaccess.Accessor accessor)

Description copied from interface: Call

INTERNAL: Return a string appropriate for the session log.

Specified by:

getLogString in interface Call

Overrides:

getLogString in class org.eclipse.persistence.internal.databaseaccess.DatabaseCall

getArguments

protected static java.util.List<PLSQLargument> getArguments(java.util.List<PLSQLargument> args,
                                                            java.lang.Integer direction)

INTERNAL

Parameters:

args -

direction -

Returns:

list of arguments with the specified direction