java.lang.Object
- org.jooq.impl.AbstractRoutine<T>

All Implemented Interfaces:

Serializable, Attachable, Named, QueryPart, QueryPartInternal, Routine<T>
```
@Internal
public abstract class AbstractRoutine<T>
extends Object
implements Routine<T>
```
A common base class for stored procedures
This type is for JOOQ INTERNAL USE only. Do not reference directly

Author:

Lukas Eder

See Also:

Serialized Form

Constructor Summary

Constructors
Modifier	Constructor	Description
`protected`	`AbstractRoutine(String name, Schema schema)`
`protected`	`AbstractRoutine(String name, Schema schema, DataType<T> type)`
`protected`	`AbstractRoutine(String name, Schema schema, DataType<X> type, Binding<X,T> binding)`
`protected`	`AbstractRoutine(String name, Schema schema, DataType<X> type, Converter<X,T> converter)`
`protected`	`AbstractRoutine(String name, Schema schema, DataType<X> type, Converter<Y,T> converter, Binding<X,Y> binding)`
`protected`	`AbstractRoutine(String name, Schema schema, Package pkg)`
`protected`	`AbstractRoutine(String name, Schema schema, Package pkg, DataType<T> type)`
`protected`	`AbstractRoutine(String name, Schema schema, Package pkg, DataType<X> type, Binding<X,T> binding)`
`protected`	`AbstractRoutine(String name, Schema schema, Package pkg, DataType<X> type, Converter<X,T> converter)`
`protected`	`AbstractRoutine(String name, Schema schema, Package pkg, DataType<X> type, Converter<Y,T> converter, Binding<X,Y> binding)`

Method Summary

All Methods Static Methods Instance Methods Concrete Methods Deprecated Methods
Modifier and Type	Method	Description
`void`	`accept(Context<?> ctx)`	This `QueryPart` can `accept` a `Context` object in order to render a SQL string or to bind its variables.
`protected void`	`addInOutParameter(Parameter<?> parameter)`
`protected void`	`addInParameter(Parameter<?> parameter)`
`protected void`	`addOutParameter(Parameter<?> parameter)`
`AggregateFunction<T>`	`asAggregateFunction()`
`Field<T>`	`asField()`
`Field<T>`	`asField(String alias)`
`void`	`attach(Configuration c)`	Attach this object to a new `Configuration`.
`void`	`bind(BindContext context)`	Deprecated. - 3.4.0 - [#2694] - Use `QueryPartInternal.accept(Context)` instead.
`Clause[]`	`clauses(Context<?> ctx)`	The `Clause`s that are represented by this query part.
`Configuration`	`configuration()`	Get the currently attached `Configuration`, or `null` if no `Configuration` is attached.
`protected DSLContext`	`create()`	Deprecated. - 3.11.0 - [#6722] - Use `Attachable.configuration()` and `Configuration.dsl()` instead.
`protected DSLContext`	`create(Configuration configuration)`	Deprecated. - 3.11.0 - [#6722] - Use `Attachable.configuration()` and `Configuration.dsl()` instead.
`protected DSLContext`	`create(Context<?> ctx)`	Deprecated. - 3.11.0 - [#6722] - Use `Attachable.configuration()` and `Configuration.dsl()` instead.
`protected static <T> Parameter<T>`	`createParameter(String name, DataType<T> type)`	Deprecated. - Please, re-generate your routine code.
`protected static <T> Parameter<T>`	`createParameter(String name, DataType<T> type, boolean isDefaulted)`	Deprecated. - Please, re-generate your routine code.
`protected static <T> Parameter<T>`	`createParameter(String name, DataType<T> type, boolean isDefaulted, boolean isUnnamed)`	Deprecated. - Please, re-generate your routine code.
`protected static <T,U> Parameter<U>`	`createParameter(String name, DataType<T> type, boolean isDefaulted, boolean isUnnamed, Binding<T,U> binding)`	Deprecated. - Please, re-generate your routine code.
`protected static <T,U> Parameter<U>`	`createParameter(String name, DataType<T> type, boolean isDefaulted, boolean isUnnamed, Converter<T,U> converter)`	Deprecated. - Please, re-generate your routine code.
`protected static <T,X,U> Parameter<U>`	`createParameter(String name, DataType<T> type, boolean isDefaulted, boolean isUnnamed, Converter<X,U> converter, Binding<T,X> binding)`	Deprecated. - Please, re-generate your routine code.
`protected static <T,U> Parameter<U>`	`createParameter(String name, DataType<T> type, boolean isDefaulted, Binding<T,U> binding)`	Deprecated. - Please, re-generate your routine code.
`protected static <T,U> Parameter<U>`	`createParameter(String name, DataType<T> type, boolean isDefaulted, Converter<T,U> converter)`	Deprecated. - Please, re-generate your routine code.
`protected static <T,X,U> Parameter<U>`	`createParameter(String name, DataType<T> type, boolean isDefaulted, Converter<X,U> converter, Binding<T,X> binding)`	Deprecated. - Please, re-generate your routine code.
`boolean`	`declaresCTE()`	Subclasses may override this
`boolean`	`declaresFields()`	Subclasses may override this
`boolean`	`declaresTables()`	Subclasses may override this
`boolean`	`declaresWindows()`	Subclasses may override this
`void`	`detach()`	Detach this object from its current `Configuration`.
`boolean`	`equals(Object that)`	Check whether this `QueryPart` can be considered equal to another `QueryPart`.
`int`	`execute()`	Execute the stored object on an underlying connection
`int`	`execute(Configuration c)`	Execute the stored object using a `Configuration` object
`boolean`	`generatesCast()`	Subclasses may override this
`<Z> Z`	`get(Parameter<Z> parameter)`
`Catalog`	`getCatalog()`	Get the routine catalog.
`String`	`getComment()`	The comment on this object.
`List<Parameter<?>>`	`getInParameters()`	A list of IN parameters passed to the stored procedure as argument.
`protected Map<Parameter<?>,Field<?>>`	`getInValues()`
`String`	`getName()`	The unqualified name of this object.
`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()`
`Name`	`getQualifiedName()`	The qualified name of this object.
`Results`	`getResults()`
`Parameter<T>`	`getReturnParameter()`	The parameter representing this routine's `Routine.getReturnValue()`
`T`	`getReturnValue()`
`Schema`	`getSchema()`	Get the routine schema
`Name`	`getUnqualifiedName()`	The unqualified name of this object.
`<Z> Z`	`getValue(Parameter<Z> parameter)`
`int`	`hashCode()`	Generate a hash code from this `QueryPart`.
`protected boolean`	`isOverloaded()`
`protected boolean`	`isPipelined()`
`<Z> void`	`set(Parameter<Z> parameter, Z value)`	Set the routine's IN value for an IN parameter.
`protected void`	`setField(Parameter<?> parameter, Field<?> value)`
`protected void`	`setNumber(Parameter<? extends Number> parameter, Field<? extends Number> value)`
`protected <N extends Number> void`	`setNumber(Parameter<N> parameter, Number value)`
`protected void`	`setOverloaded(boolean overloaded)`
`protected void`	`setPipelined(boolean pipelined)`
`protected void`	`setPLSQLBooleanParameter(Parameter<?> parameter)`
`protected void`	`setReturnParameter(Parameter<T> parameter)`
`<Z> void`	`setValue(Parameter<Z> parameter, Z value)`	Set the routine's IN value for an IN parameter.
`void`	`toSQL(RenderContext context)`	Deprecated. - 3.4.0 - [#2694] - Use `QueryPartInternal.accept(Context)` instead.
`String`	`toString()`	Render a SQL string representation of this `QueryPart`.
`protected DataAccessException`	`translate(String sql, SQLException e)`	Internal convenience method

Methods inherited from class java.lang.Object
clone, finalize, getClass, notify, notifyAll, wait, wait, wait

Methods inherited from interface org.jooq.Named
getComment, getName, getQualifiedName, getUnqualifiedName

Methods inherited from interface org.jooq.QueryPart
equals, hashCode, toString

- Constructor Detail
 - AbstractRoutine
```
protected AbstractRoutine(String name,
 Schema schema)
```
 - AbstractRoutine
```
protected AbstractRoutine(String name,
 Schema schema,
 Package pkg)
```
 - AbstractRoutine
```
protected AbstractRoutine(String name,
 Schema schema,
 DataType<T> type)
```
 - AbstractRoutine
```
protected AbstractRoutine(String name,
 Schema schema,
 DataType<X> type,
 Converter<X,T> converter)
```
 - AbstractRoutine
```
protected AbstractRoutine(String name,
 Schema schema,
 DataType<X> type,
 Binding<X,T> binding)
```
 - AbstractRoutine
```
protected AbstractRoutine(String name,
 Schema schema,
 DataType<X> type,
 Converter<Y,T> converter,
 Binding<X,Y> binding)
```
 - AbstractRoutine
```
protected AbstractRoutine(String name,
 Schema schema,
 Package pkg,
 DataType<T> type)
```
 - AbstractRoutine
```
protected AbstractRoutine(String name,
 Schema schema,
 Package pkg,
 DataType<X> type,
 Converter<X,T> converter)
```
 - AbstractRoutine
```
protected AbstractRoutine(String name,
 Schema schema,
 Package pkg,
 DataType<X> type,
 Binding<X,T> binding)
```
 - AbstractRoutine
```
protected AbstractRoutine(String name,
 Schema schema,
 Package pkg,
 DataType<X> type,
 Converter<Y,T> converter,
 Binding<X,Y> binding)
```
- Method Detail
 - setNumber
```
protected final <N extends Number> void setNumber(Parameter<N> parameter,
 Number value)
```
 - setNumber
```
protected final void setNumber(Parameter<? extends Number> parameter,
 Field<? extends Number> value)
```
 - setValue
```
public final <Z> void setValue(Parameter<Z> parameter,
 Z value)
```
 Description copied from interface: Routine
 
 Set the routine's IN value for an IN parameter.
 
 Specified by:
 
 setValue in interface Routine<T>
 - set
```
public final <Z> void set(Parameter<Z> parameter,
 Z value)
```
 Description copied from interface: Routine
 
 Set the routine's IN value for an IN parameter.
 
 Specified by:
 
 set in interface Routine<T>
 - setField
```
protected final void setField(Parameter<?> parameter,
 Field<?> value)
```
 - attach
```
public final void attach(Configuration c)
```
 Description copied from interface: Attachable
 
 Attach this object to a new Configuration.
 
 Specified by:
 
 attach in interface Attachable
 
 Parameters:
 
 c - A configuration or null, if you wish to detach this Attachable from its previous configuration.
 - detach
```
public final void detach()
```
 Description copied from interface: Attachable
 
 Detach this object from its current Configuration.
 This is the same as calling attach(null).
 
 Specified by:
 
 detach in interface Attachable
 - configuration
```
public final Configuration configuration()
```
 Description copied from interface: Attachable
 
 Get the currently attached Configuration, or null if no Configuration is attached.
 
 Specified by:
 
 configuration in interface Attachable
 - execute
```
public final int execute(Configuration c)
```
 Description copied from interface: Routine
 
 Execute the stored object using a Configuration object
 
 Specified by:
 
 execute in interface Routine<T>
 - execute
```
public final int execute()
```
 Description copied from interface: Routine
 
 Execute the stored object on an underlying connection
 
 Specified by:
 
 execute in interface Routine<T>
 - clauses
```
public final Clause[] clauses(Context<?> ctx)
```
 Description copied from interface: QueryPartInternal
 
 The Clauses that are represented by this query part.
 QueryParts can specify several Clauses for which an event will be emitted before (in forward order) and after (in reverse order) visiting the the query part through Context.visit(QueryPart)
 This method is for JOOQ INTERNAL USE only. Do not reference directly
 
 Specified by:
 
 clauses in interface QueryPartInternal
 
 Returns:
 
 The Clauses represented by this query part or null or an empty array if this query part does not represent a clause.
 - accept
```
public void accept(Context<?> ctx)
```
 Description copied from interface: QueryPartInternal
 
 This QueryPart can accept a Context object in order to render a SQL string or to bind its variables.
 
 Specified by:
 
 accept in interface QueryPartInternal
 - getReturnValue
```
public final T getReturnValue()
```
 Specified by:
 
 getReturnValue in interface Routine<T>
 
 Returns:
 
 The routine's return value (if it is a function)
 - getResults
```
public final Results getResults()
```
 Specified by:
 
 getResults in interface Routine<T>
 
 Returns:
 
 The routine's results (if available)
 - getValue
```
public final <Z> Z getValue(Parameter<Z> parameter)
```
 Specified by:
 
 getValue in interface Routine<T>
 
 Returns:
 
 The routine's OUT value for an OUT parameter.
 - get
```
public final <Z> Z get(Parameter<Z> parameter)
```
 Specified by:
 
 get in interface Routine<T>
 
 Returns:
 
 The routine's OUT value for an OUT parameter.
 - getInValues
```
protected final Map<Parameter<?>,Field<?>> getInValues()
```
 - getOutParameters
```
public final List<Parameter<?>> getOutParameters()
```
 Description copied from interface: Routine
 
 A list of OUT parameters passed to the stored procedure as argument. This list contains all parameters that are either OUT or INOUT in their respective order of appearance in Routine.getParameters().
 
 Specified by:
 
 getOutParameters in interface Routine<T>
 
 Returns:
 
 The list of out parameters
 
 See Also:
 
 Routine.getParameters()
 - getInParameters
```
public final List<Parameter<?>> getInParameters()
```
 Description copied from interface: Routine
 
 A list of IN parameters passed to the stored procedure as argument. This list contains all parameters that are either IN or INOUT in their respective order of appearance in Routine.getParameters().
 
 Specified by:
 
 getInParameters in interface Routine<T>
 
 Returns:
 
 The list of in parameters
 
 See Also:
 
 Routine.getParameters()
 - getParameters
```
public final List<Parameter<?>> getParameters()
```
 Specified by:
 
 getParameters in interface Routine<T>
 
 Returns:
 
 A list of parameters passed to the stored object as argument
 - getCatalog
```
public final Catalog getCatalog()
```
 Description copied from interface: Routine
 
 Get the routine catalog.
 
 Specified by:
 
 getCatalog in interface Routine<T>
 - getSchema
```
public final Schema getSchema()
```
 Description copied from interface: Routine
 
 Get the routine schema
 
 Specified by:
 
 getSchema in interface Routine<T>
 - getPackage
```
@Pro
public final Package getPackage()
```
 Description copied from interface: Routine
 
 The container package of this stored procedure or function.
 This is only supported in the SQLDialect.ORACLE dialect.
 
 Specified by:
 
 getPackage in interface Routine<T>
 
 Returns:
 
 The container package of this object, or null if there is no such container.
 - getReturnParameter
```
public final Parameter<T> getReturnParameter()
```
 Description copied from interface: Routine
 
 The parameter representing this routine's Routine.getReturnValue()
 
 Specified by:
 
 getReturnParameter in interface Routine<T>
 
 Returns:
 
 The return parameter or null if this routine doesn't have a return value.
 
 See Also:
 
 Routine.getParameters()
 - setOverloaded
```
protected final void setOverloaded(boolean overloaded)
```
 - isOverloaded
```
protected final boolean isOverloaded()
```
 - setPipelined
```
@Pro
protected final void setPipelined(boolean pipelined)
```
 - isPipelined
```
@Pro
protected final boolean isPipelined()
```
 - addInParameter
```
protected final void addInParameter(Parameter<?> parameter)
```
 - addInOutParameter
```
protected final void addInOutParameter(Parameter<?> parameter)
```
 - addOutParameter
```
protected final void addOutParameter(Parameter<?> parameter)
```
 - setReturnParameter
```
protected final void setReturnParameter(Parameter<T> parameter)
```
 - setPLSQLBooleanParameter
```
@Pro
protected final void setPLSQLBooleanParameter(Parameter<?> parameter)
```
 - asField
```
public final Field<T> asField()
```
 - asField
```
public final Field<T> asField(String alias)
```
 - asAggregateFunction
```
public final AggregateFunction<T> asAggregateFunction()
```
 - createParameter
```
@Deprecated
protected static final <T> Parameter<T> createParameter(String name,
 DataType<T> type)
```
 Deprecated.
 - Please, re-generate your routine code.
 
 Subclasses may call this method to create UDTField objects that are linked to this table.
 
 Parameters:
 
 name - The name of the field (case-sensitive!)
 
 type - The data type of the field
 - createParameter
```
@Deprecated
protected static final <T> Parameter<T> createParameter(String name,
 DataType<T> type,
 boolean isDefaulted)
```
 Deprecated.
 - Please, re-generate your routine code.
 
 Subclasses may call this method to create UDTField objects that are linked to this table.
 
 Parameters:
 
 name - The name of the field (case-sensitive!)
 
 type - The data type of the field
 
 isDefaulted - Whether the parameter is defaulted (see Parameter.isDefaulted()
 - createParameter
```
@Deprecated
protected static final <T,U> Parameter createParameter(String name,
 DataType<T> type,
 boolean isDefaulted,
 Converter<T,U> converter)
```
 Deprecated.
 - Please, re-generate your routine code.
 
 Subclasses may call this method to create UDTField objects that are linked to this table.
 
 Parameters:
 
 name - The name of the field (case-sensitive!)
 
 type - The data type of the field
 
 isDefaulted - Whether the parameter is defaulted (see Parameter.isDefaulted()
 - createParameter
```
@Deprecated
protected static final <T,U> Parameter createParameter(String name,
 DataType<T> type,
 boolean isDefaulted,
 Binding<T,U> binding)
```
 Deprecated.
 - Please, re-generate your routine code.
 
 Subclasses may call this method to create UDTField objects that are linked to this table.
 
 Parameters:
 
 name - The name of the field (case-sensitive!)
 
 type - The data type of the field
 
 isDefaulted - Whether the parameter is defaulted (see Parameter.isDefaulted()
 - createParameter
```
@Deprecated
protected static final <T,X,U> Parameter createParameter(String name,
 DataType<T> type,
 boolean isDefaulted,
 Converter<X,U> converter,
 Binding<T,X> binding)
```
 Deprecated.
 - Please, re-generate your routine code.
 
 Subclasses may call this method to create UDTField objects that are linked to this table.
 
 Parameters:
 
 name - The name of the field (case-sensitive!)
 
 type - The data type of the field
 
 isDefaulted - Whether the parameter is defaulted (see Parameter.isDefaulted()
 - createParameter
```
@Deprecated
protected static final <T> Parameter<T> createParameter(String name,
 DataType<T> type,
 boolean isDefaulted,
 boolean isUnnamed)
```
 Deprecated.
 - Please, re-generate your routine code.
 
 Subclasses may call this method to create UDTField objects that are linked to this table.
 
 Parameters:
 
 name - The name of the field (case-sensitive!)
 
 type - The data type of the field
 
 isDefaulted - Whether the parameter is defaulted (see Parameter.isDefaulted()
 
 isUnnamed - Whether the parameter is unnamed (see Parameter.isUnnamed().
 - createParameter
```
@Deprecated
protected static final <T,U> Parameter createParameter(String name,
 DataType<T> type,
 boolean isDefaulted,
 boolean isUnnamed,
 Converter<T,U> converter)
```
 Deprecated.
 - Please, re-generate your routine code.
 
 Subclasses may call this method to create UDTField objects that are linked to this table.
 
 Parameters:
 
 name - The name of the field (case-sensitive!)
 
 type - The data type of the field
 
 isDefaulted - Whether the parameter is defaulted (see Parameter.isDefaulted()
 
 isUnnamed - Whether the parameter is unnamed (see Parameter.isUnnamed().
 - createParameter
```
@Deprecated
protected static final <T,U> Parameter createParameter(String name,
 DataType<T> type,
 boolean isDefaulted,
 boolean isUnnamed,
 Binding<T,U> binding)
```
 Deprecated.
 - Please, re-generate your routine code.
 
 Subclasses may call this method to create UDTField objects that are linked to this table.
 
 Parameters:
 
 name - The name of the field (case-sensitive!)
 
 type - The data type of the field
 
 isDefaulted - Whether the parameter is defaulted (see Parameter.isDefaulted()
 
 isUnnamed - Whether the parameter is unnamed (see Parameter.isUnnamed().
 - createParameter
```
@Deprecated
protected static final <T,X,U> Parameter createParameter(String name,
 DataType<T> type,
 boolean isDefaulted,
 boolean isUnnamed,
 Converter<X,U> converter,
 Binding<T,X> binding)
```
 Deprecated.
 - Please, re-generate your routine code.
 
 Subclasses may call this method to create UDTField objects that are linked to this table.
 
 Parameters:
 
 name - The name of the field (case-sensitive!)
 
 type - The data type of the field
 
 isDefaulted - Whether the parameter is defaulted (see Parameter.isDefaulted()
 
 isUnnamed - Whether the parameter is unnamed (see Parameter.isUnnamed().
 - getName
```
public final String getName()
```
 Description copied from interface: Named
 
 The unqualified name of this object.
 
 Specified by:
 
 getName in interface Named
 - getQualifiedName
```
public Name getQualifiedName()
```
 Description copied from interface: Named
 
 The qualified name of this object.
 
 Specified by:
 
 getQualifiedName in interface Named
 - getUnqualifiedName
```
public final Name getUnqualifiedName()
```
 Description copied from interface: Named
 
 The unqualified name of this object.
 
 Specified by:
 
 getUnqualifiedName in interface Named
 - getComment
```
public final String getComment()
```
 Description copied from interface: Named
 
 The comment on this object.
 
 Specified by:
 
 getComment in interface Named
 - hashCode
```
public int hashCode()
```
 Description copied from interface: QueryPart
 
 Generate a hash code from this QueryPart.
 In general, QueryPart hash codes are the same as the hash codes generated from QueryPart.toString(). This guarantees consistent behaviour with QueryPart.equals(Object)
 Some QueryPart implementations may choose to override this behaviour for improved performance, as QueryPart.toString() is an expensive operation, if called many times.
 
 Specified by:
 
 hashCode in interface QueryPart
 
 Returns:
 
 The QueryPart hash code
 - equals
```
public boolean equals(Object that)
```
 Description copied from interface: QueryPart
 
 Check whether this QueryPart can be considered equal to another QueryPart.
 In general, QueryPart equality is defined in terms of QueryPart.toString() equality. In other words, two query parts are considered equal if their rendered SQL (with inlined bind variables) is equal. This means that the two query parts do not necessarily have to be of the same type.
 Some QueryPart implementations may choose to override this behaviour for improved performance, as QueryPart.toString() is an expensive operation, if called many times.
 
 Specified by:
 
 equals in interface QueryPart
 
 Parameters:
 
 that - The other QueryPart
 
 Returns:
 
 Whether the two query parts are equal
 - toSQL
```
@Deprecated
public final void toSQL(RenderContext context)
```
 Deprecated.
 - 3.4.0 - [#2694] - Use QueryPartInternal.accept(Context) instead.
 
 Description copied from interface: QueryPartInternal
 
 Render this QueryPart to a SQL string contained in context.sql(). The context will contain additional information about how to render this QueryPart, e.g. whether this QueryPart should be rendered as a declaration or reference, whether this QueryPart's contained bind variables should be inlined or replaced by '?', etc.
 
 Specified by:
 
 toSQL in interface QueryPartInternal
 - bind
```
@Deprecated
public final void bind(BindContext context)
 throws DataAccessException
```
 Deprecated.
 - 3.4.0 - [#2694] - Use QueryPartInternal.accept(Context) instead.
 
 Description copied from interface: QueryPartInternal
 
 Bind all parameters of this QueryPart to a PreparedStatement
 This method is for JOOQ INTERNAL USE only. Do not reference directly
 
 Specified by:
 
 bind in interface QueryPartInternal
 
 Parameters:
 
 context - The context holding the next bind index and other information for variable binding
 
 Throws:
 
 DataAccessException - If something went wrong while binding a variable
 - declaresFields
```
public boolean declaresFields()
```
 Subclasses may override this
 
 Specified by:
 
 declaresFields in interface QueryPartInternal
 - declaresTables
```
public boolean declaresTables()
```
 Subclasses may override this
 
 Specified by:
 
 declaresTables in interface QueryPartInternal
 - declaresWindows
```
public boolean declaresWindows()
```
 Subclasses may override this
 
 Specified by:
 
 declaresWindows in interface QueryPartInternal
 - declaresCTE
```
public boolean declaresCTE()
```
 Subclasses may override this
 
 Specified by:
 
 declaresCTE in interface QueryPartInternal
 - generatesCast
```
public boolean generatesCast()
```
 Subclasses may override this
 
 Specified by:
 
 generatesCast in interface QueryPartInternal
 - toString
```
public String toString()
```
 Description copied from interface: QueryPart
 
 Render a SQL string representation of this QueryPart.
 For improved debugging, this renders a SQL string of this QueryPart with inlined bind variables. If this QueryPart is Attachable, then the attached Configuration may be used for rendering the SQL string, including SQLDialect and Settings. Do note that most QueryPart instances are not attached to a Configuration, and thus there is no guarantee that the SQL string will make sense in the context of a specific database.
 
 Specified by:
 
 toString in interface QueryPart
 
 Overrides:
 
 toString in class Object
 
 Returns:
 
 A SQL string representation of this QueryPart
 - create
```
@Deprecated
protected final DSLContext create()
```
 Deprecated.
 - 3.11.0 - [#6722] - Use Attachable.configuration() and Configuration.dsl() instead.
 
 Internal convenience method
 - create
```
@Deprecated
protected final DSLContext create(Configuration configuration)
```
 Deprecated.
 - 3.11.0 - [#6722] - Use Attachable.configuration() and Configuration.dsl() instead.
 
 Internal convenience method
 - create
```
@Deprecated
protected final DSLContext create(Context<?> ctx)
```
 Deprecated.
 - 3.11.0 - [#6722] - Use Attachable.configuration() and Configuration.dsl() instead.
 
 Internal convenience method
 - translate
```
protected final DataAccessException translate(String sql,
 SQLException e)
```
 Internal convenience method

Class AbstractRoutine<T>

Constructor Summary

Method Summary

Methods inherited from class java.lang.Object

Methods inherited from interface org.jooq.Named

Methods inherited from interface org.jooq.QueryPart

Constructor Detail

AbstractRoutine

AbstractRoutine

AbstractRoutine

AbstractRoutine

AbstractRoutine

AbstractRoutine

AbstractRoutine

AbstractRoutine

AbstractRoutine

AbstractRoutine

Method Detail

setNumber

setNumber

setValue

set

setField

attach

detach

configuration

execute

execute

clauses

accept

getReturnValue

getResults

getValue

get

getInValues

getOutParameters

getInParameters

getParameters

getCatalog

getSchema

getPackage

getReturnParameter

setOverloaded

isOverloaded

setPipelined

isPipelined

addInParameter

addInOutParameter

addOutParameter

setReturnParameter

setPLSQLBooleanParameter

asField

asField

asAggregateFunction

createParameter

createParameter

createParameter

createParameter

createParameter

createParameter

createParameter

createParameter

createParameter

getName

getQualifiedName

getUnqualifiedName

getComment

hashCode

equals

toSQL

bind

declaresFields

declaresTables

declaresWindows

declaresCTE

generatesCast

toString

create

create

create