Class Zend_Db_Statement_Oracle

Description
Description | Vars (details) | Methods (details)

Extends for Oracle.

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

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

Zend_Db_Statement
   |
   --Zend_Db_Statement_Oracle
Variable Summary
Description | Vars (details) | Methods (details)
mixed $_keys
boolean $_lobAsString
mixed $_values
Method Summary
Description | Vars (details) | Methods (details)
bool closeCursor ()
int columnCount ()
string errorCode ()
array errorInfo ()
mixed fetch ([int $style = null], [int $cursor = null], [int $offset = null])
array fetchAll ([int $style = null], [int $col = 0])
string fetchColumn ([int $col = 0])
mixed fetchObject ([string $class = 'stdClass'], [ $config = array()])
boolean getLobAsString ()
bool nextRowset ()
int rowCount ()
Zend_Db_Statement_Oracle setLobAsString (string $lob_as_string)
bool _bindParam (mixed $parameter,  &$variable, [mixed $type = null], [mixed $length = null], [mixed $options = null], mixed $variable)
bool _execute ([ $params = null])
void _prepare (string $sql)
Variables
Description | Vars (details) | Methods (details)
mixed $_keys (line 43)

Column names.

  • access: protected
boolean $_lobAsString = false (line 56)

Check if LOB field are returned as string instead of OCI-Lob object

  • access: protected
mixed $_values (line 48)

Fetched result values.

  • access: protected

Inherited Variables

Inherited from Zend_Db_Statement

Zend_Db_Statement::$_adapter
 Zend_Db_Statement::$_attribute
 Zend_Db_Statement::$_bindColumn
 Zend_Db_Statement::$_bindParam
 Zend_Db_Statement::$_fetchMode
 Zend_Db_Statement::$_queryId
 Zend_Db_Statement::$_sqlParam
 Zend_Db_Statement::$_sqlSplit
 Zend_Db_Statement::$_stmt
Methods
Description | Vars (details) Methods (details)
closeCursor (line 140)

Closes the cursor, allowing the statement to be executed again.

  • access: public
bool closeCursor ()
columnCount (line 157)

Returns the number of columns in the result set.

Returns null if the statement has no result set metadata.

  • return: The number of columns.
  • access: public
int columnCount ()
errorCode (line 173)

Retrieves the error code, if any, associated with the last operation on the statement handle.

  • return: error code.
  • access: public
string errorCode ()
errorInfo (line 195)

Retrieves an array of error information, if any, associated with the last operation on the statement handle.

  • access: public
array errorInfo ()
fetch (line 291)

Fetches a row from the result set.

  • return: Array, object, or scalar depending on fetch mode.
  • throws: Zend_Db_Statement_Exception
  • access: public
mixed fetch ([int $style = null], [int $cursor = null], [int $offset = null])
  • int $style: OPTIONAL Fetch mode for this fetch operation.
  • int $cursor: OPTIONAL Absolute, relative, or other.
  • int $offset: OPTIONAL Number for absolute or relative cursors.
fetchAll (line 359)

Returns an array containing all of the result set rows.

  • return: Collection of rows, each in a format by the fetch mode.
  • throws: Zend_Db_Statement_Exception
  • access: public
array fetchAll ([int $style = null], [int $col = 0])
  • int $style: OPTIONAL Fetch mode.
  • int $col: OPTIONAL Column number, if fetch mode is by column.
Redefinition of:
Zend_Db_Statement::fetchAll()
Returns an array containing all of the result set rows.
fetchColumn (line 461)

Returns a single column from the next row of a result set.

  • throws: Zend_Db_Statement_Exception
  • access: public
string fetchColumn ([int $col = 0])
  • int $col: OPTIONAL Position of the column to fetch.
Redefinition of:
Zend_Db_Statement::fetchColumn()
Returns a single column from the next row of a result set.
fetchObject (line 507)

Fetches the next row and returns it as an object.

  • return: One object instance of the specified class.
  • throws: Zend_Db_Statement_Exception
  • access: public
mixed fetchObject ([string $class = 'stdClass'], [ $config = array()])
  • string $class: OPTIONAL Name of the class to create.
  • array $config: OPTIONAL Constructor arguments for the class.
Redefinition of:
Zend_Db_Statement::fetchObject()
Fetches the next row and returns it as an object.
getLobAsString (line 75)

Return whether or not LOB are returned as string

  • access: public
boolean getLobAsString ()
nextRowset (line 536)

Retrieves the next rowset (result set) for a SQL statement that has multiple result sets. An example is a stored procedure that returns the results of multiple queries.

  • throws: Zend_Db_Statement_Exception
  • access: public
bool nextRowset ()
rowCount (line 558)

Returns the number of rows affected by the execution of the last INSERT, DELETE, or UPDATE statement executed by this statement object.

  • return: The number of rows affected.
  • throws: Zend_Db_Statement_Exception
  • access: public
int rowCount ()
setLobAsString (line 64)

Activate/deactivate return of LOB as string

  • access: public
Zend_Db_Statement_Oracle setLobAsString (string $lob_as_string)
  • string $lob_as_string
_bindParam (line 111)

Binds a parameter to the specified variable name.

  • throws: Zend_Db_Statement_Exception
  • access: protected
bool _bindParam (mixed $parameter,  &$variable, [mixed $type = null], [mixed $length = null], [mixed $options = null], mixed $variable)
  • mixed $parameter: Name the parameter, either integer or string.
  • mixed $variable: Reference to PHP variable containing the value.
  • mixed $type: OPTIONAL Datatype of SQL parameter.
  • mixed $length: OPTIONAL Length of SQL parameter.
  • mixed $options: OPTIONAL Other options.
  • &$variable
_execute (line 229)

Executes a prepared statement.

  • throws: Zend_Db_Statement_Exception
  • access: public
bool _execute ([ $params = null])
  • array $params: OPTIONAL Values to bind to parameter placeholders.
_prepare (line 87)

Prepares statement handle

  • throws: Zend_Db_Statement_Oracle_Exception
  • access: protected
void _prepare (string $sql)
  • string $sql
Redefinition of:
Zend_Db_Statement::_prepare()
Internal method called by abstract statment constructor to setup the driver level statement

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::execute()
Zend_Db_Statement::fetchAll()
Zend_Db_Statement::fetchColumn()
Zend_Db_Statement::fetchObject()
Zend_Db_Statement::getAdapter()
Zend_Db_Statement::getAttribute()
Zend_Db_Statement::getDriverStatement()
Zend_Db_Statement::setAttribute()
Zend_Db_Statement::setFetchMode()
Zend_Db_Statement::_fetchBound()
Zend_Db_Statement::_parseParameters()
Zend_Db_Statement::_prepare()
Zend_Db_Statement::_stripQuoted()

Documentation generated on Mon, 21 Jun 2010 15:37:02 -0400 by phpDocumentor 1.4.3