public interface Routine<T> extends NamedQueryPart, SchemaProvider
Callable objects are mainly stored procedures and stored functions. The distinction between those two object types is very subtle and not well defined across various RDBMS. In general, this can be said:
Procedures:
Hence, with #852, jOOQ 1.6.8, the distinction between procedures and functions becomes obsolete. All stored routines are simply referred to as "Routine".
Modifier and Type | Method and Description |
---|---|
int |
execute()
Execute the stored object on an underlying connection
|
int |
execute(Configuration configuration)
Execute the stored object using a
Configuration object |
List<Parameter<?>> |
getInParameters()
A list of IN parameters passed to the stored procedure as argument.
|
String |
getName()
The name of this routine
|
List<Parameter<?>> |
getOutParameters()
A list of OUT parameters passed to the stored procedure as argument.
|
Package |
getPackage()
The container package of this stored procedure or function.
|
List<Parameter<?>> |
getParameters() |
T |
getReturnValue() |
Schema |
getSchema()
Get the routine schema
|
internalAPI
compareTo
Schema getSchema()
getSchema
in interface SchemaProvider
String getName()
getName
in interface NamedQueryPart
Package getPackage()
This is only supported in the SQLDialect.ORACLE
dialect.
null
if
there is no such container.List<Parameter<?>> getOutParameters()
getParameters()
.getParameters()
List<Parameter<?>> getInParameters()
getParameters()
.getParameters()
T getReturnValue()
List<Parameter<?>> getParameters()
int execute(Configuration configuration) throws DataAccessException
Configuration
objectDataAccessException
- if something went wrong executing the queryint execute() throws DataAccessException
DataAccessException
- if something went wrong executing the queryCopyright © 2013. All Rights Reserved.