Class 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 (mixed $parameter,  &$variable, [string $type = null], [integer $length = null], [array $options = null], string $variable)
 boolean closeCursor ()
 mixed columnCount ()
 mixed errorCode ()
 mixed errorInfo ()
 void execute ([ $params = array()])
 mixed fetch ([string $style = null], [string $cursor = null], [integer $offset = null])
 mixed fetchAll ([string $style = null], [integer $col = 0])
 mixed fetchColumn ([integer $col = 0])
 mixed fetchObject ([string $class = 'stdClass'], [ $config = array()])
 mixed rowCount ()
 void _prepSql (string $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 (mixed $parameter,  &$variable, [string $type = null], [integer $length = null], [array $options = null], string $variable)
  • mixed $parameter
  • string $variable
  • string $type: OPTIONAL
  • integer $length: OPTIONAL
  • array $options: OPTIONAL
  • &$variable

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: Integer number of fields, or false.
  • access: public
mixed 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: Error code, or false.
  • access: public
mixed 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.

  • return: Structured information about the error, or false.
  • access: public
mixed 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 = array()])
  • array $params

Redefinition of:
Zend_Db_Statement::execute()
Executes a prepared statement.
fetch (line 238)

Fetches a row from the result set.

  • access: public
  • throws: Zend_Db_Statement_Exception
mixed fetch ([string $style = null], [string $cursor = null], [integer $offset = null])
  • string $style: OPTIONAL
  • string $cursor: OPTIONAL
  • integer $offset: OPTIONAL

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

  • return: Result set structured per $style, or false.
  • access: public
  • throws: Zend_Db_Statement_Oracle_Exception
  • throws: Zend_Db_Statement_Exception
mixed fetchAll ([string $style = null], integer $col)
  • string $style
  • integer $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.

  • return: Structured result set, or false.
  • access: public
  • throws: Zend_Db_Statement_Oracle_Exception
mixed fetchColumn (integer $col)
  • integer $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.

  • return: Result set as object, or false.
  • access: public
  • throws: Zend_Db_Statement_Oracle_Exception
mixed fetchObject ([string $class = 'stdClass'], [ $config = array()])
  • string $class
  • array $config

Redefinition of:
Zend_Db_Statement::fetchObject()
Fetches the next row and returns it as an object.
rowCount (line 282)

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

  • return: Integer number of rows, or false.
  • access: public
  • throws: Zend_Db_Statement_Oracle_Exception
mixed 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 (string $sql)
  • string $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 Fri, 06 Apr 2007 18:28:55 -0700 by phpDocumentor 1.3.1