MDB2_Driver_oci8 Class Reference
Inheritance diagram for MDB2_Driver_oci8:
Collaboration diagram for MDB2_Driver_oci8:
Public Member Functions | |
| __construct () | |
| Constructor. More... | |
| errorInfo ($error=null) | |
| This method is used to collect information about an error. More... | |
| beginTransaction ($savepoint=null) | |
| Start a transaction or set a savepoint. More... | |
| commit ($savepoint=null) | |
| Commit the database changes done during a transaction that is in progress or release a savepoint. More... | |
| rollback ($savepoint=null) | |
| Cancel any database changes done during a transaction or since a specific savepoint that is in progress. More... | |
| setTransactionIsolation ($isolation) | |
| Set the transacton isolation level. More... | |
| _doConnect ($username, $password, $persistent=false) | |
| do the grunt work of the connect More... | |
| connect () | |
| Connect to the database. More... | |
| disconnect ($force=true) | |
| Log out and disconnect from the database. More... | |
| & | standaloneExec ($query) |
| execute a query as database administrator More... | |
| & | standaloneQuery ($query, $types=null, $is_manip=false) |
| execute a query as DBA More... | |
| _modifyQuery ($query, $is_manip, $limit, $offset) | |
| Changes a query string for various DBMS specific reasons. More... | |
| & | _doQuery ($query, $is_manip=false, $connection=null, $database_name=null) |
| Execute a query. More... | |
| _affectedRows ($connection, $result=null) | |
| Returns the number of rows affected. More... | |
| getServerVersion ($native=false) | |
| return version information about the server More... | |
| & | prepare ($query, $types=null, $result_types=null, $lobs=array()) |
| Prepares a query for multiple execution with execute(). More... | |
| nextID ($seq_name, $ondemand=true) | |
| Returns the next free id of a sequence. More... | |
| lastInsertID ($table=null, $field=null) | |
| Returns the autoincrement ID if supported or $id or fetches the current ID in a sequence called: $table. More... | |
| currId ($seq_name) | |
| Returns the current id of a sequence. More... | |
| Public Member Functions inherited from MDB2_Driver_Common | |
| __construct () | |
| Constructor. More... | |
| MDB2_Driver_Common () | |
| PHP 4 Constructor. More... | |
| __destruct () | |
| Destructor. More... | |
| free () | |
| Free the internal references so that the instance can be destroyed. More... | |
| __toString () | |
| String conversation. More... | |
| errorInfo ($error=null) | |
| This method is used to collect information about an error. More... | |
| & | raiseError ($code=null, $mode=null, $options=null, $userinfo=null, $method=null) |
| This method is used to communicate an error and invoke error callbacks etc. More... | |
| resetWarnings () | |
| reset the warning array More... | |
| getWarnings () | |
| Get all warnings in reverse order. More... | |
| setFetchMode ($fetchmode, $object_class='stdClass') | |
| Sets which fetch mode should be used by default on queries on this connection. More... | |
| setOption ($option, $value) | |
| set the option for the db class More... | |
| getOption ($option) | |
| Returns the value of an option. More... | |
| debug ($message, $scope='', $context=array()) | |
| set a debug message More... | |
| getDebugOutput () | |
| output debug info More... | |
| escape ($text, $escape_wildcards=false) | |
| Quotes a string so it can be safely used in a query. More... | |
| escapePattern ($text) | |
| Quotes pattern (% and _) characters in a string) More... | |
| quoteIdentifier ($str, $check_option=false) | |
| Quote a string so it can be safely used as a table or column name. More... | |
| getAsKeyword () | |
| Gets the string to alias column. More... | |
| getConnection () | |
| Returns a native connection. More... | |
| _fixResultArrayValues (&$row, $mode) | |
| Do all necessary conversions on result arrays to fix DBMS quirks. More... | |
| & | loadModule ($module, $property=null, $phptype_specific=null) |
| loads a module More... | |
| __call ($method, $params) | |
| Calls a module method using the __call magic method. More... | |
| beginTransaction ($savepoint=null) | |
| Start a transaction or set a savepoint. More... | |
| commit ($savepoint=null) | |
| Commit the database changes done during a transaction that is in progress or release a savepoint. More... | |
| rollback ($savepoint=null) | |
| Cancel any database changes done during a transaction or since a specific savepoint that is in progress. More... | |
| inTransaction ($ignore_nested=false) | |
| If a transaction is currently open. More... | |
| setTransactionIsolation ($isolation, $options=array()) | |
| Set the transacton isolation level. More... | |
| beginNestedTransaction () | |
| Start a nested transaction. More... | |
| completeNestedTransaction ($force_rollback=false) | |
| Finish a nested transaction by rolling back if an error occured or committing otherwise. More... | |
| failNestedTransaction ($error=null, $immediately=false) | |
| Force setting nested transaction to failed. More... | |
| getNestedTransactionError () | |
| The first error that occured since the transaction start. More... | |
| connect () | |
| Connect to the database. More... | |
| setCharset ($charset, $connection=null) | |
| Set the charset on the current connection. More... | |
| disconnect ($force=true) | |
| Log out and disconnect from the database. More... | |
| setDatabase ($name) | |
| Select a different database. More... | |
| getDatabase () | |
| Get the current database. More... | |
| setDSN ($dsn) | |
| set the DSN More... | |
| getDSN ($type='string', $hidepw=false) | |
| return the DSN as a string More... | |
| & | standaloneQuery ($query, $types=null, $is_manip=false) |
| execute a query as database administrator More... | |
| _modifyQuery ($query, $is_manip, $limit, $offset) | |
| Changes a query string for various DBMS specific reasons. More... | |
| & | _doQuery ($query, $is_manip=false, $connection=null, $database_name=null) |
| Execute a query. More... | |
| _affectedRows ($connection, $result=null) | |
| Returns the number of rows affected. More... | |
| & | exec ($query) |
| Execute a manipulation query to the database and return the number of affected rows. More... | |
| & | query ($query, $types=null, $result_class=true, $result_wrap_class=false) |
| Send a query to the database and return any results. More... | |
| & | _wrapResult ($result, $types=array(), $result_class=true, $result_wrap_class=false, $limit=null, $offset=null) |
| wrap a result set into the correct class More... | |
| getServerVersion ($native=false) | |
| return version information about the server More... | |
| setLimit ($limit, $offset=null) | |
| set the range of the next query More... | |
| subSelect ($query, $type=false) | |
| simple subselect emulation: leaves the query untouched for all RDBMS that support subselects More... | |
| replace ($table, $fields) | |
| Execute a SQL REPLACE query. More... | |
| & | prepare ($query, $types=null, $result_types=null, $lobs=array()) |
| Prepares a query for multiple execution with execute(). More... | |
| _skipDelimitedStrings ($query, $position, $p_position) | |
| Utility method, used by prepare() to avoid replacing placeholders within delimited strings. More... | |
| quote ($value, $type=null, $quote=true, $escape_wildcards=false) | |
| Convert a text value into a DBMS specific format that is suitable to compose query statements. More... | |
| getDeclaration ($type, $name, $field) | |
| Obtain DBMS specific SQL code portion needed to declare of the given type. More... | |
| compareDefinition ($current, $previous) | |
| Obtain an array of changes that may need to applied. More... | |
| supports ($feature) | |
| Tell whether a DB implementation or its backend extension supports a given feature. More... | |
| getSequenceName ($sqn) | |
| adds sequence name formatting to a sequence name More... | |
| getIndexName ($idx) | |
| adds index name formatting to a index name More... | |
| nextID ($seq_name, $ondemand=true) | |
| Returns the next free id of a sequence. More... | |
| lastInsertID ($table=null, $field=null) | |
| Returns the autoincrement ID if supported or $id or fetches the current ID in a sequence called: $table. More... | |
| currID ($seq_name) | |
| Returns the current id of a sequence. More... | |
| queryOne ($query, $type=null, $colnum=0) | |
| Execute the specified query, fetch the value from the first column of the first row of the result set and then frees the result set. More... | |
| queryRow ($query, $types=null, $fetchmode=MDB2_FETCHMODE_DEFAULT) | |
| Execute the specified query, fetch the values from the first row of the result set into an array and then frees the result set. More... | |
| queryCol ($query, $type=null, $colnum=0) | |
| Execute the specified query, fetch the value from the first column of each row of the result set into an array and then frees the result set. More... | |
| queryAll ($query, $types=null, $fetchmode=MDB2_FETCHMODE_DEFAULT, $rekey=false, $force_array=false, $group=false) | |
| Execute the specified query, fetch all the rows of the result set into a two dimensional array and then frees the result set. More... | |
| Public Member Functions inherited from PEAR | |
| PEAR ($error_class=null) | |
| Constructor. More... | |
| _PEAR () | |
| Destructor (the emulated type of...). More... | |
| & | getStaticProperty ($class, $var) |
| If you have a class that's mostly/entirely static, and you need static properties, you can use this method to simulate them. More... | |
| registerShutdownFunc ($func, $args=array()) | |
| Use this function to register a shutdown method for static classes. More... | |
| isError ($data, $code=null) | |
| Tell whether a value is a PEAR error. More... | |
| setErrorHandling ($mode=null, $options=null) | |
| Sets how errors generated by this object should be handled. More... | |
| expectError ($code=' *') | |
| This method is used to tell which errors you expect to get. More... | |
| popExpect () | |
| This method pops one element off the expected error codes stack. More... | |
| _checkDelExpect ($error_code) | |
| This method checks unsets an error code if available. More... | |
| delExpect ($error_code) | |
| This method deletes all occurences of the specified element from the expected error codes stack. More... | |
| & | raiseError ($message=null, $code=null, $mode=null, $options=null, $userinfo=null, $error_class=null, $skipmsg=false) |
| This method is a wrapper that returns an instance of the configured error class with this object's default error handling applied. More... | |
| & | throwError ($message=null, $code=null, $userinfo=null) |
| Simpler form of raiseError with fewer options. More... | |
| staticPushErrorHandling ($mode, $options=null) | |
| staticPopErrorHandling () | |
| pushErrorHandling ($mode, $options=null) | |
| Push a new error handler on top of the error handler options stack. More... | |
| popErrorHandling () | |
| Pop the last error handler used. More... | |
| loadExtension ($ext) | |
| OS independant PHP extension load. More... | |
Detailed Description
Constructor & Destructor Documentation
◆ __construct()
| MDB2_Driver_oci8::__construct | ( | ) |
Constructor.
Reimplemented from MDB2_Driver_Common.
Definition at line 69 of file oci8.php.
70 {
71 parent::__construct();
72
73 $this->phptype = 'oci8';
74 $this->dbsyntax = 'oci8';
75
76 $this->supported['sequences'] = true;
77 $this->supported['indexes'] = true;
78 $this->supported['summary_functions'] = true;
79 $this->supported['order_by_text'] = true;
80 $this->supported['current_id'] = true;
81 $this->supported['affected_rows'] = true;
82 $this->supported['transactions'] = true;
83 $this->supported['savepoints'] = true;
84 $this->supported['limit_queries'] = true;
85 $this->supported['LOBs'] = true;
86 $this->supported['replace'] = 'emulated';
87 $this->supported['sub_selects'] = true;
88 $this->supported['auto_increment'] = false; // implementation is broken
89 $this->supported['primary_key'] = true;
90 $this->supported['result_introspection'] = true;
91 $this->supported['prepared_statements'] = true;
92 $this->supported['identifier_quoting'] = true;
93 $this->supported['pattern_escaping'] = true;
94 $this->supported['new_link'] = true;
95
96 $this->options['DBA_username'] = false;
97 $this->options['DBA_password'] = false;
98 $this->options['database_name_prefix'] = false;
99 $this->options['emulate_database'] = true;
100 $this->options['default_tablespace'] = false;
101 $this->options['default_text_field_length'] = 2000;
102 $this->options['result_prefetching'] = false;
103 }
Member Function Documentation
◆ _affectedRows()
| MDB2_Driver_oci8::_affectedRows | ( | $connection, | |
$result = null |
|||
| ) |
Returns the number of rows affected.
- Parameters
-
resource $result resource $connection
Reimplemented from MDB2_Driver_Common.
Definition at line 684 of file oci8.php.
References MDB2_Driver_Common\$connection, $result, MDB2_Driver_Common\getConnection(), and PEAR\isError().
Referenced by standaloneExec(), and standaloneQuery().
Here is the call graph for this function:
Here is the caller graph for this function:
◆ _doConnect()
| MDB2_Driver_oci8::_doConnect | ( | $username, | |
| $password, | |||
$persistent = false |
|||
| ) |
do the grunt work of the connect
Definition at line 319 of file oci8.php.
320 {
323 'extension '.$this->phptype.' is not compiled into PHP', __FUNCTION__);
324 }
325
326 $sid = '';
327
328 if (!empty($this->dsn['service']) && $this->dsn['hostspec']) {
329 //oci8://username:password@foo.example.com[:port]/?service=service
330 // service name is given, it is assumed that hostspec is really a
331 // hostname, we try to construct an oracle connection string from this
332 $port = $this->dsn['port'] ? $this->dsn['port'] : 1521;
333 $sid = sprintf("(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)
334 (HOST=%s) (PORT=%s)))
335 (CONNECT_DATA=(SERVICE_NAME=%s)))",
336 $this->dsn['hostspec'],
337 $port,
338 $this->dsn['service']
339 );
340 } elseif ($this->dsn['hostspec']) {
341 // we are given something like 'oci8://username:password@foo/'
342 // we have hostspec but not a service name, now we assume that
343 // hostspec is a tnsname defined in tnsnames.ora
344 $sid = $this->dsn['hostspec'];
345 } else {
346 // oci://username:password@
347 // if everything fails, we have to rely on environment variables
348 // not before a check to 'emulate_database'
349 if (!$this->options['emulate_database'] && $this->database_name) {
350 $sid = $this->database_name;
351 } elseif (getenv('ORACLE_SID')) {
352 $sid = getenv('ORACLE_SID');
353 } elseif ($sid = getenv('TWO_TASK')) {
354 $sid = getenv('TWO_TASK');
355 } else {
357 'not a valid connection string or environment variable [ORACLE_SID|TWO_TASK] not set',
358 __FUNCTION__);
359 }
360 }
361
362 if (function_exists('oci_connect')) {
363 if (isset($this->dsn['new_link'])
364 && ($this->dsn['new_link'] == 'true' || $this->dsn['new_link'] === true)
365 ) {
366 $connect_function = 'oci_new_connect';
367 } else {
368 $connect_function = $persistent ? 'oci_pconnect' : 'oci_connect';
369 }
370
371 $charset = empty($this->dsn['charset']) ? null : $this->dsn['charset'];
372 $connection = @$connect_function($username, $password, $sid, $charset);
373 $error = @OCIError();
374 if (isset($error['code']) && $error['code'] == 12541) {
375 // Couldn't find TNS listener. Try direct connection.
377 }
378 } else {
379 $connect_function = $persistent ? 'OCIPLogon' : 'OCILogon';
380 $connection = @$connect_function($username, $password, $sid);
381
382 if (!empty($this->dsn['charset'])) {
386 }
387 }
388 }
389
392 'unable to establish a connection', __FUNCTION__);
393 }
394
395 if (empty($this->dsn['disable_iso_date'])) {
400 return $err;
401 }
402 }
403
408 return $err;
409 }
410
412 }
setCharset($charset, $connection=null)
Set the charset on the current connection.
Definition: MDB2.php:2216
& raiseError($code=null, $mode=null, $options=null, $userinfo=null, $method=null)
This method is used to communicate an error and invoke error callbacks etc.
Definition: MDB2.php:1407
& _doQuery($query, $is_manip=false, $connection=null, $database_name=null)
Execute a query.
Definition: oci8.php:627
References MDB2_Driver_Common\$connection, MDB2_Driver_Common\$database_name, $query, $result, _doQuery(), disconnect(), PEAR\isError(), PEAR\loadExtension(), MDB2_ERROR_CONNECT_FAILED, MDB2_ERROR_NOT_FOUND, MDB2_Driver_Common\raiseError(), and MDB2_Driver_Common\setCharset().
Referenced by connect(), standaloneExec(), and standaloneQuery().
Here is the call graph for this function:
Here is the caller graph for this function:
◆ _doQuery()
| & MDB2_Driver_oci8::_doQuery | ( | $query, | |
$is_manip = false, |
|||
$connection = null, |
|||
$database_name = null |
|||
| ) |
Execute a query.
- Parameters
-
string $query query boolean $is_manip if the query is a manipulation query resource $connection string $database_name
- Returns
- result or error object @access protected
Reimplemented from MDB2_Driver_Common.
Definition at line 627 of file oci8.php.
628 {
629 $this->last_query = $query;
634 }
636 }
638 if ($is_manip) {
639 return 0;
640 }
641 return null;
642 }
643
648 }
649 }
650
654 'Could not create statement', __FUNCTION__);
655 return $err;
656 }
657
658 $mode = $this->in_transaction ? OCI_DEFAULT : OCI_COMMIT_ON_SUCCESS;
661 'Could not execute statement', __FUNCTION__);
662 return $err;
663 }
664
665 if (is_numeric($this->options['result_prefetching'])) {
667 }
668
669 $this->debug($query, 'query', array('is_manip' => $is_manip, 'when' => 'post', 'result' => $result));
671 }
References MDB2_Driver_Common\$connection, $query, $result, MDB2_Driver_Common\debug(), MDB2_Driver_Common\getConnection(), MDB2_Driver_Common\getOption(), PEAR\isError(), and MDB2_Driver_Common\raiseError().
Referenced by _doConnect(), beginTransaction(), rollback(), setTransactionIsolation(), standaloneExec(), and standaloneQuery().
Here is the call graph for this function:
Here is the caller graph for this function:
◆ _modifyQuery()
| MDB2_Driver_oci8::_modifyQuery | ( | $query, | |
| $is_manip, | |||
| $limit, | |||
| $offset | |||
| ) |
Changes a query string for various DBMS specific reasons.
- Parameters
-
string $query query to modify boolean $is_manip if it is a DML query integer $limit limit the number of rows integer $offset start reading from given offset
- Returns
- string modified query @access protected
Reimplemented from MDB2_Driver_Common.
Definition at line 595 of file oci8.php.
596 {
600 }
602 // taken from http://svn.ez.no/svn/ezcomponents/packages/Database
605 $min = $offset + 1;
606 $query = "SELECT * FROM (SELECT a.*, ROWNUM mdb2rn FROM ($query) a WHERE ROWNUM <= $max) WHERE mdb2rn >= $min";
607 } else {
609 }
610 }
611 }
613 }
References MDB2_Driver_Common\$limit, MDB2_Driver_Common\$offset, and $query.
Referenced by prepare(), standaloneExec(), and standaloneQuery().
Here is the caller graph for this function:
◆ beginTransaction()
| MDB2_Driver_oci8::beginTransaction | ( | $savepoint = null | ) |
Start a transaction or set a savepoint.
- Parameters
-
string name of a savepoint to set
- Returns
- mixed MDB2_OK on success, a MDB2 error on failure
@access public
Reimplemented from MDB2_Driver_Common.
Definition at line 171 of file oci8.php.
172 {
173 $this->debug('Starting transaction/savepoint', __FUNCTION__, array('is_manip' => true, 'savepoint' => $savepoint));
174 if (!is_null($savepoint)) {
175 if (!$this->in_transaction) {
177 'savepoint cannot be released when changes are auto committed', __FUNCTION__);
178 }
181 } elseif ($this->in_transaction) {
183 }
184 if (!$this->destructor_registered && $this->opened_persistent) {
185 $this->destructor_registered = true;
186 register_shutdown_function('MDB2_closeOpenTransactions');
187 }
188 $this->in_transaction = true;
189 ++$this->uncommitedqueries;
191 }
const MDB2_OK
The method mapErrorCode in each MDB2_dbtype implementation maps native error codes to one of these.
Definition: MDB2.php:67
References $query, $uncommitedqueries, _doQuery(), MDB2_Driver_Common\debug(), MDB2_ERROR_INVALID, MDB2_OK, and MDB2_Driver_Common\raiseError().
Here is the call graph for this function:
◆ commit()
| MDB2_Driver_oci8::commit | ( | $savepoint = null | ) |
Commit the database changes done during a transaction that is in progress or release a savepoint.
This function may only be called when auto-committing is disabled, otherwise it will fail. Therefore, a new transaction is implicitly started after committing the pending changes.
- Parameters
-
string name of a savepoint to release
- Returns
- mixed MDB2_OK on success, a MDB2 error on failure
@access public
Reimplemented from MDB2_Driver_Common.
Definition at line 207 of file oci8.php.
208 {
209 $this->debug('Committing transaction/savepoint', __FUNCTION__, array('is_manip' => true, 'savepoint' => $savepoint));
210 if (!$this->in_transaction) {
212 'commit/release savepoint cannot be done changes are auto committed', __FUNCTION__);
213 }
214 if (!is_null($savepoint)) {
216 }
217
218 if ($this->uncommitedqueries) {
222 }
225 'Unable to commit transaction', __FUNCTION__);
226 }
227 $this->uncommitedqueries = 0;
228 }
229 $this->in_transaction = false;
231 }
References MDB2_Driver_Common\$connection, MDB2_Driver_Common\debug(), MDB2_Driver_Common\getConnection(), PEAR\isError(), MDB2_ERROR_INVALID, MDB2_OK, and MDB2_Driver_Common\raiseError().
Here is the call graph for this function:
◆ connect()
| MDB2_Driver_oci8::connect | ( | ) |
Connect to the database.
Reimplemented from MDB2_Driver_Common.
Definition at line 423 of file oci8.php.
424 {
425 if ($this->database_name && $this->options['emulate_database']) {
426 $this->dsn['username'] = $this->options['database_name_prefix'].$this->database_name;
427 }
428 if (is_resource($this->connection)) {
429 if (count(array_diff($this->connected_dsn, $this->dsn)) == 0
430 && $this->connected_database_name == $this->database_name
431 && $this->opened_persistent == $this->options['persistent']
432 ) {
434 }
436 }
437
439 $this->dsn['username'],
440 $this->dsn['password'],
441 $this->options['persistent']
442 );
445 }
446 $this->connection = $connection;
447 $this->connected_dsn = $this->dsn;
448 $this->connected_database_name = $this->database_name;
449 $this->opened_persistent = $this->options['persistent'];
451
452 $this->as_keyword = ' ';
453 $server_info = $this->getServerVersion();
454 if (is_array($server_info)) {
455 if ($server_info['major'] >= '10') {
456 $this->as_keyword = ' AS ';
457 }
458 }
460 }
_doConnect($username, $password, $persistent=false)
do the grunt work of the connect
Definition: oci8.php:319
References MDB2_Driver_Common\$connection, MDB2_Driver_Common\$database_name, MDB2_Driver_Common\$dsn, MDB2_Driver_Common\$phptype, _doConnect(), disconnect(), getServerVersion(), PEAR\isError(), and MDB2_OK.
Here is the call graph for this function:
◆ currId()
| MDB2_Driver_oci8::currId | ( | $seq_name | ) |
Returns the current id of a sequence.
- Parameters
-
string $seq_name name of the sequence
- Returns
- mixed MDB2_Error or id @access public
Definition at line 951 of file oci8.php.
952 {
953 $sequence_name = $this->getSequenceName($seq_name);
958 }
queryOne($query, $type=null, $colnum=0)
Execute the specified query, fetch the value from the first column of the first row of the result set...
Definition: MDB2.php:3203
References $query, MDB2_Driver_Common\getSequenceName(), and MDB2_Driver_Common\queryOne().
Here is the call graph for this function:
◆ disconnect()
| MDB2_Driver_oci8::disconnect | ( | $force = true | ) |
Log out and disconnect from the database.
- Parameters
-
boolean $force if the disconnect should be forced even if the connection is opened persistently
- Returns
- mixed true on success, false if not connected and error object on error @access public
Reimplemented from MDB2_Driver_Common.
Definition at line 474 of file oci8.php.
475 {
476 if (is_resource($this->connection)) {
477 if ($this->in_transaction) {
480 $persistent = $this->options['persistent'];
481 $this->dsn = $this->connected_dsn;
482 $this->database_name = $this->connected_database_name;
484 $this->rollback();
485 $this->dsn = $dsn;
486 $this->database_name = $database_name;
487 $this->options['persistent'] = $persistent;
488 }
489
490 if (!$this->opened_persistent || $force) {
491 if (function_exists('oci_close')) {
492 @oci_close($this->connection);
493 } else {
494 @OCILogOff($this->connection);
495 }
496 }
497 $this->uncommitedqueries = 0;
498 }
499 return parent::disconnect($force);
500 }
rollback($savepoint=null)
Cancel any database changes done during a transaction or since a specific savepoint that is in progre...
Definition: oci8.php:247
References MDB2_Driver_Common\$connected_database_name, MDB2_Driver_Common\$connected_dsn, MDB2_Driver_Common\$database_name, MDB2_Driver_Common\$dsn, MDB2_Driver_Common\$opened_persistent, and rollback().
Referenced by _doConnect(), and connect().
Here is the call graph for this function:
Here is the caller graph for this function:
◆ errorInfo()
| MDB2_Driver_oci8::errorInfo | ( | $error = null | ) |
This method is used to collect information about an error.
- Parameters
-
integer $error
- Returns
- array @access public
Reimplemented from MDB2_Driver_Common.
Definition at line 115 of file oci8.php.
116 {
117 if (is_resource($error)) {
118 $error_data = @OCIError($error);
119 $error = null;
120 } elseif ($this->connection) {
121 $error_data = @OCIError($this->connection);
122 } else {
123 $error_data = @OCIError();
124 }
125 $native_code = $error_data['code'];
126 $native_msg = $error_data['message'];
127 if (is_null($error)) {
128 static $ecode_map;
129 if (empty($ecode_map)) {
130 $ecode_map = array(
131 1 => MDB2_ERROR_CONSTRAINT,
132 900 => MDB2_ERROR_SYNTAX,
133 904 => MDB2_ERROR_NOSUCHFIELD,
135 913 => MDB2_ERROR_VALUE_COUNT_ON_ROW,
136 921 => MDB2_ERROR_SYNTAX,
137 923 => MDB2_ERROR_SYNTAX,
138 942 => MDB2_ERROR_NOSUCHTABLE,
139 955 => MDB2_ERROR_ALREADY_EXISTS,
140 1400 => MDB2_ERROR_CONSTRAINT_NOT_NULL,
141 1401 => MDB2_ERROR_INVALID,
142 1407 => MDB2_ERROR_CONSTRAINT_NOT_NULL,
143 1418 => MDB2_ERROR_NOT_FOUND,
144 1476 => MDB2_ERROR_DIVZERO,
145 1722 => MDB2_ERROR_INVALID_NUMBER,
146 2289 => MDB2_ERROR_NOSUCHTABLE,
147 2291 => MDB2_ERROR_CONSTRAINT,
148 2292 => MDB2_ERROR_CONSTRAINT,
149 2449 => MDB2_ERROR_CONSTRAINT,
151 );
152 }
153 if (isset($ecode_map[$native_code])) {
154 $error = $ecode_map[$native_code];
155 }
156 }
157 return array($error, $native_code, $native_msg);
158 }
References MDB2_ERROR_ALREADY_EXISTS, MDB2_ERROR_CONSTRAINT, MDB2_ERROR_CONSTRAINT_NOT_NULL, MDB2_ERROR_DIVZERO, MDB2_ERROR_INVALID, MDB2_ERROR_INVALID_NUMBER, MDB2_ERROR_NOSUCHFIELD, MDB2_ERROR_NOSUCHTABLE, MDB2_ERROR_NOT_FOUND, MDB2_ERROR_SYNTAX, and MDB2_ERROR_VALUE_COUNT_ON_ROW.
◆ getServerVersion()
| MDB2_Driver_oci8::getServerVersion | ( | $native = false | ) |
return version information about the server
- Parameters
-
bool $native determines if the raw version string should be returned
- Returns
- mixed array/string with version information or MDB2 error object @access public
Reimplemented from MDB2_Driver_Common.
Definition at line 705 of file oci8.php.
706 {
710 }
711 if ($this->connected_server_info) {
712 $server_info = $this->connected_server_info;
713 } else {
714 $server_info = @ociserverversion($connection);
715 }
716 if (!$server_info) {
718 'Could not get server information', __FUNCTION__);
719 }
720 // cache server_info
721 $this->connected_server_info = $server_info;
722 if (!$native) {
723 if (!preg_match('/ (\d+)\.(\d+)\.(\d+)\.([\d\.]+) /', $server_info, $tmp)) {
725 'Could not parse version information:'.$server_info, __FUNCTION__);
726 }
727 $server_info = array(
728 'major' => $tmp[1],
729 'minor' => $tmp[2],
730 'patch' => $tmp[3],
731 'extra' => $tmp[4],
732 'native' => $server_info,
733 );
734 }
735 return $server_info;
736 }
References MDB2_Driver_Common\$connected_server_info, MDB2_Driver_Common\$connection, MDB2_Driver_Common\getConnection(), PEAR\isError(), MDB2_ERROR_INVALID, and MDB2_Driver_Common\raiseError().
Referenced by connect().
Here is the call graph for this function:
Here is the caller graph for this function:
◆ lastInsertID()
| MDB2_Driver_oci8::lastInsertID | ( | $table = null, |
|
$field = null |
|||
| ) |
Returns the autoincrement ID if supported or $id or fetches the current ID in a sequence called: $table.
(empty($field) ? '' : '_'.$field)
- Parameters
-
string $table name of the table into which a new row was inserted string $field name of the field into which a new row was inserted
Reimplemented from MDB2_Driver_Common.
Definition at line 934 of file oci8.php.
935 {
936 $seq = $table.(empty($field) ? '' : '_'.$field);
939 }
quoteIdentifier($str, $check_option=false)
Quote a string so it can be safely used as a table or column name.
Definition: MDB2.php:1700
References MDB2_Driver_Common\getSequenceName(), MDB2_Driver_Common\queryOne(), and MDB2_Driver_Common\quoteIdentifier().
Here is the call graph for this function:
◆ nextID()
| MDB2_Driver_oci8::nextID | ( | $seq_name, | |
$ondemand = true |
|||
| ) |
Returns the next free id of a sequence.
- Parameters
-
string $seq_name name of the sequence boolean $ondemand when true the sequence is automatic created, if it not exists
Reimplemented from MDB2_Driver_Common.
Definition at line 902 of file oci8.php.
903 {
908 $this->popExpect();
912 $result = $this->manager->createSequence($seq_name);
915 }
916 return $this->nextId($seq_name, false);
917 }
918 }
920 }
& loadModule($module, $property=null, $phptype_specific=null)
loads a module
Definition: MDB2.php:1840
expectError($code=' *')
This method is used to tell which errors you expect to get.
Definition: PEAR.php:390
References $query, $result, PEAR\expectError(), MDB2_Driver_Common\getSequenceName(), PEAR\isError(), MDB2_Driver_Common\loadModule(), MDB2_ERROR_NOSUCHTABLE, PEAR\popExpect(), MDB2_Driver_Common\queryOne(), and MDB2_Driver_Common\quoteIdentifier().
Here is the call graph for this function:
◆ prepare()
| & MDB2_Driver_oci8::prepare | ( | $query, | |
$types = null, |
|||
$result_types = null, |
|||
$lobs = array() |
|||
| ) |
Prepares a query for multiple execution with execute().
With some database backends, this is emulated. prepare() requires a generic query as string like 'INSERT INTO numbers VALUES(?,?)' or 'INSERT INTO numbers VALUES(:foo,:bar)'. The ? and :[a-zA-Z] and are placeholders which can be set using bindParam() and the query can be send off using the execute() method.
- Parameters
-
string $query the query to prepare mixed $types array that contains the types of the placeholders mixed $result_types array that contains the types of the columns in the result set or MDB2_PREPARE_RESULT, if set to MDB2_PREPARE_MANIP the query is handled as a manipulation query mixed $lobs key (field) value (parameter) pair for all lob placeholders
- Returns
- mixed resource handle for the prepared query on success, a MDB2 error on failure @access public
- See also
- bindParam, execute
Reimplemented from MDB2_Driver_Common.
Definition at line 761 of file oci8.php.
762 {
763 if ($this->options['emulate_prepared']) {
764 $obj =& parent::prepare($query, $types, $result_types, $lobs);
765 return $obj;
766 }
767 $is_manip = ($result_types === MDB2_PREPARE_MANIP);
770 $this->offset = $this->limit = 0;
775 }
777 }
779 $placeholder_type_guess = $placeholder_type = null;
780 $question = '?';
781 $colon = ':';
782 $positions = array();
783 $position = 0;
784 $parameter = -1;
786 $q_position = strpos($query, $question, $position);
787 $c_position = strpos($query, $colon, $position);
788 if ($q_position && $c_position) {
789 $p_position = min($q_position, $c_position);
790 } elseif ($q_position) {
791 $p_position = $q_position;
792 } elseif ($c_position) {
793 $p_position = $c_position;
794 } else {
795 break;
796 }
797 if (is_null($placeholder_type)) {
798 $placeholder_type_guess = $query[$p_position];
799 }
800
803 return $new_pos;
804 }
805 if ($new_pos != $position) {
806 $position = $new_pos;
807 continue; //evaluate again starting from the new position
808 }
809
811 if (is_null($placeholder_type)) {
812 $placeholder_type = $query[$p_position];
813 $question = $colon = $placeholder_type;
814 if (!empty($types) && is_array($types)) {
815 if ($placeholder_type == ':') {
816 if (is_int(key($types))) {
817 $types_tmp = $types;
818 $types = array();
819 $count = -1;
820 }
821 } else {
822 $types = array_values($types);
823 }
824 }
825 }
826 if ($placeholder_type == ':') {
828 if ($parameter === '') {
830 'named parameter with an empty name', __FUNCTION__);
831 return $err;
832 }
833 // use parameter name in type array
834 if (isset($count) && isset($types_tmp[++$count])) {
835 $types[$parameter] = $types_tmp[$count];
836 }
837 $length = strlen($parameter) + 1;
838 } else {
839 ++$parameter;
840 $length = strlen($parameter);
841 }
842 if (!in_array($parameter, $positions)) {
843 $positions[] = $parameter;
844 }
845 if (isset($types[$parameter])
846 && ($types[$parameter] == 'clob' || $types[$parameter] == 'blob')
847 ) {
848 if (!isset($lobs[$parameter])) {
849 $lobs[$parameter] = $parameter;
850 }
853 $position = $p_position + strlen($value) - 1;
854 } elseif ($placeholder_type == '?') {
856 $position = $p_position + $length;
857 } else {
858 $position = $p_position + 1;
859 }
860 } else {
861 $position = $p_position;
862 }
863 }
864 if (is_array($lobs)) {
866 foreach ($lobs as $parameter => $field) {
868 $variables.= ($variables ? ', ' : ' INTO ').':'.$parameter;
869 }
871 }
875 }
877 if (!$statement) {
879 'Could not create statement', __FUNCTION__);
880 return $err;
881 }
882
883 $class_name = 'MDB2_Statement_'.$this->phptype;
884 $obj =& new $class_name($this, $statement, $positions, $query, $types, $result_types, $is_manip, $limit, $offset);
885 $this->debug($query, __FUNCTION__, array('is_manip' => $is_manip, 'when' => 'post', 'result' => $obj));
886 return $obj;
887 }
const MDB2_PREPARE_MANIP
These are just helper constants to more verbosely express parameters to prepare()
Definition: MDB2.php:109
_skipDelimitedStrings($query, $position, $p_position)
Utility method, used by prepare() to avoid replacing placeholders within delimited strings.
Definition: MDB2.php:2963
quote($value, $type=null, $quote=true, $escape_wildcards=false)
Convert a text value into a DBMS specific format that is suitable to compose query statements.
Definition: MDB2.php:3009
_modifyQuery($query, $is_manip, $limit, $offset)
Changes a query string for various DBMS specific reasons.
Definition: oci8.php:595
References $columns, MDB2_Driver_Common\$connection, MDB2_Driver_Common\$limit, MDB2_Driver_Common\$offset, $query, $result, _modifyQuery(), MDB2_Driver_Common\_skipDelimitedStrings(), MDB2_Driver_Common\debug(), MDB2_Driver_Common\getConnection(), PEAR\isError(), MDB2_ERROR_SYNTAX, MDB2_PREPARE_MANIP, MDB2_Driver_Common\quote(), and MDB2_Driver_Common\raiseError().
Here is the call graph for this function:
◆ rollback()
| MDB2_Driver_oci8::rollback | ( | $savepoint = null | ) |
Cancel any database changes done during a transaction or since a specific savepoint that is in progress.
This function may only be called when auto-committing is disabled, otherwise it will fail. Therefore, a new transaction is implicitly started after canceling the pending changes.
- Parameters
-
string name of a savepoint to rollback to
- Returns
- mixed MDB2_OK on success, a MDB2 error on failure
@access public
Reimplemented from MDB2_Driver_Common.
Definition at line 247 of file oci8.php.
248 {
249 $this->debug('Rolling back transaction/savepoint', __FUNCTION__, array('is_manip' => true, 'savepoint' => $savepoint));
250 if (!$this->in_transaction) {
252 'rollback cannot be done changes are auto committed', __FUNCTION__);
253 }
254 if (!is_null($savepoint)) {
257 }
258
259 if ($this->uncommitedqueries) {
263 }
266 'Unable to rollback transaction', __FUNCTION__);
267 }
268 $this->uncommitedqueries = 0;
269 }
270 $this->in_transaction = false;
272 }
References MDB2_Driver_Common\$connection, $query, _doQuery(), MDB2_Driver_Common\debug(), MDB2_Driver_Common\getConnection(), PEAR\isError(), MDB2_ERROR_INVALID, MDB2_OK, and MDB2_Driver_Common\raiseError().
Referenced by disconnect().
Here is the call graph for this function:
Here is the caller graph for this function:
◆ setTransactionIsolation()
| MDB2_Driver_oci8::setTransactionIsolation | ( | $isolation | ) |
Set the transacton isolation level.
- Parameters
-
string standard isolation level READ UNCOMMITTED (allows dirty reads) READ COMMITTED (prevents dirty reads) REPEATABLE READ (prevents nonrepeatable reads) SERIALIZABLE (prevents phantom reads)
- Returns
- mixed MDB2_OK on success, a MDB2 error on failure
@access public
- Since
- 2.1.1
Definition at line 290 of file oci8.php.
291 {
293 switch ($isolation) {
294 case 'READ UNCOMMITTED':
295 $isolation = 'READ COMMITTED';
296 case 'READ COMMITTED':
297 case 'REPEATABLE READ':
298 $isolation = 'SERIALIZABLE';
299 case 'SERIALIZABLE':
300 break;
301 default:
303 'isolation level is not supported: '.$isolation, __FUNCTION__);
304 }
305
308 }
References $query, _doQuery(), MDB2_Driver_Common\debug(), MDB2_ERROR_UNSUPPORTED, and MDB2_Driver_Common\raiseError().
Here is the call graph for this function:
◆ standaloneExec()
| & MDB2_Driver_oci8::standaloneExec | ( | $query | ) |
execute a query as database administrator
- Parameters
-
string $query the SQL query
- Returns
- mixed MDB2_OK on success, a MDB2 error on failure @access public
Definition at line 512 of file oci8.php.
513 {
515 $this->options['DBA_username'],
516 $this->options['DBA_password'],
517 $this->options['persistent']
518 );
521 }
522
525 $this->offset = $this->limit = 0;
527
530 @OCILogOff($connection);
532 }
533
535 @OCILogOff($connection);
537 }
_affectedRows($connection, $result=null)
Returns the number of rows affected.
Definition: oci8.php:684
References MDB2_Driver_Common\$connection, MDB2_Driver_Common\$limit, MDB2_Driver_Common\$offset, $query, $result, $ret, _affectedRows(), _doConnect(), _doQuery(), _modifyQuery(), and PEAR\isError().
Here is the call graph for this function:
◆ standaloneQuery()
| & MDB2_Driver_oci8::standaloneQuery | ( | $query, | |
$types = null, |
|||
$is_manip = false |
|||
| ) |
execute a query as DBA
- Parameters
-
string $query the SQL query mixed $types array that contains the types of the columns in the result set boolean $is_manip if the query is a manipulation query
- Returns
- mixed MDB2_OK on success, a MDB2 error on failure @access public
Reimplemented from MDB2_Driver_Common.
Definition at line 552 of file oci8.php.
553 {
555 $this->options['DBA_username'],
556 $this->options['DBA_password'],
557 $this->options['persistent']
558 );
561 }
562
565 $this->offset = $this->limit = 0;
567
569 @OCILogOff($connection);
572 }
573
574 if ($is_manip) {
576 return $affected_rows;
577 }
579 return $return;
580 }
& _wrapResult($result, $types=array(), $result_class=true, $result_wrap_class=false, $limit=null, $offset=null)
wrap a result set into the correct class
Definition: MDB2.php:2541
References MDB2_Driver_Common\$connection, MDB2_Driver_Common\$limit, MDB2_Driver_Common\$offset, $query, $result, _affectedRows(), _doConnect(), _doQuery(), _modifyQuery(), MDB2_Driver_Common\_wrapResult(), and PEAR\isError().
Here is the call graph for this function:
Field Documentation
◆ $identifier_quoting
| MDB2_Driver_oci8::$identifier_quoting = array('start' => '"', 'end' => '"', 'escape' => '"') |
◆ $string_quoting
| MDB2_Driver_oci8::$string_quoting = array('start' => "'", 'end' => "'", 'escape' => "'", 'escape_pattern' => '@') |
◆ $uncommitedqueries
| MDB2_Driver_oci8::$uncommitedqueries = 0 |
Definition at line 62 of file oci8.php.
Referenced by beginTransaction().
The documentation for this class was generated from the following file:
- Services/PEAR/lib/MDB2/Driver/oci8.php
