public class PLSQLStoredProcedureCall extends StoredProcedureCall
| Modifier and Type | Field and Description |
|---|---|
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.
|
cursorOrdinalPositions, optionalArguments, procedureArgumentNames, procedureNameexecuteReturnValue, fields, fieldsArray, firstResult, FIRSTRESULT_FIELD, hasAllocatedConnection, hasMultipleResultSets, hasOptimisticLock, ignoreFirstRowSetting, ignoreMaxResultsSetting, isBatchExecutionSupported, isCallableStatementRequired, isCursorOutputProcedure, isFieldMatchingRequired, isMultipleCursorOutputProcedure, isResultSetScrollable, MAXROW_FIELD, maxRows, outputCursors, queryTimeout, queryTimeoutUnit, result, resultSetConcurrency, resultSetFetchSize, resultSetType, returnMultipleResultSetCollections, returnsResultSet, shouldBuildOutputRow, shouldCacheStatement, sqlString, statement, usesBindingCUSTOM_MODIFY, EXECUTE_UPDATE, IN, INLINE, 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 and Description |
|---|
PLSQLStoredProcedureCall() |
| Modifier and Type | Method and Description |
|---|---|
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.
|
boolean |
isStoredPLSQLProcedureCall() |
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.
|
addNamedArgument, addNamedArgument, addNamedArgument, addNamedArgument, addNamedArgument, addNamedCursorOutputArgument, addOptionalArgument, addUnnamedCursorOutputArgument, getCallHeader, getCursorOrdinalPosition, getCursorOrdinalPositions, getFirstParameterIndexForCallString, getOptionalArguments, getProcedureArgumentNames, getProcedureName, hasOptionalArguments, isStoredProcedureCall, setCursorOrdinalPosition, setHasMultipleResultSets, setOptionalArguments, setProcedureArgumentNames, setProcedureName, setReturnsResultSet, toString, useCursorOutputResultSet, useUnnamedCursorOutputAsResultSetaddContext, appendIn, appendInOut, appendInOut, appendLogParameters, appendOut, appendOutCursor, appendParameter, bindParameter, buildNewQueryMechanism, buildQueryMechanism, createInOutParameter, getCallString, getContexts, getCursorOutIndex, getExecuteReturnValue, getFields, getFieldsArray, getFieldWithTypeFromDescriptor, getFirstResult, getMaxRows, getOutputCursors, getOutputRowFields, getQueryString, getQueryTimeout, getResult, getResultSetConcurrency, getResultSetFetchSize, getResultSetType, getReturnsResultSet, getSQLString, getStatement, hasAllocatedConnection, hasMultipleResultSets, hasOptimisticLock, hasOutputCursors, isBatchExecutionSupported, isCallableStatementRequired, isCursorOutputProcedure, isCursorReturned, isDynamicCall, isFieldMatchingRequired, isFinished, isLOBLocatorNeeded, isMultipleCursorOutputProcedure, isNonCursorOutputProcedure, isResultSetScrollable, isUsesBindingSet, matchFieldOrder, prepare, prepareInternalParameters, prepareStatement, returnMultipleResultSetCollections, setBatchExecutionSupported, setContexts, setExecuteReturnValue, setFields, setFirstResult, setHasAllocatedConnection, setHasOptimisticLock, setIgnoreFirstRowSetting, setIgnoreMaxResultsSetting, setIsCallableStatementRequired, setIsCursorOutputProcedure, setIsFieldMatchingRequired, setIsMultipleCursorOutputProcedure, setIsResultSetScrollable, setMaxRows, setQueryString, setQueryTimeout, setQueryTimeoutUnit, setResult, setResultSetConcurrency, setResultSetFetchSize, setResultSetType, setReturnMultipleResultSetCollections, setShouldBuildOutputRow, setShouldCacheStatement, setSQLStringInternal, setStatement, setUsesBinding, shouldBuildOutputRow, shouldCacheStatement, shouldCacheStatement, shouldIgnoreFirstRowSetting, shouldIgnoreMaxResultsSetting, translateQueryStringForParameterizedIN, usesBinding, usesBindingappendIn, appendInOut, appendLiteral, appendModify, appendOut, appendTranslation, areManyRowsReturned, argumentMarker, clone, createField, getParameters, getParameterTypes, getQuery, getReturnType, getValueForInOutParameter, getValueForInParameter, hasParameters, isEISInteraction, isExecuteUpdate, isJPQLCall, isNativeConnectionRequired, isNothingReturned, isOneRowReturned, isOutputParameterType, isPrepared, isQueryStringCall, isReturnSet, isSQLCall, isStoredFunctionCall, isStoredPLSQLFunctionCall, returnCursor, returnManyRows, returnNothing, returnOneRow, setExecuteUpdate, setIsNativeConnectionRequired, setIsPrepared, setParameters, setParameterTypes, setQuery, setReturnType, translateCustomQuery, translatePureSQLCustomQuery, translateQueryString, whitespaceprotected 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
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)
StoredProcedureCalladdNamedArgument in class StoredProcedureCallpublic void addNamedArgument(java.lang.String procedureParameterName,
java.lang.String argumentFieldName,
int type,
java.lang.String typeName)
StoredProcedureCalladdNamedArgument in class StoredProcedureCallpublic 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)
StoredProcedureCalladdNamedInOutputArgument in class StoredProcedureCallpublic void addNamedInOutputArgument(java.lang.String procedureParameterName,
java.lang.String inArgumentFieldName,
java.lang.String outArgumentFieldName,
int type,
java.lang.String typeName)
StoredProcedureCalladdNamedInOutputArgument in class StoredProcedureCallpublic void addNamedInOutputArgument(java.lang.String procedureParameterName,
java.lang.String inArgumentFieldName,
java.lang.String outArgumentFieldName,
int type,
java.lang.String typeName,
java.lang.Class classType)
StoredProcedureCalladdNamedInOutputArgument in class StoredProcedureCallpublic 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)
StoredProcedureCalladdNamedInOutputArgument in class StoredProcedureCallpublic 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)
StoredProcedureCalladdNamedOutputArgument in class StoredProcedureCallpublic 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)
StoredProcedureCalladdNamedOutputArgument in class StoredProcedureCallpublic void addNamedOutputArgument(java.lang.String procedureParameterName,
java.lang.String argumentFieldName,
int type,
java.lang.String typeName)
StoredProcedureCalladdNamedOutputArgument in class StoredProcedureCallpublic void addNamedOutputArgument(java.lang.String procedureParameterName,
java.lang.String argumentFieldName,
int type)
StoredProcedureCalladdNamedOutputArgument in class StoredProcedureCallpublic void addNamedArgument(java.lang.String procedureParameterAndArgumentFieldName)
StoredProcedureCalladdNamedArgument in class StoredProcedureCallpublic void addNamedArgumentValue(java.lang.String procedureParameterName,
java.lang.Object argumentValue)
StoredProcedureCalladdNamedArgumentValue in class StoredProcedureCallpublic void addNamedArgument(java.lang.String procedureParameterName,
java.lang.String argumentFieldName)
StoredProcedureCalladdNamedArgument in class StoredProcedureCallpublic void addNamedInOutputArgument(java.lang.String procedureParameterAndArgumentFieldName)
StoredProcedureCalladdNamedInOutputArgument in class StoredProcedureCallpublic void addNamedInOutputArgument(java.lang.String procedureParameterName,
java.lang.String argumentFieldName)
StoredProcedureCalladdNamedInOutputArgument in class StoredProcedureCallpublic void addNamedInOutputArgument(java.lang.String procedureParameterName,
java.lang.String argumentFieldName,
java.lang.Class type)
StoredProcedureCalladdNamedInOutputArgument in class StoredProcedureCallpublic void addNamedInOutputArgument(java.lang.String procedureParameterName,
java.lang.String inArgumentFieldName,
java.lang.String outArgumentFieldName,
java.lang.Class type)
StoredProcedureCalladdNamedInOutputArgument in class StoredProcedureCallpublic void addNamedInOutputArgumentValue(java.lang.String procedureParameterName,
java.lang.Object inArgumentValue,
java.lang.String outArgumentFieldName,
java.lang.Class type)
StoredProcedureCalladdNamedInOutputArgumentValue in class StoredProcedureCallpublic void addNamedOutputArgument(java.lang.String procedureParameterAndArgumentFieldName)
StoredProcedureCalladdNamedOutputArgument in class StoredProcedureCallpublic void addNamedOutputArgument(java.lang.String procedureParameterName,
java.lang.String argumentFieldName)
StoredProcedureCalladdNamedOutputArgument in class StoredProcedureCallpublic void addNamedOutputArgument(java.lang.String procedureParameterName,
java.lang.String argumentFieldName,
java.lang.Class type)
StoredProcedureCalladdNamedOutputArgument in class StoredProcedureCallpublic void useNamedCursorOutputAsResultSet(java.lang.String argumentName)
StoredProcedureCalluseNamedCursorOutputAsResultSet in class StoredProcedureCallpublic void addUnamedArgument(java.lang.String argumentFieldName,
java.lang.Class type)
StoredProcedureCalladdUnamedArgument in class StoredProcedureCallpublic void addUnamedArgument(java.lang.String argumentFieldName,
int type,
java.lang.String typeName,
org.eclipse.persistence.internal.helper.DatabaseField nestedType)
StoredProcedureCalladdUnamedArgument in class StoredProcedureCallpublic void addUnamedArgument(java.lang.String argumentFieldName,
int type,
java.lang.String typeName)
StoredProcedureCalladdUnamedArgument in class StoredProcedureCallpublic void addUnamedArgument(java.lang.String argumentFieldName,
int type)
StoredProcedureCalladdUnamedArgument in class StoredProcedureCallpublic void addUnamedArgument(java.lang.String argumentFieldName)
StoredProcedureCalladdUnamedArgument in class StoredProcedureCallpublic void addUnamedArgumentValue(java.lang.Object argumentValue)
StoredProcedureCalladdUnamedArgumentValue in class StoredProcedureCallpublic void addUnamedInOutputArgument(java.lang.String argumentFieldName,
java.lang.Class type)
StoredProcedureCalladdUnamedInOutputArgument in class StoredProcedureCallpublic void addUnamedInOutputArgument(java.lang.String inArgumentFieldName,
java.lang.String outArgumentFieldName,
java.lang.Class type)
StoredProcedureCalladdUnamedInOutputArgument in class StoredProcedureCallpublic 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)
StoredProcedureCalladdUnamedInOutputArgument in class StoredProcedureCallpublic void addUnamedInOutputArgument(java.lang.String inArgumentFieldName,
java.lang.String outArgumentFieldName,
int type,
java.lang.String typeName,
java.lang.Class collection)
StoredProcedureCalladdUnamedInOutputArgument in class StoredProcedureCallpublic void addUnamedInOutputArgument(java.lang.String inArgumentFieldName,
java.lang.String outArgumentFieldName,
int type,
java.lang.String typeName)
StoredProcedureCalladdUnamedInOutputArgument in class StoredProcedureCallpublic void addUnamedInOutputArgument(java.lang.String inArgumentFieldName,
java.lang.String outArgumentFieldName,
int type)
StoredProcedureCalladdUnamedInOutputArgument in class StoredProcedureCallpublic void addUnamedInOutputArgument(java.lang.String argumentFieldName)
StoredProcedureCalladdUnamedInOutputArgument in class StoredProcedureCallpublic void addUnamedInOutputArgumentValue(java.lang.Object inArgumentValue,
java.lang.String outArgumentFieldName,
java.lang.Class type)
StoredProcedureCalladdUnamedInOutputArgumentValue in class StoredProcedureCallpublic void addUnamedOutputArgument(java.lang.String argumentFieldName,
java.lang.Class type)
StoredProcedureCalladdUnamedOutputArgument in class StoredProcedureCallpublic void addUnamedOutputArgument(java.lang.String argumentFieldName,
int jdbcType,
java.lang.String typeName,
java.lang.Class javaType,
org.eclipse.persistence.internal.helper.DatabaseField nestedType)
StoredProcedureCalladdUnamedOutputArgument in class StoredProcedureCallpublic void addUnamedOutputArgument(java.lang.String argumentFieldName,
int jdbcType,
java.lang.String typeName,
java.lang.Class javaType)
StoredProcedureCalladdUnamedOutputArgument in class StoredProcedureCallpublic void addUnamedOutputArgument(java.lang.String argumentFieldName,
int type,
java.lang.String typeName)
StoredProcedureCalladdUnamedOutputArgument in class StoredProcedureCallpublic void addUnamedOutputArgument(java.lang.String argumentFieldName,
int type)
StoredProcedureCalladdUnamedOutputArgument in class StoredProcedureCallpublic void addUnamedOutputArgument(java.lang.String argumentFieldName)
StoredProcedureCalladdUnamedOutputArgument in class StoredProcedureCallpublic void useUnnamedCursorOutputAsResultSet()
StoredProcedureCalluseUnnamedCursorOutputAsResultSet in class StoredProcedureCallpublic 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 StoredProcedureCallpublic 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.DatabaseCallpublic 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.DatabaseCalljava.sql.SQLExceptionpublic java.lang.String getLogString(org.eclipse.persistence.internal.databaseaccess.Accessor accessor)
getLogString in interface CallgetLogString in class org.eclipse.persistence.internal.databaseaccess.DatabaseCallprotected 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 boolean isStoredPLSQLProcedureCall()
isStoredPLSQLProcedureCall in class org.eclipse.persistence.internal.databaseaccess.DatasourceCallpublic 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)