|
Oracle Fusion Middleware Java API Reference for Oracle TopLink (Deprecated) 11g Release 1 (11.1.1) B32476-04 |
||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Object oracle.toplink.internal.databaseaccess.DatasourceCall oracle.toplink.internal.databaseaccess.DatabaseCall oracle.toplink.queryframework.StoredProcedureCall oracle.toplink.platform.database.oracle.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
Field Summary | |
---|---|
static java.lang.String |
BEGIN_BEGIN_BLOCK
|
static java.lang.String |
BEGIN_DECLARE_BLOCK
|
static java.lang.String |
END_BEGIN_BLOCK
|
Constructor Summary | |
---|---|
PLSQLStoredProcedureCall()
|
Method Summary | |
---|---|
void |
addNamedArgument(java.lang.String procedureParameterAndArgumentFieldName)
Define the argument to the stored procedure and the field/argument name to be substitute for it. |
void |
addNamedArgument(java.lang.String procedureParameterName,
oracle.toplink.internal.helper.DatabaseType databaseType)
Add a named IN argument to the stored procedure. |
void |
addNamedArgument(java.lang.String procedureParameterName,
oracle.toplink.internal.helper.DatabaseType databaseType,
int length)
Add a named IN argument to the stored procedure. |
void |
addNamedArgument(java.lang.String procedureParameterName,
oracle.toplink.internal.helper.DatabaseType databaseType,
int precision,
int scale)
Add a named IN argument to the stored procedure. |
void |
addNamedArgument(java.lang.String procedureParameterName,
java.lang.String argumentFieldName)
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)
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)
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)
Define the argument to the stored procedure and the value to be substitute for it. |
void |
addNamedInOutputArgument(java.lang.String procedureParameterAndArgumentFieldName)
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,
oracle.toplink.internal.helper.DatabaseType databaseType)
Add a named IN OUT argument to the stored procedure. |
void |
addNamedInOutputArgument(java.lang.String procedureParameterName,
oracle.toplink.internal.helper.DatabaseType databaseType,
int length)
Add a named IN OUT argument to the stored procedure. |
void |
addNamedInOutputArgument(java.lang.String procedureParameterName,
oracle.toplink.internal.helper.DatabaseType databaseType,
int precision,
int scale)
Add a named IN OUT argument to the stored procedure. |
void |
addNamedInOutputArgument(java.lang.String procedureParameterName,
java.lang.String argumentFieldName)
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)
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)
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)
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)
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)
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,
DatabaseField nestedType)
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)
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)
Define the output argument to the stored procedure and the field/argument name to be substitute for it. |
void |
addNamedOutputArgument(java.lang.String procedureParameterName,
oracle.toplink.internal.helper.DatabaseType databaseType)
Add a named OUT argument to the stored procedure. |
void |
addNamedOutputArgument(java.lang.String procedureParameterName,
oracle.toplink.internal.helper.DatabaseType databaseType,
int length)
Add a named OUT argument to the stored procedure. |
void |
addNamedOutputArgument(java.lang.String procedureParameterName,
oracle.toplink.internal.helper.DatabaseType databaseType,
int precision,
int scale)
Add a named OUT argument to the stored procedure. |
void |
addNamedOutputArgument(java.lang.String procedureParameterName,
java.lang.String argumentFieldName)
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)
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)
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)
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)
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,
DatabaseField nestedType)
Define the output argument to the stored procedure and the field/argument name to be substitute for it. |
void |
addUnamedArgument(java.lang.String argumentFieldName)
Define the field/argument name to be substitute for the index argument. |
void |
addUnamedArgument(java.lang.String argumentFieldName,
java.lang.Class type)
Define the argument to the stored procedure for the index argument. |
void |
addUnamedArgument(java.lang.String argumentFieldName,
int type)
Define the argument to the stored procedure for the index argument. |
void |
addUnamedArgument(java.lang.String argumentFieldName,
int type,
java.lang.String typeName)
Define the argument to the stored procedure for the index argument. |
void |
addUnamedArgument(java.lang.String argumentFieldName,
int type,
java.lang.String typeName,
DatabaseField nestedType)
Define the argument to the stored procedure for the index argument. |
void |
addUnamedArgumentValue(java.lang.Object argumentValue)
Define the argument to the stored procedure for the index argument. |
void |
addUnamedInOutputArgument(java.lang.String argumentFieldName)
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)
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)
Define the argument to the stored procedure for the index argument. |
void |
addUnamedInOutputArgument(java.lang.String inArgumentFieldName,
java.lang.String outArgumentFieldName,
int type)
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)
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)
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,
DatabaseField nestedType)
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)
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)
Define the field/argument name to be substitute for the index output argument. |
void |
addUnamedOutputArgument(java.lang.String argumentFieldName,
java.lang.Class type)
Define the field/argument name to be substitute for the index output argument. |
void |
addUnamedOutputArgument(java.lang.String argumentFieldName,
int type)
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)
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)
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,
DatabaseField nestedType)
Define the field/argument name to be substitute for the index output argument. |
void |
useNamedCursorOutputAsResultSet(java.lang.String argumentName)
Used for Oracle result sets through procedures. |
void |
useNamedCursorOutputAsResultSet(java.lang.String argumentName,
oracle.toplink.internal.helper.DatabaseType databaseType)
Add a named OUT cursor argument to the stored procedure. |
void |
useUnnamedCursorOutputAsResultSet()
Used for Oracle result sets through procedures. |
Methods inherited from class oracle.toplink.queryframework.StoredProcedureCall |
---|
addNamedArgument, addNamedArgument, getProcedureName, isStoredProcedureCall, setProcedureName, toString |
Methods inherited from class java.lang.Object |
---|
equals, getClass, hashCode, notify, notifyAll, wait, wait, wait |
Field Detail |
---|
public static final java.lang.String BEGIN_DECLARE_BLOCK
public static final java.lang.String BEGIN_BEGIN_BLOCK
public static final java.lang.String END_BEGIN_BLOCK
Constructor Detail |
---|
public PLSQLStoredProcedureCall()
Method Detail |
---|
public void addNamedArgument(java.lang.String procedureParameterName, oracle.toplink.internal.helper.DatabaseType databaseType)
public void addNamedArgument(java.lang.String procedureParameterName, oracle.toplink.internal.helper.DatabaseType databaseType, int length)
public void addNamedArgument(java.lang.String procedureParameterName, oracle.toplink.internal.helper.DatabaseType databaseType, int precision, int scale)
public void addNamedArgument(java.lang.String procedureParameterName, java.lang.String argumentFieldName, int type)
addNamedArgument
in class StoredProcedureCall
public void addNamedArgument(java.lang.String procedureParameterName, java.lang.String argumentFieldName, int type, java.lang.String typeName)
addNamedArgument
in class StoredProcedureCall
public void addNamedInOutputArgument(java.lang.String procedureParameterName, oracle.toplink.internal.helper.DatabaseType databaseType)
public void addNamedInOutputArgument(java.lang.String procedureParameterName, oracle.toplink.internal.helper.DatabaseType databaseType, int length)
public void addNamedInOutputArgument(java.lang.String procedureParameterName, oracle.toplink.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)
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)
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)
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, DatabaseField nestedType)
addNamedInOutputArgument
in class StoredProcedureCall
public void addNamedOutputArgument(java.lang.String procedureParameterName, oracle.toplink.internal.helper.DatabaseType databaseType)
public void addNamedOutputArgument(java.lang.String procedureParameterName, oracle.toplink.internal.helper.DatabaseType databaseType, int length)
public void addNamedOutputArgument(java.lang.String procedureParameterName, oracle.toplink.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)
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, DatabaseField nestedType)
addNamedOutputArgument
in class StoredProcedureCall
public void addNamedOutputArgument(java.lang.String procedureParameterName, java.lang.String argumentFieldName, int type, java.lang.String typeName)
addNamedOutputArgument
in class StoredProcedureCall
public void addNamedOutputArgument(java.lang.String procedureParameterName, java.lang.String argumentFieldName, int type)
addNamedOutputArgument
in class StoredProcedureCall
public void addNamedArgument(java.lang.String procedureParameterAndArgumentFieldName)
addNamedArgument
in class StoredProcedureCall
public void addNamedArgumentValue(java.lang.String procedureParameterName, java.lang.Object argumentValue)
addNamedArgumentValue
in class StoredProcedureCall
public void addNamedArgument(java.lang.String procedureParameterName, java.lang.String argumentFieldName)
addNamedArgument
in class StoredProcedureCall
public void addNamedInOutputArgument(java.lang.String procedureParameterAndArgumentFieldName)
addNamedInOutputArgument
in class StoredProcedureCall
public void addNamedInOutputArgument(java.lang.String procedureParameterName, java.lang.String argumentFieldName)
addNamedInOutputArgument
in class StoredProcedureCall
public void addNamedInOutputArgument(java.lang.String procedureParameterName, java.lang.String argumentFieldName, java.lang.Class type)
addNamedInOutputArgument
in class StoredProcedureCall
public void addNamedInOutputArgument(java.lang.String procedureParameterName, java.lang.String inArgumentFieldName, java.lang.String outArgumentFieldName, java.lang.Class type)
addNamedInOutputArgument
in class StoredProcedureCall
public void addNamedInOutputArgumentValue(java.lang.String procedureParameterName, java.lang.Object inArgumentValue, java.lang.String outArgumentFieldName, java.lang.Class type)
addNamedInOutputArgumentValue
in class StoredProcedureCall
public void addNamedOutputArgument(java.lang.String procedureParameterAndArgumentFieldName)
addNamedOutputArgument
in class StoredProcedureCall
public void addNamedOutputArgument(java.lang.String procedureParameterName, java.lang.String argumentFieldName)
addNamedOutputArgument
in class StoredProcedureCall
public void addNamedOutputArgument(java.lang.String procedureParameterName, java.lang.String argumentFieldName, java.lang.Class type)
addNamedOutputArgument
in class StoredProcedureCall
public void useNamedCursorOutputAsResultSet(java.lang.String argumentName)
useNamedCursorOutputAsResultSet
in class StoredProcedureCall
public void addUnamedArgument(java.lang.String argumentFieldName, java.lang.Class type)
addUnamedArgument
in class StoredProcedureCall
public void addUnamedArgument(java.lang.String argumentFieldName, int type, java.lang.String typeName, DatabaseField nestedType)
addUnamedArgument
in class StoredProcedureCall
public void addUnamedArgument(java.lang.String argumentFieldName, int type, java.lang.String typeName)
addUnamedArgument
in class StoredProcedureCall
public void addUnamedArgument(java.lang.String argumentFieldName, int type)
addUnamedArgument
in class StoredProcedureCall
public void addUnamedArgument(java.lang.String argumentFieldName)
addUnamedArgument
in class StoredProcedureCall
public void addUnamedArgumentValue(java.lang.Object argumentValue)
addUnamedArgumentValue
in class StoredProcedureCall
public void addUnamedInOutputArgument(java.lang.String argumentFieldName, java.lang.Class type)
addUnamedInOutputArgument
in class StoredProcedureCall
public void addUnamedInOutputArgument(java.lang.String inArgumentFieldName, java.lang.String outArgumentFieldName, java.lang.Class type)
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, DatabaseField nestedType)
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)
addUnamedInOutputArgument
in class StoredProcedureCall
public void addUnamedInOutputArgument(java.lang.String inArgumentFieldName, java.lang.String outArgumentFieldName, int type, java.lang.String typeName)
addUnamedInOutputArgument
in class StoredProcedureCall
public void addUnamedInOutputArgument(java.lang.String inArgumentFieldName, java.lang.String outArgumentFieldName, int type)
addUnamedInOutputArgument
in class StoredProcedureCall
public void addUnamedInOutputArgument(java.lang.String argumentFieldName)
addUnamedInOutputArgument
in class StoredProcedureCall
public void addUnamedInOutputArgumentValue(java.lang.Object inArgumentValue, java.lang.String outArgumentFieldName, java.lang.Class type)
addUnamedInOutputArgumentValue
in class StoredProcedureCall
public void addUnamedOutputArgument(java.lang.String argumentFieldName, java.lang.Class type)
addUnamedOutputArgument
in class StoredProcedureCall
public void addUnamedOutputArgument(java.lang.String argumentFieldName, int jdbcType, java.lang.String typeName, java.lang.Class javaType, DatabaseField nestedType)
addUnamedOutputArgument
in class StoredProcedureCall
public void addUnamedOutputArgument(java.lang.String argumentFieldName, int jdbcType, java.lang.String typeName, java.lang.Class javaType)
addUnamedOutputArgument
in class StoredProcedureCall
public void addUnamedOutputArgument(java.lang.String argumentFieldName, int type, java.lang.String typeName)
addUnamedOutputArgument
in class StoredProcedureCall
public void addUnamedOutputArgument(java.lang.String argumentFieldName, int type)
addUnamedOutputArgument
in class StoredProcedureCall
public void addUnamedOutputArgument(java.lang.String argumentFieldName)
addUnamedOutputArgument
in class StoredProcedureCall
public void useUnnamedCursorOutputAsResultSet()
useUnnamedCursorOutputAsResultSet
in class StoredProcedureCall
public void useNamedCursorOutputAsResultSet(java.lang.String argumentName, oracle.toplink.internal.helper.DatabaseType databaseType)
|
|
||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |