ADODB_oracle Class Reference

Inheritance diagram for ADODB_oracle:

[legend]

Collaboration diagram for ADODB_oracle:

[legend]

List of all members.

Public Member Functions
	ADODB_oracle ()
	DBDate ($d)
	DBTimeStamp ($ts)
	BindDate ($d)
	BindTimeStamp ($d)
	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')"
	Use 'true' to store the item compressed (uses zlib).
	$sysTimeStamp = 'SYSDATE'
	name of function that returns the current date
	$connectSID = true

---

Detailed Description

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

---

Member Function Documentation

ADODB_oracle.ADODB_oracle

(

)

Definition at line 30 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.

References ADORecordSet.UnixDate().

Here is the call graph for this function:

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.

References ADORecordSet.UnixTimeStamp().

Here is the call graph for this function:

ADODB_oracle.BindDate

(

$

d

)

Reimplemented from ADOConnection.

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

References ADOConnection.DBDate().

Here is the call graph for this function:

ADODB_oracle.BindTimeStamp

(

$

d

)

Reimplemented from ADOConnection.

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

References ADOConnection.DBTimeStamp().

Here is the call graph for this function:

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 68 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 76 of file adodb-oracle.inc.php.

References $ok, and RollbackTrans().

Here is the call graph for this function:

ADODB_oracle.RollbackTrans

(

)

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

Returns:

true/false.

Reimplemented from ADOConnection.

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

Referenced by CommitTrans().

ADODB_oracle.ErrorMsg

(

)

Returns:

the last error message

Reimplemented from ADOConnection.

Definition at line 94 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 104 of file adodb-oracle.inc.php.

ADODB_oracle._connect	(	$	argHostname,
		$	argUsername,
		$	argPassword,
		$	argDatabasename,
		$	mode = 0
	)

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

References $rs, and _query().

Referenced by _pconnect().

Here is the call graph for this function:

ADODB_oracle._pconnect	(	$	argHostname,
		$	argUsername,
		$	argPassword,
		$	argDatabasename
	)

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

References _connect().

Here is the call graph for this function:

ADODB_oracle._query	(	$	sql,
		$	inputarr = false
	)

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

References $sql.

Referenced by _connect().

ADODB_oracle._close

(

)

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

---

Member Data Documentation

ADODB_oracle.$databaseType = "oracle"

Reimplemented from ADOConnection.

Definition at line 19 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.$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.$_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.$metaTablesSQL = 'select table_name from cat'

Reimplemented from ADOConnection.

Definition at line 24 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.$sysDate = "TO_DATE(TO_CHAR(SYSDATE,'YYYY-MM-DD'),'YYYY-MM-DD')"

Use 'true' to store the item compressed (uses zlib).

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.

ADODB_oracle.$connectSID = true

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

---

The documentation for this class was generated from the following file:

• typo3/sysext/adodb/adodb/drivers/adodb-oracle.inc.php