:: com :: sun :: star :: sdbc ::
|
service CallableStatement |
- Description
- is used to execute SQL stored procedures.
SDBC provides a stored procedure SQL escape that allows stored procedures
to be called in a standard way for all RDBMSs. This escape syntax has one
form that includes a result parameter and one that does not. If used, the
result parameter must be registered as an OUT parameter. The other parameters
can be used for input, output, or both. Parameters are referred to sequentially,
by number. The first parameter is 1.
{?=call<procedure-name>[<arg1>,<arg2>,...]} {call<procedure-name>[<arg1>,<arg2>,...]}
IN parameter values are set using the set methods inherited from
PreparedStatement
. The type of all
OUT parameters must be registered prior to executing the stored procedure;
their values are retrieved after execution via the
get
methods
provided by the
XRow
.
A
CallableStatement
can return one
XResultSet
or multiple
ResultSet
objects. Multiple
ResultSet
objects are
handled using operations inherited from
XPreparedStatement
.
For maximum portability, a call's
ResultSet
objects and
update counts should be processed prior to getting the values of output
parameters.
|
Included Services - Summary |
PreparedStatement |
- (referenced entity's summary:)
- represents a precompiled SQL statement.
|
Exported Interfaces - Summary |
XRow |
is used for retrieve the values of OUT parameters.
|
XOutParameters |
is used to declare parameters as OUT parameters.
|
Included Services - Details |
PreparedStatement
- (referenced entity's summary:)
- represents a precompiled SQL statement.
|
|
Exported Interfaces - Details |
XRow
- Description
- is used for retrieve the values of OUT parameters.
|
|
XOutParameters
- Description
- is used to declare parameters as OUT parameters.
|
|
Top of Page
Copyright © 2013, The Apache Software Foundation, Licensed under the Apache License, Version 2.0. Apache, the Apache feather logo, Apache OpenOffice and OpenOffice.org are trademarks of The Apache Software Foundation. Other names may be trademarks of their respective owners.