OdbcCallableStatement
class in package klyn.databases.sql.odbc

    public class OdbcCallableStatement extends OdbcPreparedStatement implements CallableStatement:

OdbcPreparedStatement
└ OdbcCallableStatement
All Implemented Interfaces: CallableStatement

ODBC callable statement.

Procedure calls without output parameters are executed through the normal prepared-statement path. Output-parameter registration is represented by the API, but reading output values requires ODBC output binding and is reported as unsupported until that native path is implemented.

    import klyn.databases.sql

    # call = connection.callable("{ call refresh_cache(?) }")
    # call.setString(1, "users")
    # call.execute()

Properties

Modifier and Type | Member | Description
--- | --- | ---
public readonly property | outParameters `outParameters as Map<Int, Int>:` | Declared output parameter SQL types.
public readonly property | outValues `outValues as Map<Int, Object>:` | Output values produced by this call.

Properties inherited from OdbcPreparedStatement: parameterInfo, parameterMetadata, parameters, sql
Properties inherited from CallableStatement: outParameters, outValues
Properties inherited from PreparedStatement: parameterInfo, parameterMetadata, parameters, sql
Properties inherited from Statement: batchSize, closeOnCompletion, closed, concurrency, connection, cursorName, escapeProcessing, fetchDirection, fetchSize, generatedKeys, holdability, largeMaxRows, maxFieldSize, maxRows, poolable, queryTimeoutSeconds, resultSetType, warning
Methods

Modifier and Type | Member | Description
--- | --- | ---
public | execute `execute(sql as String) as Boolean throws SQLException:` | Executes arbitrary SQL through the underlying statement API.
public override | execute `execute() as Boolean throws SQLException:` | Executes the callable statement.
public | executeQuery `executeQuery(sql as String) as ResultSet throws SQLException:` | Executes arbitrary query SQL through the underlying statement API.
public | executeUpdate `executeUpdate(sql as String) as Int throws SQLException:` | Executes arbitrary update SQL through the underlying statement API.
public | getBoolean `getBoolean(index as Int) as Boolean throws SQLException:` | Reads one output parameter as `Boolean`.
public | getDouble `getDouble(index as Int) as Double throws SQLException:` | Reads one output parameter as `Double`.
public | getInt `getInt(index as Int) as Int throws SQLException:` | Reads one output parameter as `Int`.
public | getLong `getLong(index as Int) as Long throws SQLException:` | Reads one output parameter as `Long`.
public | getObject `getObject(index as Int) as Object throws SQLException:` | Reads one output parameter as an object.
public | getString `getString(index as Int) as String throws SQLException:` | Reads one output parameter as text.
public | out `out(index as Int, sqlType as Int, scale as Int = 0) as CallableStatement throws SQLException:` | Registers an output parameter.
public override | query `query() as ResultSet throws SQLException:` | Executes the callable query.
public | registerOutParameter `registerOutParameter(index as Int, sqlType as Int, scale as Int = 0) as CallableStatement throws SQLException:` | Registers an output parameter.
public override | update `update() as Long throws SQLException:` | Executes the callable update.
public | wasNull `wasNull() as Boolean throws SQLException:` | Returns true when the last output read returned SQL NULL.

Methods inherited from OdbcPreparedStatement: clearParameters, execute, query, set, setBoolean, setDouble, setInt, setLong, setNull, setString, update
Methods inherited from CallableStatement: getBoolean, getDouble, getInt, getLong, getObject, getString, out, registerOutParameter, wasNull
Methods inherited from PreparedStatement: clearParameters, execute, query, set, setBoolean, setDouble, setInt, setLong, setNull, setString, update
Methods inherited from Statement: addBatch, clearBatch, clearWarnings, execute, executeBatch, executeQuery, executeUpdate, getResultSet
Methods inherited from AutoClosable: close