## Zend_Db_Statement_Oracle

Description

Extends for Oracle.

- license: New BSD License
- copyright: Copyright (c) 2005-2007 Zend Technologies USA Inc. (http://www.zend.com)

Located in /Zend/Db/Statement/Oracle.php (line 37)

    Zend_Db_Statement
       |
       --Zend_Db_Statement_Oracle

Variable Summary
mixed $_keys
mixed $_stmt
mixed $_values
Method Summary
void bindParam ($parameter $parameter, $variable &$variable, [$type $type = null], [$length $length = null], [$options $options = null])
boolean closeCursor ()
num columnCount ()
error errorCode ()
array errorInfo ()
void execute ([$params $params = null])
$row fetch ([$style $style = null], [$cursor $cursor = null], [$offset $offset = null])
$result fetchAll ([$style $style = null], [$col $col = 0])
$data fetchColumn ([$col $col = 0])
$obj fetchObject ([$class $class = 'stdClass'], [$config $config = null])
num rowCount ()
void _prepSql ($sql $sql)
Variables
mixed $_keys (line 48)

Column names.

- access: protected

mixed $_stmt (line 43)

The connection_stmt object.

- access: protected

mixed $_values (line 53)

Fetched result values.

- access: protected

#### Inherited Variables

Inherited from Zend_Db_Statement

> Zend_Db_Statement::$_attribute
> Zend_Db_Statement::$_bindColumn
> Zend_Db_Statement::$_bindParam
> Zend_Db_Statement::$_fetchMode
> Zend_Db_Statement::$_sqlParam
> Zend_Db_Statement::$_sqlSplit

Methods
bindParam (line 201)

Binds a PHP variable to a parameter in the prepared statement.

- access: public
- throws: Zend_Db_Statement_Exception

void bindParam ($parameter $parameter, $variable &$variable, [$type $type = null], [$length $length = null], [$options $options = null])

- $parameter $parameter
- $variable &$variable
- $type $type
- $length $length
- $options $options

Redefinition of:

Zend_Db_Statement::bindParam()
  Binds a PHP variable to a parameter in the prepared statement.

closeCursor (line 60)

closes the cursor, allowing the statement to be executed again

- return: True if cursor has been closed.
- access: public

boolean closeCursor ()

Redefinition of:

Zend_Db_Statement::closeCursor()
  Closes the cursor, allowing the statement to be executed again.

columnCount (line 77)

Returns the number of columns in the result set.

- return: fields.
- access: public

num columnCount ()

Redefinition of:

Zend_Db_Statement::columnCount()
  Returns the number of columns in the result set.

errorCode (line 92)

Retrieves an error code, if any, from the statement.

- return: code
- access: public

error errorCode ()

Redefinition of:

Zend_Db_Statement::errorCode()
  Retrieves an error code, if any, from the statement.

errorInfo (line 113)

Retrieves an array of error information, if any, from the statement.

- access: public

array errorInfo ()

Redefinition of:

Zend_Db_Statement::errorInfo()
  Retrieves an array of error information, if any, from the statement.

execute (line 147)

Executes a prepared statement.

- access: public
- throws: Zend_Db_Statement_Oracle_Exception

void execute ([$params $params = null])

- $params $params

Redefinition of:

Zend_Db_Statement::execute()
  Executes a prepared statement.

fetch (line 239)

Fetches a row from the result set.

- access: public
- throws: Zend_Db_Statement_Exception

$row fetch ([$style $style = null], [$cursor $cursor = null], [$offset $offset = null])

- $style $style
- $cursor $cursor
- $offset $offset

Redefinition of:

Zend_Db_Statement::fetch()
  Fetches a row from a result set.

fetchAll (line 322)

Fetches an array containing all of the rows from a result set

- access: public
- throws: Zend_Db_Statement_Oracle_Exception
- throws: Zend_Db_Statement_Exception

$result fetchAll ([$style $style = null], $col $col)

- $style $style
- $col $col

Redefinition of:

Zend_Db_Statement::fetchAll()
  Fetches an array containing all of the rows from a result set.

fetchColumn (line 391)

Returns the data from a single column in a result set.

- access: public
- throws: Zend_Db_Statement_Oracle_Exception

$data fetchColumn ($col $col)

- $col $col

Redefinition of:

Zend_Db_Statement::fetchColumn()
  Returns the data from a single column in the next single row of the result set.

fetchObject (line 417)

Fetches the next row and returns it as an object.

- access: public
- throws: Zend_Db_Statement_Oracle_Exception

$obj fetchObject ([$class $class = 'stdClass'], [$config $config = null])

- $class $class
- $config $config

Redefinition of:

Zend_Db_Statement::fetchObject()
  Fetches the next row and returns it as an object.

rowCount (line 283)

Returns the number of rows that were affected by the execution of an SQL statement.

- return: rows
- access: public
- throws: Zend_Db_Statement_Oracle_Exception

num rowCount ()

Redefinition of:

Zend_Db_Statement::rowCount()
  returns the number of rows that were affected by the execution of an SQL statement

_prepSql (line 304)

Prepares statement handle

- access: protected
- throws: Zend_Db_Statement_Oracle_Exception

void _prepSql ($sql $sql)

- $sql $sql

Redefinition of:

Zend_Db_Statement::_prepSql()
  Splits SQL into text and params, sets up $this->_bindParam for replacements.

#### Inherited Methods

Inherited From Zend_Db_Statement

> Zend_Db_Statement::__construct()
> Zend_Db_Statement::bindColumn()
> Zend_Db_Statement::bindParam()
> Zend_Db_Statement::bindValue()
> Zend_Db_Statement::closeCursor()
> Zend_Db_Statement::columnCount()
> Zend_Db_Statement::errorCode()
> Zend_Db_Statement::errorInfo()
> Zend_Db_Statement::execute()
> Zend_Db_Statement::fetch()
> Zend_Db_Statement::fetchAll()
> Zend_Db_Statement::fetchColumn()
> Zend_Db_Statement::fetchObject()
> Zend_Db_Statement::getAttribute()
> Zend_Db_Statement::nextRowset()
> Zend_Db_Statement::rowCount()
> Zend_Db_Statement::setAttribute()
> Zend_Db_Statement::setFetchMode()
> Zend_Db_Statement::_joinSql()
> Zend_Db_Statement::_prepSql()

Documentation generated on Wed, 21 Feb 2007 11:56:17 -0800 by phpDocumentor 1.3.1