Differences

This shows you the differences between two versions of the page.

--- database:oracle [2016/01/13 01:51] – ↷ Links adapted because of a move operation mnewnham
+++ v5:database:oracle [2022/07/13 02:57] – [oci8] mnewnham
@@ Line 13: / Line 13: @@
 ^ADOdb V6|Yes|
 == Alternatives ==
-**Alternative Drivers**\\
+[[v5:database:pdo#pdo_oci|PDO driver for Oracle]]
-[[database:pdo#pdo_oci|PDO driver for Oracle]]\\
+== See Also ==
-[[database:ado|ADO driver for Oracle]]
+[[v5:reference:connection:setconnectionparameter#oracle|setConnectionParameter()]]
 </WRAP>
 ** This is the preferred driver for connecting to Oracle databases **
 Despite its name, this driver supports Oracle databases up to and including Oracle 11.
+This is currently the only supported driver when using PHP 7
 ---------------------------------------
 ===== Driver Specific Methods =====
@@ Line 27: / Line 29: @@
 The following **non-portable** methods are available to this driver
 ^ Method                                              ^ Description                                ^
-| [[reference:oracle:bind|bind()]]                    | A fast way of updating records             |
+| [[v5:database:oracle:bind|bind()]]                    | A fast way of updating records             |
-| [[reference:oracle:ExecuteCursor|executeCursor()]]  | Returns a cursor to procedure as a handle  |
+| [[v5:database:oracle:executecursor|executeCursor()]]  | Returns a cursor to procedure as a handle  |
-{{tag>[oracle unix windows active]}}
+{{tag>[oracle unix windows active tier1]}}
 ==== Connection Examples ====
@@ Line 70: / Line 72: @@
   $dsn = 'oci8://user:pwd@tnsname/?persist';  # persist is optional
-  $conn = ADONewConnection($dsn);  # no need for Connect/PConnect
+  $conn = ADONewConnection($dsn);  # no need for connect/pConnect
   $dsn = 'oci8://user:pwd@host/sid';
@@ Line 87: / Line 89: @@
 The default value for ''NLS_DATE_FORMAT'' is ''YYYY-MM-DD''. To include time as well, use ''RRRR-MM-DD HH24:MI:SS'' or set the value to empty to disable this action.
+----------------------------------
+==== Auto-Increment Column ====
+[[v5:dictionary:column_attributes#AUTO or AUTOINCREMENT|Auto-increment]] support for Oracle databases is implemented by creating an on-insert trigger that retrieves a sequence number from a sequence //**SEQ_ + table name **//. This is done by default.
+-----------------------------------
+==== Session Mode ====
+From ADOdb **V5.23.0**, You can use external ''(OCI_CRED_EXT)'' or privileged (''OCI_SYSOPER or OCI_SYSDBA'') sessions via the [[v5:reference:connection:setconnectionparameter|setConnectionParameter()]] method, **prior** to establishing a connection.
+<code php>
+$db = ADONewConnection('oci8');
+$db->setConnectionParameter('session_mode', OCI_CRED_EXT);
+$db->connect(false, 'scott', 'tiger', 'myTNS');
+</code>
+----------------------------------------------
 ====== oci8po ======
 <WRAP right box round 300px>
@@ Line 100: / Line 118: @@
 ^ADOdb V6|Yes|
 </WRAP>
-This driver extends the oci8 driver and provides compatibility with other database drivers such as MySQL and SQL Server. Use this version of the driver if you are writing portable code.
+This driver extends the oci8 driver and mostly provides compatibility with MySQL databases which use the ? placeholder for bind params.
+If you are migrating code or writing portable code, consider using the [[v5:reference:connection:param|param()]] command to write portable placeholders.
+A second difference to this driver is that it does not create a sequence to emulate auto-increment fields. You must provide the functionality yourself if you need it.
 {{tag>[oracle unix windows active portable]}}
 ------------------------------------
@@ Line 115: / Line 138: @@
 </WRAP>
 This driver provides an undocumented enhancement to the oci8 driver
+It adds a [[https://docs.oracle.com/cd/B12037_01/server.101/b10752/hintsref.htm#4942|FIRST_ROWS]] optimizer hint to the SQL statements executed with [[v5:reference:connection:selectlimit]].
+Note that //FIRST_ROWS// has been deprecated in Oracle 9.2, and is retained for backwards compatibility.
 {{tag>[oracle unix windows deprecated]}}
@@ Line 122: / Line 149: @@
 <WRAP right box round 300px>
 == Specification ==
-^Driver Name|oci805cus|
+^Driver Name|oci8quercus|
 ^Data Provider|oracle|
 ^Status|Inactive((This driver is obsolete is not actively supported or enhanced by ADOdb project members, but you can provide fixes and enhancements if you have the expertise))|
@@ Line 130: / Line 157: @@
 ^ADOdb V6|Yes|
 </WRAP>
-This driver provides an undocumented enhancement to the oci8 driver
+This driver provides an undocumented enhancement to the oci8 driver. The differences in the driver relate solely to the use of cursors in stored procedures. This may be related to information in the function [[v5:database:oracle:executecursor|executeCursor]]  and the [[v5:userguide:oracle_tutorial|Oracle Tutorial]]. If you have the appropriate expertise and the time to investigate and explain these drivers, let us know.
 {{tag>[oracle unix windows deprecated]}}
@@ Line 137: / Line 164: @@
 ====== oracle ======
 <WRAP info>
-Support for oracle databases versions 7 and lower was removed in PHP version 5.1. In ADOdb version 6, the Oracle driver will be removed and the oci8 driver will become the oracle driver
+Support for oracle databases versions 7 and lower was removed in PHP version 5.1. In ADOdb version 6, the Oracle driver will be removed
 </WRAP>
 <WRAP right box round 300px>
@@ Line 149: / Line 176: @@
 ^ADOdb V6|No|
 </WRAP>
-This driver provided support to oracle 7 and lower databases. The driver is obsolete, and not supported by PHP and will be removed in ADOdb version 6.0 The data provider name 'oracle' will be assigned to the oci8 driver. The oci8 driver will become a stub to provide backwards compatibility.
+This driver provided support to oracle 7 and lower databases. The driver is obsolete, and not supported by PHP and will be removed in ADOdb version 6.0.