3 V4.22 15 Apr 2004 (c) 2000-2004 John Lim (jlim@natsoft.com.my). All rights reserved.
\r
4 Released under both BSD license and Lesser GPL library license.
\r
5 Whenever there is any discrepancy between the two licenses,
\r
6 the BSD license will take precedence.
\r
8 Latest version is available at http://php.weblogs.com/
\r
10 Oracle data driver. Requires Oracle client. Works on Windows and Unix and Oracle 7 and 8.
\r
12 If you are using Oracle 8, use the oci8 driver which is much better and more reliable.
\r
16 class ADODB_oracle extends ADOConnection {
\r
17 var $databaseType = "oracle";
\r
18 var $replaceQuote = "''"; // string to use to replace quotes
\r
19 var $concat_operator='||';
\r
21 var $_initdate = true; // init date to YYYY-MM-DD
\r
22 var $metaTablesSQL = 'select table_name from cat';
\r
23 var $metaColumnsSQL = "select cname,coltype,width from col where tname='%s' order by colno";
\r
24 var $sysDate = "TO_DATE(TO_CHAR(SYSDATE,'YYYY-MM-DD'),'YYYY-MM-DD')";
\r
25 var $sysTimeStamp = 'SYSDATE';
\r
26 var $connectSID = true;
\r
28 function ADODB_oracle()
\r
32 // format and return date string in database date format
\r
35 if (is_string($d)) $d = ADORecordSet::UnixDate($d);
\r
36 return 'TO_DATE('.adodb_date($this->fmtDate,$d).",'YYYY-MM-DD')";
\r
39 // format and return date string in database timestamp format
\r
40 function DBTimeStamp($ts)
\r
42 if (is_string($ts)) $d = ADORecordSet::UnixTimeStamp($ts);
\r
43 return 'TO_DATE('.adodb_date($this->fmtTimeStamp,$ts).",'RRRR-MM-DD, HH:MI:SS AM')";
\r
47 function BeginTrans()
\r
49 $this->autoCommit = false;
\r
50 ora_commitoff($this->_connectionID);
\r
55 function CommitTrans($ok=true)
\r
57 if (!$ok) return $this->RollbackTrans();
\r
58 $ret = ora_commit($this->_connectionID);
\r
59 ora_commiton($this->_connectionID);
\r
64 function RollbackTrans()
\r
66 $ret = ora_rollback($this->_connectionID);
\r
67 ora_commiton($this->_connectionID);
\r
72 /* there seems to be a bug in the oracle extension -- always returns ORA-00000 - no error */
\r
73 function ErrorMsg()
\r
75 $this->_errorMsg = @ora_error($this->_curs);
\r
76 if (!$this->_errorMsg) $this->_errorMsg = @ora_error($this->_connectionID);
\r
77 return $this->_errorMsg;
\r
83 $err = @ora_errorcode($this->_curs);
\r
84 if (!$err) return @ora_errorcode($this->_connectionID);
\r
89 // returns true or false
\r
90 function _connect($argHostname, $argUsername, $argPassword, $argDatabasename, $mode=0)
\r
92 // G. Giunta 2003/08/13 - This looks danegrously suspicious: why should we want to set
\r
93 // the oracle home to the host name of remote DB?
\r
94 // if ($argHostname) putenv("ORACLE_HOME=$argHostname");
\r
96 if($argHostname) { // code copied from version submitted for oci8 by Jorma Tuomainen <jorma.tuomainen@ppoy.fi>
\r
97 if (empty($argDatabasename)) $argDatabasename = $argHostname;
\r
99 if(strpos($argHostname,":")) {
\r
100 $argHostinfo=explode(":",$argHostname);
\r
101 $argHostname=$argHostinfo[0];
\r
102 $argHostport=$argHostinfo[1];
\r
104 $argHostport="1521";
\r
108 if ($this->connectSID) {
\r
109 $argDatabasename="(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=".$argHostname
\r
110 .")(PORT=$argHostport))(CONNECT_DATA=(SID=$argDatabasename)))";
\r
112 $argDatabasename="(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=".$argHostname
\r
113 .")(PORT=$argHostport))(CONNECT_DATA=(SERVICE_NAME=$argDatabasename)))";
\r
118 if ($argDatabasename) $argUsername .= "@$argDatabasename";
\r
120 //if ($argHostname) print "<p>Connect: 1st argument should be left blank for $this->databaseType</p>";
\r
122 $this->_connectionID = ora_plogon($argUsername,$argPassword);
\r
124 $this->_connectionID = ora_logon($argUsername,$argPassword);
\r
125 if ($this->_connectionID === false) return false;
\r
126 if ($this->autoCommit) ora_commiton($this->_connectionID);
\r
127 if ($this->_initdate) {
\r
128 $rs = $this->_query("ALTER SESSION SET NLS_DATE_FORMAT='YYYY-MM-DD'");
\r
129 if ($rs) ora_close($rs);
\r
136 // returns true or false
\r
137 function _pconnect($argHostname, $argUsername, $argPassword, $argDatabasename)
\r
139 return $this->_connect($argHostname, $argUsername, $argPassword, $argDatabasename, 1);
\r
143 // returns query ID if successful, otherwise false
\r
144 function _query($sql,$inputarr=false)
\r
146 $curs = ora_open($this->_connectionID);
\r
148 if ($curs === false) return false;
\r
149 $this->_curs = $curs;
\r
150 if (!ora_parse($curs,$sql)) return false;
\r
151 if (ora_exec($curs)) return $curs;
\r
158 // returns true or false
\r
161 return @ora_logoff($this->_connectionID);
\r
169 /*--------------------------------------------------------------------------------------
\r
170 Class Name: Recordset
\r
171 --------------------------------------------------------------------------------------*/
\r
173 class ADORecordset_oracle extends ADORecordSet {
\r
175 var $databaseType = "oracle";
\r
178 function ADORecordset_oracle($queryID,$mode=false)
\r
181 if ($mode === false) {
\r
182 global $ADODB_FETCH_MODE;
\r
183 $mode = $ADODB_FETCH_MODE;
\r
185 $this->fetchMode = $mode;
\r
187 $this->_queryID = $queryID;
\r
189 $this->_inited = true;
\r
190 $this->fields = array();
\r
192 $this->_currentRow = 0;
\r
193 $this->EOF = !$this->_fetch();
\r
196 $this->_numOfRows = 0;
\r
197 $this->_numOfFields = 0;
\r
201 return $this->_queryID;
\r
206 /* Returns: an object containing field information.
\r
207 Get column information in the Recordset object. fetchField() can be used in order to obtain information about
\r
208 fields in a certain query result. If the field offset isn't specified, the next field that wasn't yet retrieved by
\r
209 fetchField() is retrieved. */
\r
211 function FetchField($fieldOffset = -1)
\r
213 $fld = new ADOFieldObject;
\r
214 $fld->name = ora_columnname($this->_queryID, $fieldOffset);
\r
215 $fld->type = ora_columntype($this->_queryID, $fieldOffset);
\r
216 $fld->max_length = ora_columnsize($this->_queryID, $fieldOffset);
\r
220 /* Use associative array to get fields array */
\r
221 function Fields($colname)
\r
223 if (!$this->bind) {
\r
224 $this->bind = array();
\r
225 for ($i=0; $i < $this->_numOfFields; $i++) {
\r
226 $o = $this->FetchField($i);
\r
227 $this->bind[strtoupper($o->name)] = $i;
\r
231 return $this->fields[$this->bind[strtoupper($colname)]];
\r
236 $this->_numOfRows = -1;
\r
237 $this->_numOfFields = @ora_numcols($this->_queryID);
\r
241 function _seek($row)
\r
246 function _fetch($ignore_fields=false) {
\r
247 // should remove call by reference, but ora_fetch_into requires it in 4.0.3pl1
\r
248 if ($this->fetchMode & ADODB_FETCH_ASSOC)
\r
249 return @ora_fetch_into($this->_queryID,&$this->fields,ORA_FETCHINTO_NULLS|ORA_FETCHINTO_ASSOC);
\r
251 return @ora_fetch_into($this->_queryID,&$this->fields,ORA_FETCHINTO_NULLS);
\r
254 /* close() only needs to be called if you are worried about using too much memory while your script
\r
255 is running. All associated result memory for the specified result identifier will automatically be freed. */
\r
259 return @ora_close($this->_queryID);
\r
262 function MetaType($t,$len=-1)
\r
264 if (is_object($t)) {
\r
266 $t = $fieldobj->type;
\r
267 $len = $fieldobj->max_length;
\r
270 switch (strtoupper($t)) {
\r
276 if ($len <= $this->blobSize) return 'C';
\r
278 case 'LONG VARCHAR':
\r
282 case 'LONG VARBINARY':
\r
286 case 'DATE': return 'D';
\r
288 //case 'T': return 'T';
\r
290 case 'BIT': return 'L';
\r
293 case 'INTEGER': return 'I';
\r
294 default: return 'N';
\r