org.jooq
Interface StoredObject

All Superinterfaces:

Adapter, Attachable, Comparable<NamedQueryPart>, NamedQueryPart, QueryPart, SchemaProvider, Serializable

All Known Subinterfaces:

StoredFunction<T>, StoredProcedure

All Known Implementing Classes:

AbstractStoredProcedure, PostgresSingleUDTOutParameterProcedure, StoredFunctionImpl, StoredProcedureImpl

public interface StoredObject
extends NamedQueryPart, SchemaProvider

A common interface for stored procedures and stored functions. These objects behave like queries, i.e. they can be executed on a connection. The concrete behaviour is specific to the concrete interface

Author:

Lukas Eder

Method Summary

int	execute() Execute the stored object on an underlying connection
int	execute(Connection connection) Execute the stored object on a connection
Package	getPackage() The container package of this stored procedure or function.
List<Parameter<?>>	getParameters()

Methods inherited from interface org.jooq.NamedQueryPart

getName

Methods inherited from interface org.jooq.QueryPart

getSQL

Methods inherited from interface org.jooq.Attachable

attach, getConfiguration

Methods inherited from interface org.jooq.Adapter

internalAPI

Methods inherited from interface java.lang.Comparable

compareTo

Methods inherited from interface org.jooq.SchemaProvider

getSchema

Method Detail

getParameters

List<Parameter<?>> getParameters()

Returns:

A list of parameters passed to the stored object as argument

getPackage

Package getPackage()

The container package of this stored procedure or function.

This is only supported in the SQLDialect.ORACLE dialect.

Returns:

The container package of this object, or null if there is no such container.

execute

int execute(Connection connection)
            throws SQLException

Execute the stored object on a connection

Throws:

SQLException

execute

int execute()
            throws SQLException,
                   DetachedException

Execute the stored object on an underlying connection

Throws:

SQLException - If anything went wrong with executing the stored object

DetachedException - If this stored object is not attached