ADOdb

Database Abstraction Layer for PHP

User Tools

Site Tools

Trace:
v5:database:oracle

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
v5:database:oracle [2023/01/25 04:37] – [Auto-Increment Column] mnewnhamv5:database:oracle [2025/06/01 13:21] (current) – Remove square brackets in tags dregad
Line 31: Line 31:
 | [[v5:database:oracle:bind|bind()]]                    | A fast way of updating records             | | [[v5:database:oracle:bind|bind()]]                    | A fast way of updating records             |
 | [[v5:database: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 tier1]}}+{{tag>oracle unix windows active tier1}}
  
 ==== Connection Examples ==== ==== Connection Examples ====
Line 99: Line 99:
 === Accessing the trigger in your code === === Accessing the trigger in your code ===
 <code php> <code php>
 +
 +$db->useCompactAutoIncrements=true;
  
 $tab = 'customer_delivery_address'; $tab = 'customer_delivery_address';
Line 139: Line 141:
 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. 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]}}+{{tag>oracle unix windows active portable}}
 ------------------------------------ ------------------------------------
 ====== oci805 ====== ====== oci805 ======
Line 157: Line 159:
 Note that //FIRST_ROWS// has been deprecated in Oracle 9.2, and is retained for backwards compatibility. Note that //FIRST_ROWS// has been deprecated in Oracle 9.2, and is retained for backwards compatibility.
  
-{{tag>[oracle unix windows deprecated]}} +{{tag>oracle unix windows deprecated}} 
  
 ---------------------------------------- ----------------------------------------
Line 173: Line 175:
 </WRAP> </WRAP>
 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. 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]}} +{{tag>oracle unix windows deprecated}} 
  
 --------------------------------- ---------------------------------
Line 194: Line 196:
  
    
-{{tag>[oracle unix windows obsolete supported]}}+{{tag>oracle unix windows obsolete supported}}
  
  
v5/database/oracle.1674617853.txt.gz · Last modified: by mnewnham