ADODB_oracle Class Reference

Inheritance diagram for ADODB_oracle:

ADOConnection List of all members.

Public Member Functions

 ADODB_oracle ()
 DBDate ($d)
 DBTimeStamp ($ts)
 BeginTrans ()
 CommitTrans ($ok=true)
 RollbackTrans ()
 ErrorMsg ()
 ErrorNo ()
 _connect ($argHostname, $argUsername, $argPassword, $argDatabasename, $mode=0)
 _pconnect ($argHostname, $argUsername, $argPassword, $argDatabasename)
 _query ($sql, $inputarr=false)
 _close ()

Public Attributes

 $databaseType = "oracle"
 $replaceQuote = "''"
 string that represents FALSE for a database
 $concat_operator = '||'
 maximum size of blobs or large text fields (262144 = 256K)-- some db's die otherwise like foxpro
 $_curs
 $_initdate = true
 $metaTablesSQL = 'select table_name from cat'
 $metaColumnsSQL = "select cname,coltype,width from col where tname='%s' order by colno"
 $sysDate = "TO_DATE(TO_CHAR(SYSDATE,'YYYY-MM-DD'),'YYYY-MM-DD')"
 cache for 1 hour
 $sysTimeStamp = 'SYSDATE'
 name of function that returns the current date
 $connectSID = true

Detailed Description

Definition at line 18 of file adodb-oracle.inc.php.


Constructor & Destructor Documentation

ADODB_oracle.ADODB_oracle  ) 
 

Definition at line 30 of file adodb-oracle.inc.php.


Member Function Documentation

ADODB_oracle._close  ) 
 

Definition at line 181 of file adodb-oracle.inc.php.

ADODB_oracle._connect argHostname,
argUsername,
argPassword,
argDatabasename,
mode = 0
 

Definition at line 98 of file adodb-oracle.inc.php.

ADODB_oracle._pconnect argHostname,
argUsername,
argPassword,
argDatabasename
 

Definition at line 151 of file adodb-oracle.inc.php.

ADODB_oracle._query sql,
inputarr = false
 

Definition at line 158 of file adodb-oracle.inc.php.

ADODB_oracle.BeginTrans  ) 
 

Begin a Transaction. Must be followed by CommitTrans() or RollbackTrans().

Returns:
true if succeeded or false if database does not support transactions

Reimplemented from ADOConnection.

Definition at line 50 of file adodb-oracle.inc.php.

ADODB_oracle.CommitTrans ok = true  ) 
 

If database does not support transactions, always return true as data always commited

Parameters:
$ok set to false to rollback transaction, true to commit
Returns:
true/false.

Reimplemented from ADOConnection.

Definition at line 58 of file adodb-oracle.inc.php.

ADODB_oracle.DBDate d  ) 
 

Converts a date "d" to a string that the database can understand.

Parameters:
d a date in Unix date time format.
Returns:
date string in database date format

Reimplemented from ADOConnection.

Definition at line 35 of file adodb-oracle.inc.php.

ADODB_oracle.DBTimeStamp ts  ) 
 

Converts a timestamp "ts" to a string that the database can understand.

Parameters:
ts a timestamp in Unix date time format.
Returns:
timestamp string in database timestamp format

Reimplemented from ADOConnection.

Definition at line 42 of file adodb-oracle.inc.php.

ADODB_oracle.ErrorMsg  ) 
 

Returns:
the last error message

Reimplemented from ADOConnection.

Definition at line 76 of file adodb-oracle.inc.php.

ADODB_oracle.ErrorNo  ) 
 

Returns:
the last error number. Normally 0 means no error.

Reimplemented from ADOConnection.

Definition at line 86 of file adodb-oracle.inc.php.

ADODB_oracle.RollbackTrans  ) 
 

If database does not support transactions, rollbacks always fail, so return false

Returns:
true/false.

Reimplemented from ADOConnection.

Definition at line 67 of file adodb-oracle.inc.php.


Member Data Documentation

ADODB_oracle.$_curs
 

Definition at line 22 of file adodb-oracle.inc.php.

ADODB_oracle.$_initdate = true
 

Definition at line 23 of file adodb-oracle.inc.php.

ADODB_oracle.$concat_operator = '||'
 

maximum size of blobs or large text fields (262144 = 256K)-- some db's die otherwise like foxpro

Reimplemented from ADOConnection.

Definition at line 21 of file adodb-oracle.inc.php.

ADODB_oracle.$connectSID = true
 

Definition at line 28 of file adodb-oracle.inc.php.

ADODB_oracle.$databaseType = "oracle"
 

Reimplemented from ADOConnection.

Definition at line 19 of file adodb-oracle.inc.php.

ADODB_oracle.$metaColumnsSQL = "select cname,coltype,width from col where tname='%s' order by colno"
 

Definition at line 25 of file adodb-oracle.inc.php.

ADODB_oracle.$metaTablesSQL = 'select table_name from cat'
 

Reimplemented from ADOConnection.

Definition at line 24 of file adodb-oracle.inc.php.

ADODB_oracle.$replaceQuote = "''"
 

string that represents FALSE for a database

Reimplemented from ADOConnection.

Definition at line 20 of file adodb-oracle.inc.php.

ADODB_oracle.$sysDate = "TO_DATE(TO_CHAR(SYSDATE,'YYYY-MM-DD'),'YYYY-MM-DD')"
 

cache for 1 hour

Reimplemented from ADOConnection.

Definition at line 26 of file adodb-oracle.inc.php.

ADODB_oracle.$sysTimeStamp = 'SYSDATE'
 

name of function that returns the current date

Reimplemented from ADOConnection.

Definition at line 27 of file adodb-oracle.inc.php.


The documentation for this class was generated from the following file:
Generated on Fri Apr 7 10:48:44 2006 for TYPO3 by  doxygen 1.4.6