Skip navigation links
oracle.toplink.platform.database.oracle
Class PLSQLStoredProcedureCall
java.lang.Object
oracle.toplink.internal.databaseaccess.DatasourceCall
oracle.toplink.internal.databaseaccess.DatabaseCall
oracle.toplink.queryframework.StoredProcedureCall
oracle.toplink.platform.database.oracle.PLSQLStoredProcedureCall
- All Implemented Interfaces:
- java.io.Serializable, java.lang.Cloneable, Call
-
public class PLSQLStoredProcedureCall
- extends StoredProcedureCall
Purpose: Generates an Anonymous PL/SQL block to invoke the specified Stored Procedure with arguments that may or may not have JDBC equivalents
- See Also:
- Serialized Form
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 java.lang.Object |
equals, getClass, hashCode, notify, notifyAll, wait, wait, wait |
BEGIN_DECLARE_BLOCK
public static final java.lang.String BEGIN_DECLARE_BLOCK
-
- See Also:
- Constant Field Values
BEGIN_BEGIN_BLOCK
public static final java.lang.String BEGIN_BEGIN_BLOCK
-
- See Also:
- Constant Field Values
END_BEGIN_BLOCK
public static final java.lang.String END_BEGIN_BLOCK
-
- See Also:
- Constant Field Values
PLSQLStoredProcedureCall
public PLSQLStoredProcedureCall()
addNamedArgument
public void addNamedArgument(java.lang.String procedureParameterName,
oracle.toplink.internal.helper.DatabaseType databaseType)
- Add a named IN argument to the stored procedure. The databaseType parameter classifies the parameter (JDBCType vs. OraclePLSQLType, simple vs. complex)
addNamedArgument
public void addNamedArgument(java.lang.String procedureParameterName,
oracle.toplink.internal.helper.DatabaseType databaseType,
int length)
- Add a named IN argument to the stored procedure. The databaseType parameter classifies the parameter (JDBCType vs. OraclePLSQLType, simple vs. complex). The extra length parameter indicates that this parameter, when used in an Anonymous PL/SQL block, requires a length.
addNamedArgument
public void addNamedArgument(java.lang.String procedureParameterName,
oracle.toplink.internal.helper.DatabaseType databaseType,
int precision,
int scale)
- Add a named IN argument to the stored procedure. The databaseType parameter classifies the parameter (JDBCType vs. OraclePLSQLType, simple vs. complex). The extra scale and precision parameters indicates that this parameter, when used in an Anonymous PL/SQL block, requires scale and precision specification
addNamedArgument
public void addNamedArgument(java.lang.String procedureParameterName,
java.lang.String argumentFieldName,
int type)
- Description copied from class: oracle.toplink.queryframework.StoredProcedureCall
- Define the input argument to the stored procedure and the field/argument name to be substitute for it. The procedureParameterName is the name of the procedure argument expected. The argumentFieldName is the field or argument name to be used to pass to the user. If these names are the same (as they normally are) this method can be called with a single argument. The type is the JDBC type code, this is dependent on the type required by the procedure.
-
- Overrides:
addNamedArgument
in class StoredProcedureCall
addNamedArgument
public void addNamedArgument(java.lang.String procedureParameterName,
java.lang.String argumentFieldName,
int type,
java.lang.String typeName)
- Description copied from class: oracle.toplink.queryframework.StoredProcedureCall
- Define the output argument to the stored procedure and the field/argument name to be substitute for it. The procedureParameterName is the name of the procedure argument expected. The argumentFieldName is the field or argument name to be used to pass to the procedure. If these names are the same (as they normally are) this method can be called with a single argument. The type is the JDBC type code, this is dependent on the type required by the procedure. The typeName is the JDBC type name, this may be required for ARRAY or STRUCT types.
-
- Overrides:
addNamedArgument
in class StoredProcedureCall
addNamedInOutputArgument
public void addNamedInOutputArgument(java.lang.String procedureParameterName,
oracle.toplink.internal.helper.DatabaseType databaseType)
- Add a named IN OUT argument to the stored procedure. The databaseType parameter classifies the parameter (JDBCType vs. OraclePLSQLType, simple vs. complex)
addNamedInOutputArgument
public void addNamedInOutputArgument(java.lang.String procedureParameterName,
oracle.toplink.internal.helper.DatabaseType databaseType,
int length)
- Add a named IN OUT argument to the stored procedure. The databaseType parameter classifies the parameter (JDBCType vs. OraclePLSQLType, simple vs. complex). The extra length parameter indicates that this parameter, when used in an Anonymous PL/SQL block, requires a length.
addNamedInOutputArgument
public void addNamedInOutputArgument(java.lang.String procedureParameterName,
oracle.toplink.internal.helper.DatabaseType databaseType,
int precision,
int scale)
- Add a named IN OUT argument to the stored procedure. The databaseType parameter classifies the parameter (JDBCType vs. OraclePLSQLType, simple vs. complex). The extra scale and precision parameters indicates that this parameter, when used in an Anonymous PL/SQL block, requires scale and precision specification
addNamedInOutputArgument
public void addNamedInOutputArgument(java.lang.String procedureParameterName,
java.lang.String inArgumentFieldName,
java.lang.String outArgumentFieldName,
int type)
- Description copied from class: oracle.toplink.queryframework.StoredProcedureCall
- Define the inoutput argument to the stored procedure and the field/argument name to be substitute for it on the way in and out. The procedureParameterName is the name of the procedure argument expected. The inArgumentFieldName is the field or argument name to be used to pass to the procedure. The outArgumentFieldName is the field or argument name to be used is the result of the output row. If these names are the same (as they normally are) this method can be called with a single argument. The type is the JDBC type code, this dependent on the type returned from the procedure.
-
- Overrides:
addNamedInOutputArgument
in class StoredProcedureCall
addNamedInOutputArgument
public void addNamedInOutputArgument(java.lang.String procedureParameterName,
java.lang.String inArgumentFieldName,
java.lang.String outArgumentFieldName,
int type,
java.lang.String typeName)
- Description copied from class: oracle.toplink.queryframework.StoredProcedureCall
- Define the inoutput argument to the stored procedure and the field/argument name to be substitute for it on the way in and out. The procedureParameterName is the name of the procedure argument expected. The inArgumentFieldName is the field or argument name to be used to pass to the procedure. The outArgumentFieldName is the field or argument name to be used is the result of the output row. If these names are the same (as they normally are) this method can be called with a single argument. The type is the JDBC type code, this dependent on the type returned from the procedure. The typeName is the JDBC type name, this may be required for ARRAY or STRUCT types.
-
- Overrides:
addNamedInOutputArgument
in class StoredProcedureCall
addNamedInOutputArgument
public void addNamedInOutputArgument(java.lang.String procedureParameterName,
java.lang.String inArgumentFieldName,
java.lang.String outArgumentFieldName,
int type,
java.lang.String typeName,
java.lang.Class classType)
- Description copied from class: oracle.toplink.queryframework.StoredProcedureCall
- Define the inoutput argument to the stored procedure and the field/argument name to be substitute for it on the way in and out. The procedureParameterName is the name of the procedure argument expected. The inArgumentFieldName is the field or argument name to be used to pass to the procedure. The outArgumentFieldName is the field or argument name to be used is the result of the output row. If these names are the same (as they normally are) this method can be called with a single argument. The type is the JDBC type code, this dependent on the type returned from the procedure. The typeName is the JDBC type name, this may be required for STRUCT and ARRAY types. The classType is the type of Java class desired back from the procedure, this is dependent on the type returned from the procedure.
-
- Overrides:
addNamedInOutputArgument
in class StoredProcedureCall
addNamedInOutputArgument
public void addNamedInOutputArgument(java.lang.String procedureParameterName,
java.lang.String inArgumentFieldName,
java.lang.String outArgumentFieldName,
int type,
java.lang.String typeName,
java.lang.Class javaType,
DatabaseField nestedType)
- Description copied from class: oracle.toplink.queryframework.StoredProcedureCall
- Define the inoutput argument to the stored procedure and the field/argument name to be substitute for it on the way in and out. The procedureParameterName is the name of the procedure argument expected. The inArgumentFieldName is the field or argument name to be used to pass to the procedure. The outArgumentFieldName is the field or argument name to be used is the result of the output row. If these names are the same (as they normally are) this method can be called with a single argument. The type is the JDBC type code, this dependent on the type returned from the procedure. The typeName is the JDBC type name, this may be required for ARRAY types. The javaType is the java class to return instead of the ARRAY and STRUCT types if a conversion is possible. The nestedType is a DatabaseField with type information set to match the VARRAYs object types
-
- Overrides:
addNamedInOutputArgument
in class StoredProcedureCall
addNamedOutputArgument
public void addNamedOutputArgument(java.lang.String procedureParameterName,
oracle.toplink.internal.helper.DatabaseType databaseType)
- Add a named OUT argument to the stored procedure. The databaseType parameter classifies the parameter (JDBCType vs. OraclePLSQLType, simple vs. complex)
addNamedOutputArgument
public void addNamedOutputArgument(java.lang.String procedureParameterName,
oracle.toplink.internal.helper.DatabaseType databaseType,
int length)
- Add a named OUT argument to the stored procedure. The databaseType parameter classifies the parameter (JDBCType vs. OraclePLSQLType, simple vs. complex). The extra length parameter indicates that this parameter, when used in an Anonymous PL/SQL block, requires a length.
addNamedOutputArgument
public void addNamedOutputArgument(java.lang.String procedureParameterName,
oracle.toplink.internal.helper.DatabaseType databaseType,
int precision,
int scale)
- Add a named OUT argument to the stored procedure. The databaseType parameter classifies the parameter (JDBCType vs. OraclePLSQLType, simple vs. complex). The extra scale and precision parameters indicates that this parameter, when used in an Anonymous PL/SQL block, requires scale and precision specification
addNamedOutputArgument
public void addNamedOutputArgument(java.lang.String procedureParameterName,
java.lang.String argumentFieldName,
int jdbcType,
java.lang.String typeName,
java.lang.Class javaType)
- Description copied from class: oracle.toplink.queryframework.StoredProcedureCall
- Define the output argument to the stored procedure and the field/argument name to be substitute for it. The procedureParameterName is the name of the procedure argument expected. The argumentFieldName is the field or argument name to be used is the result of the output row. The jdbcType is the JDBC type code, this dependent on the type returned from the procedure. The typeName is the JDBC type name, this may be required for ARRAY and STRUCT types. The javaType is the java class to return instead of the ARRAY and STRUCT types if a conversion is possible.
-
- Overrides:
addNamedOutputArgument
in class StoredProcedureCall
addNamedOutputArgument
public void addNamedOutputArgument(java.lang.String procedureParameterName,
java.lang.String argumentFieldName,
int jdbcType,
java.lang.String typeName,
java.lang.Class javaType,
DatabaseField nestedType)
- Description copied from class: oracle.toplink.queryframework.StoredProcedureCall
- Define the output argument to the stored procedure and the field/argument name to be substitute for it. The procedureParameterName is the name of the procedure argument expected. The argumentFieldName is the field or argument name to be used is the result of the output row. The jdbcType is the JDBC type code, this dependent on the type returned from the procedure. The typeName is the JDBC type name, this may be required for ARRAY and STRUCT types. The javaType is the java class to return instead of the ARRAY and STRUCT types if a conversion is possible. The nestedType is a DatabaseField with type information set to match the VARRAYs object types
-
- Overrides:
addNamedOutputArgument
in class StoredProcedureCall
addNamedOutputArgument
public void addNamedOutputArgument(java.lang.String procedureParameterName,
java.lang.String argumentFieldName,
int type,
java.lang.String typeName)
- Description copied from class: oracle.toplink.queryframework.StoredProcedureCall
- Define the output argument to the stored procedure and the field/argument name to be substitute for it. The procedureParameterName is the name of the procedure argument expected. The argumentFieldName is the field or argument name to be used to pass to the procedure. If these names are the same (as they normally are) this method can be called with a single argument. The type is the JDBC type code, this is dependent on the type returned from the procedure. The typeName is the JDBC type name, this may be required for ARRAY or STRUCT types.
-
- Overrides:
addNamedOutputArgument
in class StoredProcedureCall
addNamedOutputArgument
public void addNamedOutputArgument(java.lang.String procedureParameterName,
java.lang.String argumentFieldName,
int type)
- Description copied from class: oracle.toplink.queryframework.StoredProcedureCall
- Define the output argument to the stored procedure and the field/argument name to be substitute for it. The procedureParameterName is the name of the procedure argument expected. The argumentFieldName is the field or argument name to be used to pass to the procedure. If these names are the same (as they normally are) this method can be called with a single argument. The type is the JDBC type code, this is dependent on the type returned from the procedure.
-
- Overrides:
addNamedOutputArgument
in class StoredProcedureCall
addNamedArgument
public void addNamedArgument(java.lang.String procedureParameterAndArgumentFieldName)
- Description copied from class: oracle.toplink.queryframework.StoredProcedureCall
- Define the argument to the stored procedure and the field/argument name to be substitute for it. The procedureParameterAndArgumentFieldName is the name of the procedure argument expected, and is the field or argument name to be used to pass to the procedure. These names are assumed to be the same, if not this method can be called with two arguments.
-
- Overrides:
addNamedArgument
in class StoredProcedureCall
addNamedArgumentValue
public void addNamedArgumentValue(java.lang.String procedureParameterName,
java.lang.Object argumentValue)
- Description copied from class: oracle.toplink.queryframework.StoredProcedureCall
- Define the argument to the stored procedure and the value to be substitute for it. The procedureParameterName is the name of the procedure argument expected. The argumentValue is the value of the argument to be used to pass to the procedure.
-
- Overrides:
addNamedArgumentValue
in class StoredProcedureCall
addNamedArgument
public void addNamedArgument(java.lang.String procedureParameterName,
java.lang.String argumentFieldName)
- Description copied from class: oracle.toplink.queryframework.StoredProcedureCall
- Define the argument to the stored procedure and the field/argument name to be substitute for it. The procedureParameterName is the name of the procedure argument expected. The argumentFieldName is the field or argument name to be used to pass to the procedure. If these names are the same (as they normally are) this method can be called with a single argument.
-
- Overrides:
addNamedArgument
in class StoredProcedureCall
addNamedInOutputArgument
public void addNamedInOutputArgument(java.lang.String procedureParameterAndArgumentFieldName)
- Description copied from class: oracle.toplink.queryframework.StoredProcedureCall
- Define the inoutput argument to the stored procedure and the field/argument name to be substitute for it on the way in and out. The procedureParameterAndArgumentFieldName is the name of the procedure argument expected, the field or argument name to be used to pass to the procedure and, the field or argument name to be used is the result of the output row.
-
- Overrides:
addNamedInOutputArgument
in class StoredProcedureCall
addNamedInOutputArgument
public void addNamedInOutputArgument(java.lang.String procedureParameterName,
java.lang.String argumentFieldName)
- Description copied from class: oracle.toplink.queryframework.StoredProcedureCall
- Define the inoutput argument to the stored procedure and the field/argument name to be substitute for it on the way in and out. The procedureParameterName is the name of the procedure argument expected. The argumentFieldName is the field or argument name to be used to pass to the procedure and is the result of the output row.
-
- Overrides:
addNamedInOutputArgument
in class StoredProcedureCall
addNamedInOutputArgument
public void addNamedInOutputArgument(java.lang.String procedureParameterName,
java.lang.String argumentFieldName,
java.lang.Class type)
- Description copied from class: oracle.toplink.queryframework.StoredProcedureCall
- Define the inoutput argument to the stored procedure and the field/argument name to be substitute for it on the way in and out. The procedureParameterName is the name of the procedure argument expected. The argumentFieldName is the field or argument name to be used to pass to the procedure and is the result of the output row. The type is the type of Java class desired back from the procedure, this is dependent on the type returned from the procedure.
-
- Overrides:
addNamedInOutputArgument
in class StoredProcedureCall
addNamedInOutputArgument
public void addNamedInOutputArgument(java.lang.String procedureParameterName,
java.lang.String inArgumentFieldName,
java.lang.String outArgumentFieldName,
java.lang.Class type)
- Description copied from class: oracle.toplink.queryframework.StoredProcedureCall
- Define the inoutput argument to the stored procedure and the field/argument name to be substitute for it on the way in and out. The procedureParameterName is the name of the procedure argument expected. The inArgumentFieldName is the field or argument name to be used to pass to the procedure. The outArgumentFieldName is the field or argument name to be used is the result of the output row. If these names are the same (as they normally are) this method can be called with a single argument. The type the Java class desired back from the procedure, if a struct is returned and the class has an ObjectRelationalDescriptor defined .
-
- Overrides:
addNamedInOutputArgument
in class StoredProcedureCall
addNamedInOutputArgumentValue
public void addNamedInOutputArgumentValue(java.lang.String procedureParameterName,
java.lang.Object inArgumentValue,
java.lang.String outArgumentFieldName,
java.lang.Class type)
- Description copied from class: oracle.toplink.queryframework.StoredProcedureCall
- Define the inoutput argument to the stored procedure and the field/argument name to be substitute for it on the way in and out. The procedureParameterName is the name of the procedure argument expected. The inArgumentValue is the value of the argument to be used to pass to the procedure. The outArgumentFieldName is the field or argument name to be used is the result of the output row. If these names are the same (as they normally are) this method can be called with a single argument. The type is the type of Java class desired back from the procedure, this is dependent on the type returned from the procedure.
-
- Overrides:
addNamedInOutputArgumentValue
in class StoredProcedureCall
addNamedOutputArgument
public void addNamedOutputArgument(java.lang.String procedureParameterAndArgumentFieldName)
- Description copied from class: oracle.toplink.queryframework.StoredProcedureCall
- Define the output argument to the stored procedure and the field/argument name to be substitute for it. The procedureParameterAndArgumentFieldName is the name of the procedure argument expected, and is the field or argument name to be used to pass to the procedure. These names are assumed to be the same, if not this method can be called with two arguments.
-
- Overrides:
addNamedOutputArgument
in class StoredProcedureCall
addNamedOutputArgument
public void addNamedOutputArgument(java.lang.String procedureParameterName,
java.lang.String argumentFieldName)
- Description copied from class: oracle.toplink.queryframework.StoredProcedureCall
- Define the output argument to the stored procedure and the field/argument name to be substitute for it. The procedureParameterName is the name of the procedure argument expected. The argumentFieldName is the field or argument name to be used to pass to the procedure. If these names are the same (as they normally are) this method can be called with a single argument.
-
- Overrides:
addNamedOutputArgument
in class StoredProcedureCall
addNamedOutputArgument
public void addNamedOutputArgument(java.lang.String procedureParameterName,
java.lang.String argumentFieldName,
java.lang.Class type)
- Description copied from class: oracle.toplink.queryframework.StoredProcedureCall
- Define the output argument to the stored procedure and the field/argument name to be substitute for it. The procedureParameterName is the name of the procedure argument expected. The argumentFieldName is the field or argument name to be used to pass to the procedure. If these names are the same (as they normally are) this method can be called with a single argument. The type is the type of Java class desired back from the procedure, this is dependent on the type returned from the procedure.
-
- Overrides:
addNamedOutputArgument
in class StoredProcedureCall
useNamedCursorOutputAsResultSet
public void useNamedCursorOutputAsResultSet(java.lang.String argumentName)
- Description copied from class: oracle.toplink.queryframework.StoredProcedureCall
- Used for Oracle result sets through procedures. This can only be used if the arguments are not named but ordered.
-
- Overrides:
useNamedCursorOutputAsResultSet
in class StoredProcedureCall
addUnamedArgument
public void addUnamedArgument(java.lang.String argumentFieldName,
java.lang.Class type)
- Description copied from class: oracle.toplink.queryframework.StoredProcedureCall
- Define the argument to the stored procedure for the index argument. This method is used if the procedure is not named and the order is explict, arguments must be added in the correct order. The argumentFieldName is the field or argument name to be used to pass to the user. The type is the type of Java class for the field, and is dependent on the type required by the procedure. This is used to set the type in case null is passed in.
-
- Overrides:
addUnamedArgument
in class StoredProcedureCall
addUnamedArgument
public void addUnamedArgument(java.lang.String argumentFieldName,
int type,
java.lang.String typeName,
DatabaseField nestedType)
- Description copied from class: oracle.toplink.queryframework.StoredProcedureCall
- Define the argument to the stored procedure for the index argument. This method is used if the procedure is not named and the order is explict, arguments must be added in the correct order. The argumentFieldName is the field or argument name to be used to pass to the procedure. If these names are the same (as they normally are) this method can be called with a single argument. The type is the JDBC type code, this is dependent on the type required by the procedure. The typeName is the JDBC type name, as required for STRUCT and ARRAY types. The nestedType is a DatabaseField with type information set to match the VARRAYs object types
-
- Overrides:
addUnamedArgument
in class StoredProcedureCall
addUnamedArgument
public void addUnamedArgument(java.lang.String argumentFieldName,
int type,
java.lang.String typeName)
- Description copied from class: oracle.toplink.queryframework.StoredProcedureCall
- Define the argument to the stored procedure for the index argument. This method is used if the procedure is not named and the order is explict, arguments must be added in the correct order. The argumentFieldName is the field or argument name to be used to pass to the procedure. If these names are the same (as they normally are) this method can be called with a single argument. The type is the JDBC type code, this is dependent on the type required by the procedure. The typeName is the JDBC type name, this may be required for ARRAY or STRUCT types.
-
- Overrides:
addUnamedArgument
in class StoredProcedureCall
addUnamedArgument
public void addUnamedArgument(java.lang.String argumentFieldName,
int type)
- Description copied from class: oracle.toplink.queryframework.StoredProcedureCall
- Define the argument to the stored procedure for the index argument. This method is used if the procedure is not named and the order is explict, arguments must be added in the correct order. The argumentFieldName is the field or argument name to be used to pass to the user. If these names are the same (as they normally are) this method can be called with a single argument. The type is the JDBC type code, this is dependent on the type required by the procedure.
-
- Overrides:
addUnamedArgument
in class StoredProcedureCall
addUnamedArgument
public void addUnamedArgument(java.lang.String argumentFieldName)
- Description copied from class: oracle.toplink.queryframework.StoredProcedureCall
- Define the field/argument name to be substitute for the index argument. This method is used if the procedure is not named and the order is explict, names must be added in the correct order. The argumentFieldName is the field or argument name to be used to pass to the procedure.
-
- Overrides:
addUnamedArgument
in class StoredProcedureCall
addUnamedArgumentValue
public void addUnamedArgumentValue(java.lang.Object argumentValue)
- Description copied from class: oracle.toplink.queryframework.StoredProcedureCall
- Define the argument to the stored procedure for the index argument. This method is used if the procedure is not named and the order is explict, arguments must be added in the correct order. The argumentValue is the value of the argument to be used to pass to the procedure.
-
- Overrides:
addUnamedArgumentValue
in class StoredProcedureCall
addUnamedInOutputArgument
public void addUnamedInOutputArgument(java.lang.String argumentFieldName,
java.lang.Class type)
- Description copied from class: oracle.toplink.queryframework.StoredProcedureCall
- Define the inoutput argument to the stored procedure for the index argument and the field/argument name to be substitute for it on the way in and out. This method is used if the procedure is not named and the order is explict, arguments must be added in the correct order. The argumentFieldName is the field name of the argument to be used to pass to the procedure and to be used is the result of the output row. The type is the type of Java class desired back from the procedure, this is dependent on the type returned from the procedure.
-
- Overrides:
addUnamedInOutputArgument
in class StoredProcedureCall
addUnamedInOutputArgument
public void addUnamedInOutputArgument(java.lang.String inArgumentFieldName,
java.lang.String outArgumentFieldName,
java.lang.Class type)
- Description copied from class: oracle.toplink.queryframework.StoredProcedureCall
- Define the argument to the stored procedure for the index argument. This method is used if the procedure is not named and the order is explict, arguments must be added in the correct order. The inArgumentFieldName is the field name of the argument to be used to pass to the procedure. The outArgumentFieldName is the field or argument name to be used is the result of the output row. If these names are the same (as they normally are) this method can be called with a single argument. The type is the type of Java class desired back from the procedure, this is dependent on the type returned from the procedure.
-
- Overrides:
addUnamedInOutputArgument
in class StoredProcedureCall
addUnamedInOutputArgument
public void addUnamedInOutputArgument(java.lang.String inArgumentFieldName,
java.lang.String outArgumentFieldName,
int type,
java.lang.String typeName,
java.lang.Class collection,
DatabaseField nestedType)
- Description copied from class: oracle.toplink.queryframework.StoredProcedureCall
- Define the inoutput argument to the stored procedure for the index argument and the field/argument name to be substitute for it on the way in and out. This method is used if the procedure is not named and the order is explict, arguments must be added in the correct order. The argumentFieldName is the field or argument name to be used is the result of the output row. The jdbcType is the JDBC type code, this dependent on the type returned from the procedure. The typeName is the JDBC type name, this may be required for ARRAY and STRUCT types. The javaType is the java class to return instead of the ARRAY and STRUCT types if a conversion is possible. The nestedType is a DatabaseField with type information set to match the VARRAYs object types
-
- Overrides:
addUnamedInOutputArgument
in class StoredProcedureCall
addUnamedInOutputArgument
public void addUnamedInOutputArgument(java.lang.String inArgumentFieldName,
java.lang.String outArgumentFieldName,
int type,
java.lang.String typeName,
java.lang.Class collection)
- Description copied from class: oracle.toplink.queryframework.StoredProcedureCall
- Define the inoutput argument to the stored procedure for the index argument and the field/argument name to be substitute for it on the way in and out. This method is used if the procedure is not named and the order is explict, arguments must be added in the correct order. The inArgumentFieldName is the field or argument name to be used to pass to the procedure. The outArgumentFieldName is the field or argument name to be used is the result of the output row. If these names are the same (as they normally are) this method can be called with a single argument. The type is the JDBC type code, this dependent on the type returned from the procedure. The typeName is the JDBC type name, this may be required for ARRAY types. The collectionClass is the java class to return instead of the ARRAY type.
-
- Overrides:
addUnamedInOutputArgument
in class StoredProcedureCall
addUnamedInOutputArgument
public void addUnamedInOutputArgument(java.lang.String inArgumentFieldName,
java.lang.String outArgumentFieldName,
int type,
java.lang.String typeName)
- Description copied from class: oracle.toplink.queryframework.StoredProcedureCall
- Define the inoutput argument to the stored procedure for the index argument and the field/argument name to be substitute for it on the way in and out. This method is used if the procedure is not named and the order is explict, arguments must be added in the correct order. The inArgumentFieldName is the field name of the argument to be used to pass to the procedure. The outArgumentFieldName is the field or argument name to be used is the result of the output row. If these names are the same (as they normally are) this method can be called with a single argument. The type is the JDBC type code, this is dependent on the type returned from the procedure. The typeName is the JDBC type name, this may be required for ARRAY or STRUCT types.
-
- Overrides:
addUnamedInOutputArgument
in class StoredProcedureCall
addUnamedInOutputArgument
public void addUnamedInOutputArgument(java.lang.String inArgumentFieldName,
java.lang.String outArgumentFieldName,
int type)
- Description copied from class: oracle.toplink.queryframework.StoredProcedureCall
- Define the argument to the stored procedure for the index argument. This method is used if the procedure is not named and the order is explict, arguments must be added in the correct order. The inArgumentFieldName is the field name of the argument to be used to pass to the procedure. The outArgumentFieldName is the field or argument name to be used is the result of the output row. If these names are the same (as they normally are) this method can be called with a single argument. The type is the JDBC type code, this is dependent on the type returned from the procedure.
-
- Overrides:
addUnamedInOutputArgument
in class StoredProcedureCall
addUnamedInOutputArgument
public void addUnamedInOutputArgument(java.lang.String argumentFieldName)
- Description copied from class: oracle.toplink.queryframework.StoredProcedureCall
- Define the inoutput argument to the stored procedure for the index argument and the field/argument name to be substitute for it on the way in and out. This method is used if the procedure is not named and the order is explict, arguments must be added in the correct order. The argumentFieldName is the field name of the argument to be used to pass to the procedure and to be used is the result of the output row.
-
- Overrides:
addUnamedInOutputArgument
in class StoredProcedureCall
addUnamedInOutputArgumentValue
public void addUnamedInOutputArgumentValue(java.lang.Object inArgumentValue,
java.lang.String outArgumentFieldName,
java.lang.Class type)
- Description copied from class: oracle.toplink.queryframework.StoredProcedureCall
- Define the inoutput argument to the stored procedure for the index argument and the field/argument name to be substitute for it on the way in and out. This method is used if the procedure is not named and the order is explict, arguments must be added in the correct order. The inArgumentValue is the value of the argument to be used to pass to the procedure. The outArgumentFieldName is the field or argument name to be used is the result of the output row. If these names are the same (as they normally are) this method can be called with a single argument. The type is the type of Java class desired back from the procedure, this is dependent on the type returned from the procedure.
-
- Overrides:
addUnamedInOutputArgumentValue
in class StoredProcedureCall
addUnamedOutputArgument
public void addUnamedOutputArgument(java.lang.String argumentFieldName,
java.lang.Class type)
- Description copied from class: oracle.toplink.queryframework.StoredProcedureCall
- Define the field/argument name to be substitute for the index output argument. This method is used if the procedure is not named and the order is explict, names must be added in the correct order. The argumentFieldName is the field or argument name to be used to pass to the procedure. The type is the type of Java class desired back from the procedure, this is dependent on the type returned from the procedure.
-
- Overrides:
addUnamedOutputArgument
in class StoredProcedureCall
addUnamedOutputArgument
public void addUnamedOutputArgument(java.lang.String argumentFieldName,
int jdbcType,
java.lang.String typeName,
java.lang.Class javaType,
DatabaseField nestedType)
- Description copied from class: oracle.toplink.queryframework.StoredProcedureCall
- Define the field/argument name to be substitute for the index output argument. This method is used if the procedure is not named and the order is explict, names must be added in the correct order. The argumentFieldName is the field or argument name to be used is the result of the output row. The jdbcType is the JDBC type code, this dependent on the type returned from the procedure. The typeName is the JDBC type name, this may be required for ARRAY and STRUCT types. The javaType is the java class to return instead of the ARRAY and STRUCT types if a conversion is possible. The nestedType is a DatabaseField with type information set to match the VARRAYs object types
-
- Overrides:
addUnamedOutputArgument
in class StoredProcedureCall
addUnamedOutputArgument
public void addUnamedOutputArgument(java.lang.String argumentFieldName,
int jdbcType,
java.lang.String typeName,
java.lang.Class javaType)
- Description copied from class: oracle.toplink.queryframework.StoredProcedureCall
- Define the field/argument name to be substitute for the index output argument. This method is used if the procedure is not named and the order is explict, names must be added in the correct order. The argumentFieldName is the field or argument name to be used is the result of the output row. The jdbcType is the JDBC type code, this dependent on the type returned from the procedure. The typeName is the JDBC type name, this may be required for ARRAY and STRUCT types. The javaType is the java class to return instead of the ARRAY and STRUCT types if a conversion is possible.
-
- Overrides:
addUnamedOutputArgument
in class StoredProcedureCall
addUnamedOutputArgument
public void addUnamedOutputArgument(java.lang.String argumentFieldName,
int type,
java.lang.String typeName)
- Description copied from class: oracle.toplink.queryframework.StoredProcedureCall
- Define the field/argument name to be substitute for the index output argument. This method is used if the procedure is not named and the order is explict, names must be added in the correct order. The argumentFieldName is the field or argument name to be used to pass to the procedure. The type is the JDBC type code, this is dependent on the type returned from the procedure. The typeName is the JDBC type name, this may be required for ARRAY or STRUCT types.
-
- Overrides:
addUnamedOutputArgument
in class StoredProcedureCall
addUnamedOutputArgument
public void addUnamedOutputArgument(java.lang.String argumentFieldName,
int type)
- Description copied from class: oracle.toplink.queryframework.StoredProcedureCall
- Define the field/argument name to be substitute for the index output argument. This method is used if the procedure is not named and the order is explict, names must be added in the correct order. The argumentFieldName is the field or argument name to be used to pass to the procedure. The type is the JDBC type code, this is dependent on the type returned from the procedure.
-
- Overrides:
addUnamedOutputArgument
in class StoredProcedureCall
addUnamedOutputArgument
public void addUnamedOutputArgument(java.lang.String argumentFieldName)
- Description copied from class: oracle.toplink.queryframework.StoredProcedureCall
- Define the field/argument name to be substitute for the index output argument. This method is used if the procedure is not named and the order is explict, names must be added in the correct order. The argumentFieldName is the field or argument name to be used to pass to the procedure. The type is the type of Java class desired back from the procedure, this is dependent on the type returned from the procedure.
-
- Overrides:
addUnamedOutputArgument
in class StoredProcedureCall
useUnnamedCursorOutputAsResultSet
public void useUnnamedCursorOutputAsResultSet()
- Description copied from class: oracle.toplink.queryframework.StoredProcedureCall
- Used for Oracle result sets through procedures. This can only be used if the arguments are not named but ordered.
-
- Overrides:
useUnnamedCursorOutputAsResultSet
in class StoredProcedureCall
useNamedCursorOutputAsResultSet
public void useNamedCursorOutputAsResultSet(java.lang.String argumentName,
oracle.toplink.internal.helper.DatabaseType databaseType)
- Add a named OUT cursor argument to the stored procedure. The databaseType parameter classifies the parameter (JDBCType vs. OraclePLSQLType, simple vs. complex).
Skip navigation links