|
Oracle Fusion Middleware Java API Reference for Oracle TopLink 11g Release 1 (11.1.1) E28847-01 |
||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
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
org.eclipse.persistence.platform.database.oracle.plsql.PLSQLStoredFunctionCall
public class PLSQLStoredFunctionCall
Purpose: Used to define a platform independent function call. Note that not all platforms support stored functions. This supports output parameters. Functions can also be called through custom SQL.
Nested Class Summary |
---|
Nested classes/interfaces inherited from class org.eclipse.persistence.platform.database.oracle.plsql.PLSQLStoredProcedureCall |
---|
PLSQLStoredProcedureCall.TypeInfo |
Field Summary |
---|
Fields inherited from class org.eclipse.persistence.platform.database.oracle.plsql.PLSQLStoredProcedureCall |
---|
arguments, BEGIN_BEGIN_BLOCK, BEGIN_DECLARE_BLOCK, BEGIN_DECLARE_FUNCTION, END_BEGIN_BLOCK, functionId, originalIndex, PL2SQL_PREFIX, RTURN, SQL2PL_PREFIX, translationRow, typesInfo |
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, 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 | |
---|---|
PLSQLStoredFunctionCall() |
|
PLSQLStoredFunctionCall(org.eclipse.persistence.internal.helper.DatabaseType databaseType) |
|
PLSQLStoredFunctionCall(org.eclipse.persistence.internal.helper.DatabaseType databaseType, int length) |
|
PLSQLStoredFunctionCall(org.eclipse.persistence.internal.helper.DatabaseType databaseType, int length, int scale) |
Method Summary | |
---|---|
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 function. |
java.lang.String |
getCallHeader(org.eclipse.persistence.internal.databaseaccess.DatabasePlatform platform) INTERNAL: Return call header for the call string. |
int |
getFirstParameterIndexForCallString() INTERNAL: Return the first index of parameter to be placed inside brackets in the call string. |
boolean |
isStoredFunctionCall() INTERNAL: |
void |
prepareInternal(org.eclipse.persistence.internal.sessions.AbstractSession session) INTERNAL: |
void |
setResult(org.eclipse.persistence.internal.helper.DatabaseType databaseType) PUBLIC: Define the return type of the function. |
void |
setResult(org.eclipse.persistence.internal.helper.DatabaseType databaseType, int length) PUBLIC: Define the return type of the function. |
void |
setResult(org.eclipse.persistence.internal.helper.DatabaseType databaseType, int length, int scale) PUBLIC: Define the return type of the function. |
Methods inherited from class org.eclipse.persistence.queries.StoredProcedureCall |
---|
addNamedArgument, addNamedArgument, addNamedArgument, addNamedArgument, addNamedCursorOutputArgument, addOptionalArgument, addUnnamedCursorOutputArgument, getOptionalArguments, getProcedureArgumentNames, getProcedureName, hasOptionalArguments, isStoredProcedureCall, setHasMultipleResultSets, setOptionalArguments, setProcedureArgumentNames, setProcedureName, setReturnsResultSet, 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, 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, setContexts, setFields, setFirstResult, setHasOptimisticLock, setIgnoreFirstRowSetting, setIgnoreMaxResultsSetting, setIsCallableStatementRequired, setIsCursorOutputProcedure, setIsFieldMatchingRequired, setIsResultSetScrollable, setMaxRows, setQueryString, setQueryTimeout, setResult, setResultSetConcurrency, setResultSetFetchSize, setResultSetType, 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, returnCursor, returnManyRows, returnNothing, returnOneRow, setIsNativeConnectionRequired, setIsPrepared, setParameters, setParameterTypes, setParameterTypes, setQuery, setReturnType, translateCustomQuery, translatePureSQLCustomQuery, translateQueryString, whitespace |
Methods inherited from class java.lang.Object |
---|
equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait |
Constructor Detail |
---|
public PLSQLStoredFunctionCall()
public PLSQLStoredFunctionCall(org.eclipse.persistence.internal.helper.DatabaseType databaseType)
public PLSQLStoredFunctionCall(org.eclipse.persistence.internal.helper.DatabaseType databaseType, int length)
public PLSQLStoredFunctionCall(org.eclipse.persistence.internal.helper.DatabaseType databaseType, int length, int scale)
Method Detail |
---|
public java.lang.String getCallHeader(org.eclipse.persistence.internal.databaseaccess.DatabasePlatform platform)
getCallHeader
in class StoredProcedureCall
public int getFirstParameterIndexForCallString()
getFirstParameterIndexForCallString
in class StoredProcedureCall
public boolean isStoredFunctionCall()
isStoredFunctionCall
in class org.eclipse.persistence.internal.databaseaccess.DatasourceCall
public void prepareInternal(org.eclipse.persistence.internal.sessions.AbstractSession session)
prepareInternal
in class PLSQLStoredProcedureCall
public void setResult(org.eclipse.persistence.internal.helper.DatabaseType databaseType)
public void setResult(org.eclipse.persistence.internal.helper.DatabaseType databaseType, int length)
public void setResult(org.eclipse.persistence.internal.helper.DatabaseType databaseType, int length, int scale)
protected void buildProcedureInvocation(java.lang.StringBuilder sb, java.util.List<PLSQLargument> arguments)
buildProcedureInvocation
in class PLSQLStoredProcedureCall
|
|
||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |