Oracle.Statement

Definitions

prepare : Connection -> String -> IO (Either OracleError Statement)

  Prepare a SQL statement.
  
  The returned statement must eventually be released with `release` or managed with `withStatement`.
  

Totality: total
Visibility: export

release : Statement -> IO ()

  Release a prepared statement.
  
  This decrements the underlying ODPI-C statement reference count.
  

Totality: total
Visibility: export

withStatement : Connection -> String -> (Statement -> IO (Either OracleError a)) -> IO (Either OracleError a)

  Prepare a statement, execute an action, and guarantee that the statement is released afterwards.
  
  This is the preferred way to work with prepared statements.
  
  Prepare a statement, execute an action, and guarantee cleanup.
  
  The statement is released regardless of whether the action succeeds or fails.
  

Totality: total
Visibility: export

execute : Statement -> IO (Either OracleError ())

  Execute a prepared statement.
  
  For SELECT statements this executes the query.
  For INSERT/UPDATE/DELETE statements this performs the update.
  

Totality: total
Visibility: export

bindOne : Statement -> BindParameter -> IO (Either OracleError ())

  Bind a single named parameter.
  
  Supported value types:
  - OracleNull
  - OracleString
  - OracleInt
  - OracleUInt
  - OracleDouble
  - OracleBool
  - OracleClob
  - OracleBlob
  - OracleDate
  - OracleTimestamp
  - OracleTimestampTZ
  - OracleTimestampLTZ
  - OracleIntervalYM
  - OracleIntervalDS
  
  OracleBytes bindings are not supported as of yet.
  

Totality: total
Visibility: export

bind : Statement -> List BindParameter -> IO (Either OracleError ())

  Bind a collection of named parameters.
  

Totality: total
Visibility: export

fetchRow : Statement -> IO (Either OracleError (Maybe (List OracleValue)))

  Fetch a single row from the current result set.
  
  Returns:
  - Right Nothing when no rows remain.
  - Right (Just row) when a row was fetched.
  - Left OracleError on failure.
  

Visibility: export

fetchRaw : Statement -> IO (Either OracleError (List (List OracleValue)))

  Fetch all remaining rows from the current result set.
  

Visibility: export

query : Connection -> String -> List BindParameter -> IO (Either OracleError (List (List OracleValue)))

  Execute a SQL query and return all rows.
  

Visibility: export