Main Page Namespace List Class Hierarchy Compound List Header Files Namespace Members Compound Members

odbc::CallableStatement Class Reference

A prepared statement suited for stored procedure calls. More...

#include <odbc++/callablestatement.h>

Class diagram for odbc::CallableStatement:

List of all members.

Public Members

virtual ~CallableStatement ()
Destructor.
double getDouble (int idx)
Fetches a parameter as a double. More...
bool getBoolean (int idx)
Fetches a parameter as a bool. More...
signed char getByte (int idx)
Fetches a parameter as a signed char. More...
Bytes getBytes (int idx)
Fetches a parameter as a Bytes object. More...
Date getDate (int idx)
Fetches a parameter as a Date. More...
float getFloat (int idx)
Fetches a parameter as a float. More...
int getInt (int idx)
Fetches a parameter as an int. More...
Long getLong (int idx)
Fetches a parameter as a Long. More...
short getShort (int idx)
Fetches a parameter as a short. More...
std::string getString (int idx)
Fetches a parameter as a string. More...
Time getTime (int idx)
Fetches a parameter as a Time. More...
Timestamp getTimestamp (int idx)
Fetches a parameter as a Timestamp. More...
void registerOutParameter (int idx, int sqlType)
Registers an output parameter. More...
void registerOutParameter (int idx, int sqlType, int scale)
Registers an output parameter with a given scale. More...
bool wasNull ()
Returns true if the last fetched parameter was NULL.

Detailed Description

A prepared statement suited for stored procedure calls.

A CallableStatement extends the functionality of a PreparedStatement, by allowing output parameters.

The ODBC escapes for calling stored procedures and functions should be used. A procedure call is prepared like this:

 CallableStatement* cstmt=con->prepareCall
     ("{call my_procedure(?,?,?)}");

And for a function call (a procedure that returns a value), the following syntax should be used:

 CallableStatement* cstmt=con->prepareCall
     ("{?=call my_function(?,?)}");

All parameters in a CallableStatement are treated as input/output parameters, unless they are registered as output-only parameters with registerOutParameter(). Note that output-only parameters must be registered with their proper SQL type prior to executing a CallableStatement.