Language:

The Free and Open Productivity Suite
Apache OpenOffice 4.1.4 released

Developer's Guide

API

SDK

Tips 'n' Tricks

Miscellaneous


:: 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

Apache Software Foundation

Copyright & License | Privacy | Contact Us | Donate | Thanks

Apache and the Apache feather logo are trademarks of The Apache Software Foundation. OpenOffice, OpenOffice.org and the seagull logo are registered trademarks of The Apache Software Foundation. Other names appearing on the site may be trademarks of their respective owners.