|
EclipseLink 2.4.2, build 'v20130514-5956486' API Reference | ||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Objectorg.eclipse.persistence.internal.databaseaccess.DatasourceCall
org.eclipse.persistence.internal.databaseaccess.DatabaseCall
org.eclipse.persistence.queries.StoredProcedureCall
org.eclipse.persistence.platform.database.oracle.plsql.PLSQLStoredProcedureCall
public class PLSQLStoredProcedureCall
Purpose: Generates an Anonymous PL/SQL block to invoke the specified Stored Procedure with arguments that may or may not have JDBC equivalents. This handles conversion of PLSQL Record and Table types into SQL ARRAY (VARRAY) and STRUCT (OBJECT TYPE). It also handles conversion of flat PLSQL Record types and PLSQL BOOLEAN and other basic types.
Field Summary | |
---|---|
protected java.util.List<PLSQLargument> |
arguments
List of procedure IN/OUT/INOUT arguments. |
protected int |
functionId
Id used to generate unique local functions. |
protected int |
originalIndex
Keeps track of the next procedure argument index. |
protected org.eclipse.persistence.internal.sessions.AbstractRecord |
translationRow
Translation row stored after translation on the call clone, used only for logging. |
protected java.util.Map<java.lang.String,org.eclipse.persistence.platform.database.oracle.plsql.PLSQLStoredProcedureCall.TypeInfo> |
typesInfo
Map of conversion function routines for converting complex PLSQL types. |
Fields inherited from class org.eclipse.persistence.queries.StoredProcedureCall |
---|
optionalArguments, procedureArgumentNames, procedureName |
Fields inherited from class org.eclipse.persistence.internal.databaseaccess.DatabaseCall |
---|
fields, fieldsArray, firstResult, FIRSTRESULT_FIELD, hasMultipleResultSets, hasOptimisticLock, ignoreFirstRowSetting, ignoreMaxResultsSetting, isCallableStatementRequired, isCursorOutputProcedure, isFieldMatchingRequired, isResultSetScrollable, MAXROW_FIELD, maxRows, queryTimeout, result, resultSetConcurrency, resultSetFetchSize, resultSetType, returnMultipleResultSetCollections, returnsResultSet, shouldBuildOutputRow, shouldCacheStatement, sqlString, statement, usesBinding |
Fields inherited from class org.eclipse.persistence.internal.databaseaccess.DatasourceCall |
---|
CUSTOM_MODIFY, IN, INOUT, isNativeConnectionRequired, isPrepared, LITERAL, MODIFY, NO_RETURN, OUT, OUT_CURSOR, parameters, parameterTypes, query, RETURN_CURSOR, RETURN_MANY_ROWS, RETURN_ONE_ROW, returnType, shouldProcessTokenInQuotes, 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. |
protected void |
addNestedFunctionsForArgument(java.util.List functions,
PLSQLargument argument,
org.eclipse.persistence.internal.helper.DatabaseType databaseType,
java.util.Set<org.eclipse.persistence.internal.helper.DatabaseType> processed)
INTERNAL Add the nested function string required for the type and its subtypes. |
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,
java.util.List<PLSQLargument> arguments)
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,
java.util.List<PLSQLargument> arguments)
INTERNAL Generate portion of the Anonymous PL/SQL block that declares the temporary variables in the DECLARE section. |
protected void |
buildNestedFunctions(java.lang.StringBuilder stream,
java.util.List<PLSQLargument> arguments)
INTERNAL Generate portion of the Anonymous PL/SQL block with PL/SQL conversion routines as nested functions. |
protected void |
buildOutAssignments(java.lang.StringBuilder sb,
java.util.List<PLSQLargument> arguments)
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,
org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor accessor,
org.eclipse.persistence.internal.sessions.AbstractSession session)
Translate the SQL procedure output row, into the row expected by the PLSQL procedure. |
protected void |
buildProcedureInvocation(java.lang.StringBuilder sb,
java.util.List<PLSQLargument> arguments)
INTERNAL Generate portion of the Anonymous PL/SQL block that invokes the target procedure. |
protected org.eclipse.persistence.platform.database.oracle.plsql.PLSQLStoredProcedureCall.TypeInfo |
generateNestedFunction(org.eclipse.persistence.internal.helper.ComplexDatabaseType type)
INTERNAL: Generate the nested function to convert the PLSQL type to its compatible SQL type. |
protected org.eclipse.persistence.platform.database.oracle.plsql.PLSQLStoredProcedureCall.TypeInfo |
generateNestedFunction(org.eclipse.persistence.internal.helper.ComplexDatabaseType type,
boolean isNonAssociativeCollection)
INTERNAL: Generate the nested function to convert the PLSQL type to its compatible SQL type. |
java.util.List<PLSQLargument> |
getArguments()
Return the PLSQL arguments. |
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: Build the log string for the call. |
java.lang.String |
getPl2SQLName(org.eclipse.persistence.internal.helper.ComplexDatabaseType type)
Return the conversion function name, generate the function if missing. |
java.lang.String |
getSQL2PlName(org.eclipse.persistence.internal.helper.ComplexDatabaseType type)
Return the conversion function name, generate the function if missing. |
protected void |
prepareInternal(org.eclipse.persistence.internal.sessions.AbstractSession session)
Generate the Anonymous PL/SQL block |
void |
setArguments(java.util.List<PLSQLargument> arguments)
Set the PLSQL arguments. |
void |
translate(org.eclipse.persistence.internal.sessions.AbstractRecord translationRow,
org.eclipse.persistence.internal.sessions.AbstractRecord modifyRow,
org.eclipse.persistence.internal.sessions.AbstractSession session)
Translate the PLSQL procedure translation row, into the row expected by the SQL procedure. |
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.internal.databaseaccess.DatabaseCall |
---|
addContext, appendIn, appendInOut, appendInOut, appendLogParameters, appendOut, appendOutCursor, appendParameter, bindParameter, buildNewQueryMechanism, buildQueryMechanism, createInOutParameter, getCallString, getContexts, getCursorOutIndex, getFields, getFieldsArray, getFieldWithTypeFromDescriptor, getFirstResult, getMaxRows, getOutputRowFields, getQueryString, getQueryTimeout, getResult, getResultSetConcurrency, getResultSetFetchSize, getResultSetType, getReturnsResultSet, getSQLString, getStatement, hasMultipleResultSets, hasOptimisticLock, isCallableStatementRequired, isCursorOutputProcedure, isCursorReturned, isDynamicCall, isFieldMatchingRequired, isFinished, isLOBLocatorNeeded, isNonCursorOutputProcedure, isResultSetScrollable, isUsesBindingSet, matchFieldOrder, prepare, prepareInternalParameters, prepareStatement, returnMultipleResultSetCollections, setContexts, setFields, setFirstResult, setHasOptimisticLock, setIgnoreFirstRowSetting, setIgnoreMaxResultsSetting, setIsCallableStatementRequired, setIsCursorOutputProcedure, setIsFieldMatchingRequired, setIsResultSetScrollable, setMaxRows, setQueryString, setQueryTimeout, setResult, setResultSetConcurrency, setResultSetFetchSize, setResultSetType, setReturnMultipleResultSetCollections, setShouldBuildOutputRow, setShouldCacheStatement, setSQLStringInternal, setStatement, setUsesBinding, shouldBuildOutputRow, shouldCacheStatement, shouldCacheStatement, shouldIgnoreFirstRowSetting, shouldIgnoreMaxResultsSetting, 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, isNativeConnectionRequired, isNothingReturned, isOneRowReturned, isOutputParameterType, isPrepared, isQueryStringCall, isReturnSet, isSQLCall, isStoredFunctionCall, returnCursor, returnManyRows, returnNothing, returnOneRow, setIsNativeConnectionRequired, 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 |
---|
protected java.util.List<PLSQLargument> arguments
protected int originalIndex
protected org.eclipse.persistence.internal.sessions.AbstractRecord translationRow
protected java.util.Map<java.lang.String,org.eclipse.persistence.platform.database.oracle.plsql.PLSQLStoredProcedureCall.TypeInfo> typesInfo
protected int functionId
Constructor Detail |
---|
public PLSQLStoredProcedureCall()
Method Detail |
---|
public void addNamedArgument(java.lang.String procedureParameterName, org.eclipse.persistence.internal.helper.DatabaseType databaseType)
public void addNamedArgument(java.lang.String procedureParameterName, org.eclipse.persistence.internal.helper.DatabaseType databaseType, int length)
public void addNamedArgument(java.lang.String procedureParameterName, org.eclipse.persistence.internal.helper.DatabaseType databaseType, int precision, int scale)
public void addNamedArgument(java.lang.String procedureParameterName, java.lang.String argumentFieldName, int type)
StoredProcedureCall
addNamedArgument
in class StoredProcedureCall
public void addNamedArgument(java.lang.String procedureParameterName, java.lang.String argumentFieldName, int type, java.lang.String typeName)
StoredProcedureCall
addNamedArgument
in class StoredProcedureCall
public void addNamedInOutputArgument(java.lang.String procedureParameterName, org.eclipse.persistence.internal.helper.DatabaseType databaseType)
public void addNamedInOutputArgument(java.lang.String procedureParameterName, org.eclipse.persistence.internal.helper.DatabaseType databaseType, int length)
public void addNamedInOutputArgument(java.lang.String procedureParameterName, org.eclipse.persistence.internal.helper.DatabaseType databaseType, int precision, int scale)
public void addNamedInOutputArgument(java.lang.String procedureParameterName, java.lang.String inArgumentFieldName, java.lang.String outArgumentFieldName, int type)
StoredProcedureCall
addNamedInOutputArgument
in class StoredProcedureCall
public void addNamedInOutputArgument(java.lang.String procedureParameterName, java.lang.String inArgumentFieldName, java.lang.String outArgumentFieldName, int type, java.lang.String typeName)
StoredProcedureCall
addNamedInOutputArgument
in class StoredProcedureCall
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)
StoredProcedureCall
addNamedInOutputArgument
in class StoredProcedureCall
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)
StoredProcedureCall
addNamedInOutputArgument
in class StoredProcedureCall
public void addNamedOutputArgument(java.lang.String procedureParameterName, org.eclipse.persistence.internal.helper.DatabaseType databaseType)
public void addNamedOutputArgument(java.lang.String procedureParameterName, org.eclipse.persistence.internal.helper.DatabaseType databaseType, int length)
public void addNamedOutputArgument(java.lang.String procedureParameterName, org.eclipse.persistence.internal.helper.DatabaseType databaseType, int precision, int scale)
public void addNamedOutputArgument(java.lang.String procedureParameterName, java.lang.String argumentFieldName, int jdbcType, java.lang.String typeName, java.lang.Class javaType)
StoredProcedureCall
addNamedOutputArgument
in class StoredProcedureCall
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)
StoredProcedureCall
addNamedOutputArgument
in class StoredProcedureCall
public void addNamedOutputArgument(java.lang.String procedureParameterName, java.lang.String argumentFieldName, int type, java.lang.String typeName)
StoredProcedureCall
addNamedOutputArgument
in class StoredProcedureCall
public void addNamedOutputArgument(java.lang.String procedureParameterName, java.lang.String argumentFieldName, int type)
StoredProcedureCall
addNamedOutputArgument
in class StoredProcedureCall
public void addNamedArgument(java.lang.String procedureParameterAndArgumentFieldName)
StoredProcedureCall
addNamedArgument
in class StoredProcedureCall
public void addNamedArgumentValue(java.lang.String procedureParameterName, java.lang.Object argumentValue)
StoredProcedureCall
addNamedArgumentValue
in class StoredProcedureCall
public void addNamedArgument(java.lang.String procedureParameterName, java.lang.String argumentFieldName)
StoredProcedureCall
addNamedArgument
in class StoredProcedureCall
public void addNamedInOutputArgument(java.lang.String procedureParameterAndArgumentFieldName)
StoredProcedureCall
addNamedInOutputArgument
in class StoredProcedureCall
public void addNamedInOutputArgument(java.lang.String procedureParameterName, java.lang.String argumentFieldName)
StoredProcedureCall
addNamedInOutputArgument
in class StoredProcedureCall
public void addNamedInOutputArgument(java.lang.String procedureParameterName, java.lang.String argumentFieldName, java.lang.Class type)
StoredProcedureCall
addNamedInOutputArgument
in class StoredProcedureCall
public void addNamedInOutputArgument(java.lang.String procedureParameterName, java.lang.String inArgumentFieldName, java.lang.String outArgumentFieldName, java.lang.Class type)
StoredProcedureCall
addNamedInOutputArgument
in class StoredProcedureCall
public void addNamedInOutputArgumentValue(java.lang.String procedureParameterName, java.lang.Object inArgumentValue, java.lang.String outArgumentFieldName, java.lang.Class type)
StoredProcedureCall
addNamedInOutputArgumentValue
in class StoredProcedureCall
public void addNamedOutputArgument(java.lang.String procedureParameterAndArgumentFieldName)
StoredProcedureCall
addNamedOutputArgument
in class StoredProcedureCall
public void addNamedOutputArgument(java.lang.String procedureParameterName, java.lang.String argumentFieldName)
StoredProcedureCall
addNamedOutputArgument
in class StoredProcedureCall
public void addNamedOutputArgument(java.lang.String procedureParameterName, java.lang.String argumentFieldName, java.lang.Class type)
StoredProcedureCall
addNamedOutputArgument
in class StoredProcedureCall
public void useNamedCursorOutputAsResultSet(java.lang.String argumentName)
StoredProcedureCall
useNamedCursorOutputAsResultSet
in class StoredProcedureCall
public void addUnamedArgument(java.lang.String argumentFieldName, java.lang.Class type)
StoredProcedureCall
addUnamedArgument
in class StoredProcedureCall
public void addUnamedArgument(java.lang.String argumentFieldName, int type, java.lang.String typeName, org.eclipse.persistence.internal.helper.DatabaseField nestedType)
StoredProcedureCall
addUnamedArgument
in class StoredProcedureCall
public void addUnamedArgument(java.lang.String argumentFieldName, int type, java.lang.String typeName)
StoredProcedureCall
addUnamedArgument
in class StoredProcedureCall
public void addUnamedArgument(java.lang.String argumentFieldName, int type)
StoredProcedureCall
addUnamedArgument
in class StoredProcedureCall
public void addUnamedArgument(java.lang.String argumentFieldName)
StoredProcedureCall
addUnamedArgument
in class StoredProcedureCall
public void addUnamedArgumentValue(java.lang.Object argumentValue)
StoredProcedureCall
addUnamedArgumentValue
in class StoredProcedureCall
public void addUnamedInOutputArgument(java.lang.String argumentFieldName, java.lang.Class type)
StoredProcedureCall
addUnamedInOutputArgument
in class StoredProcedureCall
public void addUnamedInOutputArgument(java.lang.String inArgumentFieldName, java.lang.String outArgumentFieldName, java.lang.Class type)
StoredProcedureCall
addUnamedInOutputArgument
in class StoredProcedureCall
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)
StoredProcedureCall
addUnamedInOutputArgument
in class StoredProcedureCall
public void addUnamedInOutputArgument(java.lang.String inArgumentFieldName, java.lang.String outArgumentFieldName, int type, java.lang.String typeName, java.lang.Class collection)
StoredProcedureCall
addUnamedInOutputArgument
in class StoredProcedureCall
public void addUnamedInOutputArgument(java.lang.String inArgumentFieldName, java.lang.String outArgumentFieldName, int type, java.lang.String typeName)
StoredProcedureCall
addUnamedInOutputArgument
in class StoredProcedureCall
public void addUnamedInOutputArgument(java.lang.String inArgumentFieldName, java.lang.String outArgumentFieldName, int type)
StoredProcedureCall
addUnamedInOutputArgument
in class StoredProcedureCall
public void addUnamedInOutputArgument(java.lang.String argumentFieldName)
StoredProcedureCall
addUnamedInOutputArgument
in class StoredProcedureCall
public void addUnamedInOutputArgumentValue(java.lang.Object inArgumentValue, java.lang.String outArgumentFieldName, java.lang.Class type)
StoredProcedureCall
addUnamedInOutputArgumentValue
in class StoredProcedureCall
public void addUnamedOutputArgument(java.lang.String argumentFieldName, java.lang.Class type)
StoredProcedureCall
addUnamedOutputArgument
in class StoredProcedureCall
public void addUnamedOutputArgument(java.lang.String argumentFieldName, int jdbcType, java.lang.String typeName, java.lang.Class javaType, org.eclipse.persistence.internal.helper.DatabaseField nestedType)
StoredProcedureCall
addUnamedOutputArgument
in class StoredProcedureCall
public void addUnamedOutputArgument(java.lang.String argumentFieldName, int jdbcType, java.lang.String typeName, java.lang.Class javaType)
StoredProcedureCall
addUnamedOutputArgument
in class StoredProcedureCall
public void addUnamedOutputArgument(java.lang.String argumentFieldName, int type, java.lang.String typeName)
StoredProcedureCall
addUnamedOutputArgument
in class StoredProcedureCall
public void addUnamedOutputArgument(java.lang.String argumentFieldName, int type)
StoredProcedureCall
addUnamedOutputArgument
in class StoredProcedureCall
public void addUnamedOutputArgument(java.lang.String argumentFieldName)
StoredProcedureCall
addUnamedOutputArgument
in class StoredProcedureCall
public void useUnnamedCursorOutputAsResultSet()
StoredProcedureCall
useUnnamedCursorOutputAsResultSet
in class StoredProcedureCall
public void useNamedCursorOutputAsResultSet(java.lang.String argumentName, org.eclipse.persistence.internal.helper.DatabaseType databaseType)
protected void assignIndices()
protected void buildDeclareBlock(java.lang.StringBuilder sb, java.util.List<PLSQLargument> arguments)
protected void addNestedFunctionsForArgument(java.util.List functions, PLSQLargument argument, org.eclipse.persistence.internal.helper.DatabaseType databaseType, java.util.Set<org.eclipse.persistence.internal.helper.DatabaseType> processed)
protected org.eclipse.persistence.platform.database.oracle.plsql.PLSQLStoredProcedureCall.TypeInfo generateNestedFunction(org.eclipse.persistence.internal.helper.ComplexDatabaseType type)
protected org.eclipse.persistence.platform.database.oracle.plsql.PLSQLStoredProcedureCall.TypeInfo generateNestedFunction(org.eclipse.persistence.internal.helper.ComplexDatabaseType type, boolean isNonAssociativeCollection)
protected void buildNestedFunctions(java.lang.StringBuilder stream, java.util.List<PLSQLargument> arguments)
protected void buildBeginBlock(java.lang.StringBuilder sb, java.util.List<PLSQLargument> arguments)
protected void buildProcedureInvocation(java.lang.StringBuilder sb, java.util.List<PLSQLargument> arguments)
protected void buildOutAssignments(java.lang.StringBuilder sb, java.util.List<PLSQLargument> arguments)
protected void prepareInternal(org.eclipse.persistence.internal.sessions.AbstractSession session)
prepareInternal
in class StoredProcedureCall
public void translate(org.eclipse.persistence.internal.sessions.AbstractRecord translationRow, org.eclipse.persistence.internal.sessions.AbstractRecord modifyRow, org.eclipse.persistence.internal.sessions.AbstractSession session)
translate
in class org.eclipse.persistence.internal.databaseaccess.DatabaseCall
public org.eclipse.persistence.internal.sessions.AbstractRecord buildOutputRow(java.sql.CallableStatement statement, org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor accessor, org.eclipse.persistence.internal.sessions.AbstractSession session) throws java.sql.SQLException
buildOutputRow
in class org.eclipse.persistence.internal.databaseaccess.DatabaseCall
java.sql.SQLException
public java.lang.String getLogString(org.eclipse.persistence.internal.databaseaccess.Accessor accessor)
getLogString
in interface Call
getLogString
in class org.eclipse.persistence.internal.databaseaccess.DatabaseCall
protected static java.util.List<PLSQLargument> getArguments(java.util.List<PLSQLargument> args, java.lang.Integer direction)
args
- direction
-
public java.lang.String getSQL2PlName(org.eclipse.persistence.internal.helper.ComplexDatabaseType type)
public java.lang.String getPl2SQLName(org.eclipse.persistence.internal.helper.ComplexDatabaseType type)
public java.util.List<PLSQLargument> getArguments()
public void setArguments(java.util.List<PLSQLargument> arguments)
|
EclipseLink 2.4.2, build 'v20130514-5956486' API Reference | ||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |