Zend Framework  1.12
Public Member Functions | Protected Member Functions | Protected Attributes | List of all members
Zend_Db_Statement_Oracle Class Reference

Public Member Functions

 setLobAsString ($lob_as_string)
 Activate/deactivate return of LOB as string.
 
 getLobAsString ()
 Return whether or not LOB are returned as string.
 
 closeCursor ()
 Closes the cursor, allowing the statement to be executed again.
 
 columnCount ()
 Returns the number of columns in the result set.
 
 errorCode ()
 Retrieves the error code, if any, associated with the last operation on the statement handle.
 
 errorInfo ()
 Retrieves an array of error information, if any, associated with the last operation on the statement handle.
 
 _execute (array $params=null)
 Executes a prepared statement.
 
 fetch ($style=null, $cursor=null, $offset=null)
 Fetches a row from the result set.
 
 fetchAll ($style=null, $col=0)
 Returns an array containing all of the result set rows.
 
 fetchColumn ($col=0)
 Returns a single column from the next row of a result set.
 
 fetchObject ($class= 'stdClass', array $config=array())
 Fetches the next row and returns it as an object.
 
 nextRowset ()
 Retrieves the next rowset (result set) for a SQL statement that has multiple result sets.
 
 rowCount ()
 Returns the number of rows affected by the execution of the last INSERT, DELETE, or UPDATE statement executed by this statement object.
 
- Public Member Functions inherited from Zend_Db_Statement
 __construct ($adapter, $sql)
 Constructor for a statement.
 
 bindColumn ($column, &$param, $type=null)
 Bind a column of the statement result set to a PHP variable.
 
 bindParam ($parameter, &$variable, $type=null, $length=null, $options=null)
 Binds a parameter to the specified variable name.
 
 bindValue ($parameter, $value, $type=null)
 Binds a value to a parameter.
 
 execute (array $params=null)
 Executes a prepared statement.
 
 fetchAll ($style=null, $col=null)
 Returns an array containing all of the result set rows.
 
 fetchColumn ($col=0)
 Returns a single column from the next row of a result set.
 
 fetchObject ($class= 'stdClass', array $config=array())
 Fetches the next row and returns it as an object.
 
 getAttribute ($key)
 Retrieve a statement attribute.
 
 setAttribute ($key, $val)
 Set a statement attribute.
 
 setFetchMode ($mode)
 Set the default fetch mode for this statement.
 
 _fetchBound ($row)
 Helper function to map retrieved row to bound column variables.
 
 getAdapter ()
 Gets the Zend_Db_Adapter_Abstract for this particular Zend_Db_Statement object.
 
 getDriverStatement ()
 Gets the resource or object setup by the _parse.
 

Protected Member Functions

 _prepare ($sql)
 Prepares statement handle.
 
 _bindParam ($parameter, &$variable, $type=null, $length=null, $options=null)
 Binds a parameter to the specified variable name.
 
- Protected Member Functions inherited from Zend_Db_Statement
 _prepare ($sql)
 Internal method called by abstract statment constructor to setup the driver level statement.
 
 _parseParameters ($sql)
 
 _stripQuoted ($sql)
 Remove parts of a SQL string that contain quoted strings of values or identifiers.
 

Protected Attributes

 $_keys
 Column names.
 
 $_values
 Fetched result values.
 
 $_lobAsString = false
 
- Protected Attributes inherited from Zend_Db_Statement
 $_stmt = null
 
 $_adapter = null
 
 $_fetchMode = Zend_Db::FETCH_ASSOC
 
 $_attribute = array()
 
 $_bindColumn = array()
 
 $_bindParam = array()
 
 $_sqlSplit = array()
 
 $_sqlParam = array()
 
 $_queryId = null
 

Member Function Documentation

_bindParam (   $parameter,
$variable,
  $type = null,
  $length = null,
  $options = null 
)
protected

Binds a parameter to the specified variable name.

Parameters
mixed$parameterName the parameter, either integer or string.
mixed$variableReference to PHP variable containing the value.
mixed$typeOPTIONAL Datatype of SQL parameter.
mixed$lengthOPTIONAL Length of SQL parameter.
mixed$optionsOPTIONAL Other options.
Returns
bool
Exceptions
Zend_Db_Statement_Exception
See Also
Zend_Db_Adapter_Oracle_Exception
_execute ( array  $params = null)

Executes a prepared statement.

Parameters
array$paramsOPTIONAL Values to bind to parameter placeholders.
Returns
bool
Exceptions
Zend_Db_Statement_Exception
See Also
Zend_Db_Adapter_Oracle_Exception
Zend_Db_Adapter_Oracle_Exception
_prepare (   $sql)
protected

Prepares statement handle.

Parameters
string$sql
Returns
void
Exceptions
Zend_Db_Statement_Oracle_Exception
See Also
Zend_Db_Statement_Oracle_Exception
closeCursor ( )

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

Returns
bool

Implements Zend_Db_Statement_Interface.

columnCount ( )

Returns the number of columns in the result set.

Returns null if the statement has no result set metadata.

Returns
int The number of columns.

Implements Zend_Db_Statement_Interface.

errorCode ( )

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

Returns
string error code.

Implements Zend_Db_Statement_Interface.

errorInfo ( )

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

Returns
array

Implements Zend_Db_Statement_Interface.

fetch (   $style = null,
  $cursor = null,
  $offset = null 
)

Fetches a row from the result set.

Parameters
int$styleOPTIONAL Fetch mode for this fetch operation.
int$cursorOPTIONAL Absolute, relative, or other.
int$offsetOPTIONAL Number for absolute or relative cursors.
Returns
mixed Array, object, or scalar depending on fetch mode.
Exceptions
Zend_Db_Statement_Exception
See Also
Zend_Db_Adapter_Oracle_Exception
Zend_Db_Adapter_Oracle_Exception

Implements Zend_Db_Statement_Interface.

fetchAll (   $style = null,
  $col = 0 
)

Returns an array containing all of the result set rows.

Parameters
int$styleOPTIONAL Fetch mode.
int$colOPTIONAL Column number, if fetch mode is by column.
Returns
array Collection of rows, each in a format by the fetch mode.
Exceptions
Zend_Db_Statement_Exception
See Also
Zend_Db_Adapter_Oracle_Exception
Zend_Db_Adapter_Oracle_Exception
Zend_Db_Adapter_Oracle_Exception
Zend_Db_Adapter_Oracle_Exception

Implements Zend_Db_Statement_Interface.

fetchColumn (   $col = 0)

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

Parameters
int$colOPTIONAL Position of the column to fetch.
Returns
string
Exceptions
Zend_Db_Statement_Exception
See Also
Zend_Db_Adapter_Oracle_Exception
Zend_Db_Adapter_Oracle_Exception

Implements Zend_Db_Statement_Interface.

fetchObject (   $class = 'stdClass',
array  $config = array() 
)

Fetches the next row and returns it as an object.

Parameters
string$classOPTIONAL Name of the class to create.
array$configOPTIONAL Constructor arguments for the class.
Returns
mixed One object instance of the specified class.
Exceptions
Zend_Db_Statement_Exception
See Also
Zend_Db_Adapter_Oracle_Exception

Implements Zend_Db_Statement_Interface.

getLobAsString ( )

Return whether or not LOB are returned as string.

Returns
boolean
nextRowset ( )

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.

Returns
bool
Exceptions
Zend_Db_Statement_Exception
See Also
Zend_Db_Statement_Oracle_Exception

Implements Zend_Db_Statement_Interface.

rowCount ( )

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

Returns
int The number of rows affected.
Exceptions
Zend_Db_Statement_Exception
See Also
Zend_Db_Adapter_Oracle_Exception

Implements Zend_Db_Statement_Interface.

setLobAsString (   $lob_as_string)

Activate/deactivate return of LOB as string.

Parameters
string$lob_as_string
Returns
Zend_Db_Statement_Oracle

Member Data Documentation

$_keys
protected

Column names.

$_lobAsString = false
protected
$_values
protected

Fetched result values.