Moodle  2.2.1
http://www.collinsharper.com
Public Member Functions | Data Fields
ADODB_oci8 Class Reference
Inheritance diagram for ADODB_oci8:
Inheritance graph
[legend]

Public Member Functions

 ADODB_oci8 ()
 MetaColumns ($table, $normalize=true)
 Time ()
 _connect ($argHostname, $argUsername, $argPassword, $argDatabasename, $mode=0)
 ServerInfo ()
 _pconnect ($argHostname, $argUsername, $argPassword, $argDatabasename)
 _nconnect ($argHostname, $argUsername, $argPassword, $argDatabasename)
 _affectedrows ()
 IfNull ($field, $ifNull)
 DBDate ($d, $isfld=false)
 BindDate ($d)
 BindTimeStamp ($ts)
 DBTimeStamp ($ts, $isfld=false)
 RowLock ($tables, $where, $col='1 as adodbignore')
 MetaTables ($ttype=false, $showSchema=false, $mask=false)
 MetaIndexes ($table, $primary=FALSE, $owner=false)
 BeginTrans ()
 CommitTrans ($ok=true)
 RollbackTrans ()
 SelectDB ($dbName)
 ErrorMsg ()
 ErrorNo ()
 SQLDate ($fmt, $col=false)
 GetRandRow ($sql, $arr=false)
 SelectLimit ($sql, $nrows=-1, $offset=-1, $inputarr=false, $secs2cache=0)
 UpdateBlob ($table, $column, $val, $where, $blobtype='BLOB')
 UpdateBlobFile ($table, $column, $val, $where, $blobtype='BLOB')
 Execute ($sql, $inputarr=false)
 Prepare ($sql, $cursor=false)
 ExecuteCursor ($sql, $cursorName='rs', $params=false)
 Bind (&$stmt, &$var, $size=4000, $type=false, $name=false, $isOutput=false)
 Param ($name, $type=false)
 Parameter (&$stmt, &$var, $name, $isOutput=false, $maxLen=4000, $type=false)
 _query ($sql, $inputarr=false)
 IsConnectionError ($err)
 _close ()
 MetaPrimaryKeys ($table, $owner=false, $internalKey=false)
 MetaForeignKeys ($table, $owner=false)
 CharMax ()
 TextMax ()
 qstr ($s, $magic_quotes=false)

Data Fields

 $databaseType = 'oci8'
 $dataProvider = 'oci8'
 $replaceQuote = "''"
 $concat_operator = '||'
 $sysDate = "TRUNC(SYSDATE)"
 $sysTimeStamp = 'SYSDATE'
 $metaDatabasesSQL = "SELECT USERNAME FROM ALL_USERS WHERE USERNAME NOT IN ('SYS','SYSTEM','DBSNMP','OUTLN') ORDER BY 1"
 $_stmt
 $_commit = OCI_COMMIT_ON_SUCCESS
 $_initdate = true
 $metaTablesSQL = "select table_name,table_type from cat where table_type in ('TABLE','VIEW') and table_name not like 'BIN\$%'"
 $metaColumnsSQL = "select cname,coltype,width, SCALE, PRECISION, NULLS, DEFAULTVAL from col where tname='%s' order by colno"
 $metaColumnsSQL2
 $_bindInputArray = true
 $hasGenID = true
 $_genIDSQL = "SELECT (%s.nextval) FROM DUAL"
 $_genSeqSQL
 $_dropSeqSQL = "DROP SEQUENCE %s"
 $hasAffectedRows = true
 $random = "abs(mod(DBMS_RANDOM.RANDOM,10000001)/10000000)"
 $noNullStrings = false
 $connectSID = false
 $_bind = false
 $_nestedSQL = true
 $_hasOCIFetchStatement = false
 $_getarray = false
 $leftOuter = ''
 $session_sharing_force_blob = false
 $firstrows = true
 $selectOffsetAlg1 = 1000
 $NLS_DATE_FORMAT = 'YYYY-MM-DD'
 $dateformat = 'YYYY-MM-DD'
 $useDBDateFormatForTextInput = false
 $datetime = false
 $_refLOBs = array()

Detailed Description

Definition at line 55 of file adodb-oci8.inc.php.

Member Function Documentation

_affectedrows ( )

Definition at line 286 of file adodb-oci8.inc.php.

_close ( )

Definition at line 1199 of file adodb-oci8.inc.php.

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

Definition at line 202 of file adodb-oci8.inc.php.

Here is the call graph for this function:

Here is the caller graph for this function:

_nconnect ( $  argHostname,
$  argUsername,
$  argPassword,
$  argDatabasename 
)

Definition at line 281 of file adodb-oci8.inc.php.

Here is the call graph for this function:

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

Definition at line 275 of file adodb-oci8.inc.php.

Here is the call graph for this function:

_query ( $  sql,
$  inputarr = false 
)

Reimplemented in ADODB_oci8po.

Definition at line 1060 of file adodb-oci8.inc.php.

ADODB_oci8 ( )

Definition at line 105 of file adodb-oci8.inc.php.

Here is the caller graph for this function:

BeginTrans ( )

Definition at line 431 of file adodb-oci8.inc.php.

Here is the call graph for this function:

Here is the caller graph for this function:

Bind ( &$  stmt,
&$  var,
$  size = 4000,
$  type = false,
$  name = false,
$  isOutput = false 
)

Definition at line 963 of file adodb-oci8.inc.php.

Here is the call graph for this function:

Here is the caller graph for this function:

BindDate ( $  d)

Definition at line 311 of file adodb-oci8.inc.php.

Here is the call graph for this function:

BindTimeStamp ( $  ts)

Definition at line 319 of file adodb-oci8.inc.php.

Here is the call graph for this function:

CharMax ( )

Definition at line 1291 of file adodb-oci8.inc.php.

CommitTrans ( $  ok = true)

Definition at line 444 of file adodb-oci8.inc.php.

Here is the call graph for this function:

Here is the caller graph for this function:

DBDate ( $  d,
$  isfld = false 
)

Definition at line 298 of file adodb-oci8.inc.php.

Here is the call graph for this function:

Here is the caller graph for this function:

DBTimeStamp ( $  ts,
$  isfld = false 
)

Definition at line 331 of file adodb-oci8.inc.php.

ErrorMsg ( )

Definition at line 472 of file adodb-oci8.inc.php.

ErrorNo ( )

Definition at line 487 of file adodb-oci8.inc.php.

Execute ( $  sql,
$  inputarr = false 
)

Execute SQL

Parameters:
sqlSQL statement to execute, or possibly an array holding prepared statement ($sql[0] will hold sql text)
[inputarr]holds the input data to bind to. Null elements will be set to null.
Returns:
RecordSet or false

Reimplemented in ADODB_oci8po.

Definition at line 791 of file adodb-oci8.inc.php.

Here is the call graph for this function:

Here is the caller graph for this function:

ExecuteCursor ( $  sql,
$  cursorName = 'rs',
$  params = false 
)

Definition at line 908 of file adodb-oci8.inc.php.

Here is the call graph for this function:

GetRandRow ( $  sql,
$  arr = false 
)

Definition at line 582 of file adodb-oci8.inc.php.

IfNull ( $  field,
$  ifNull 
)

Definition at line 292 of file adodb-oci8.inc.php.

IsConnectionError ( $  err)

Definition at line 1173 of file adodb-oci8.inc.php.

MetaColumns ( $  table,
$  normalize = true 
)

Definition at line 112 of file adodb-oci8.inc.php.

Here is the call graph for this function:

MetaForeignKeys ( $  table,
$  owner = false 
)

Definition at line 1251 of file adodb-oci8.inc.php.

Here is the call graph for this function:

MetaIndexes ( $  table,
$  primary = FALSE,
$  owner = false 
)

Definition at line 365 of file adodb-oci8.inc.php.

Here is the call graph for this function:

MetaPrimaryKeys ( $  table,
$  owner = false,
$  internalKey = false 
)

Definition at line 1216 of file adodb-oci8.inc.php.

Here is the call graph for this function:

MetaTables ( $  ttype = false,
$  showSchema = false,
$  mask = false 
)

Definition at line 349 of file adodb-oci8.inc.php.

Here is the call graph for this function:

Param ( $  name,
$  type = false 
)

Definition at line 1014 of file adodb-oci8.inc.php.

Parameter ( &$  stmt,
&$  var,
$  name,
$  isOutput = false,
$  maxLen = 4000,
$  type = false 
)

Definition at line 1035 of file adodb-oci8.inc.php.

Here is the call graph for this function:

Here is the caller graph for this function:

Prepare ( $  sql,
$  cursor = false 
)

Reimplemented in ADODB_oci8po.

Definition at line 868 of file adodb-oci8.inc.php.

Here is the caller graph for this function:

qstr ( $  s,
$  magic_quotes = false 
)

Quotes a string. An example is $db->qstr("Don't bother",magic_quotes_runtime());

Parameters:
sthe string to quote
[magic_quotes]if $s is GET/POST var, set to get_magic_quotes_gpc(). This undoes the stupidity of magic quotes for GPC.
Returns:
quoted string to be sent back to database

Definition at line 1311 of file adodb-oci8.inc.php.

Here is the caller graph for this function:

RollbackTrans ( )

Definition at line 456 of file adodb-oci8.inc.php.

Here is the caller graph for this function:

RowLock ( $  tables,
$  where,
$  col = '1 as adodbignore' 
)

Definition at line 343 of file adodb-oci8.inc.php.

Here is the call graph for this function:

SelectDB ( $  dbName)

Definition at line 467 of file adodb-oci8.inc.php.

SelectLimit ( $  sql,
$  nrows = -1,
$  offset = -1,
$  inputarr = false,
$  secs2cache = 0 
)

Reimplemented in ADODB_oci805.

Definition at line 604 of file adodb-oci8.inc.php.

Here is the call graph for this function:

ServerInfo ( )

Definition at line 267 of file adodb-oci8.inc.php.

SQLDate ( $  fmt,
$  col = false 
)

Definition at line 505 of file adodb-oci8.inc.php.

TextMax ( )

Definition at line 1296 of file adodb-oci8.inc.php.

Time ( )

Definition at line 160 of file adodb-oci8.inc.php.

Here is the call graph for this function:

UpdateBlob ( $  table,
$  column,
$  val,
$  where,
$  blobtype = 'BLOB' 
)

Usage: Store BLOBs and CLOBs

Example: to store $var in a blob

$conn->Execute('insert into TABLE (id,ablob) values(12,empty_blob())'); $conn->UpdateBlob('TABLE', 'ablob', $varHoldingBlob, 'ID=12', 'BLOB');

$blobtype supports 'BLOB' and 'CLOB', but you need to change to 'empty_clob()'.

to get length of LOB: select DBMS_LOB.GETLENGTH(ablob) from TABLE

If you are using CURSOR_SHARING = force, it appears this will case a segfault under oracle 8.1.7.0. Run: $db->Execute('ALTER SESSION SET CURSOR_SHARING=EXACT'); before UpdateBlob() then...

Definition at line 724 of file adodb-oci8.inc.php.

Here is the call graph for this function:

UpdateBlobFile ( $  table,
$  column,
$  val,
$  where,
$  blobtype = 'BLOB' 
)

Usage: store file pointed to by $val in a blob

Definition at line 758 of file adodb-oci8.inc.php.

Here is the call graph for this function:

Field Documentation

$_bind = false

Definition at line 89 of file adodb-oci8.inc.php.

$_bindInputArray = true

Definition at line 73 of file adodb-oci8.inc.php.

$_commit = OCI_COMMIT_ON_SUCCESS

Definition at line 64 of file adodb-oci8.inc.php.

$_dropSeqSQL = "DROP SEQUENCE %s"

Definition at line 84 of file adodb-oci8.inc.php.

$_genIDSQL = "SELECT (%s.nextval) FROM DUAL"

Definition at line 75 of file adodb-oci8.inc.php.

$_genSeqSQL
Initial value:
"
DECLARE
  PRAGMA AUTONOMOUS_TRANSACTION;
BEGIN
        execute immediate 'CREATE SEQUENCE %s START WITH %s';
END;
"

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

$_getarray = false

Definition at line 92 of file adodb-oci8.inc.php.

$_hasOCIFetchStatement = false

Definition at line 91 of file adodb-oci8.inc.php.

$_initdate = true

Definition at line 65 of file adodb-oci8.inc.php.

$_nestedSQL = true

Definition at line 90 of file adodb-oci8.inc.php.

$_refLOBs = array()

Definition at line 101 of file adodb-oci8.inc.php.

$_stmt

Definition at line 63 of file adodb-oci8.inc.php.

$concat_operator = '||'

Definition at line 59 of file adodb-oci8.inc.php.

$connectSID = false

Reimplemented in ADODB_oci805.

Definition at line 88 of file adodb-oci8.inc.php.

$databaseType = 'oci8'

Reimplemented in ADODB_oci8po, and ADODB_oci805.

Definition at line 56 of file adodb-oci8.inc.php.

$dataProvider = 'oci8'

Reimplemented in ADODB_oci8po.

Definition at line 57 of file adodb-oci8.inc.php.

$dateformat = 'YYYY-MM-DD'

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

$datetime = false

Definition at line 100 of file adodb-oci8.inc.php.

$firstrows = true

Definition at line 95 of file adodb-oci8.inc.php.

$hasAffectedRows = true

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

$hasGenID = true

Definition at line 74 of file adodb-oci8.inc.php.

$leftOuter = ''

Definition at line 93 of file adodb-oci8.inc.php.

$metaColumnsSQL = "select cname,coltype,width, SCALE, PRECISION, NULLS, DEFAULTVAL from col where tname='%s' order by colno"

Reimplemented in ADODB_oci8po.

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

$metaColumnsSQL2
Initial value:
"select column_name,data_type,data_length, data_scale, data_precision, 
    case when nullable = 'Y' then 'NULL'
    else 'NOT NULL' end as nulls,
    data_default from all_tab_cols 
  where owner='%s' and table_name='%s' order by column_id"

Definition at line 68 of file adodb-oci8.inc.php.

$metaDatabasesSQL = "SELECT USERNAME FROM ALL_USERS WHERE USERNAME NOT IN ('SYS','SYSTEM','DBSNMP','OUTLN') ORDER BY 1"

Definition at line 62 of file adodb-oci8.inc.php.

$metaTablesSQL = "select table_name,table_type from cat where table_type in ('TABLE','VIEW') and table_name not like 'BIN\$%'"

Reimplemented in ADODB_oci8po.

Definition at line 66 of file adodb-oci8.inc.php.

$NLS_DATE_FORMAT = 'YYYY-MM-DD'

Definition at line 97 of file adodb-oci8.inc.php.

$noNullStrings = false

Definition at line 87 of file adodb-oci8.inc.php.

$random = "abs(mod(DBMS_RANDOM.RANDOM,10000001)/10000000)"

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

$replaceQuote = "''"

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

$selectOffsetAlg1 = 1000

Definition at line 96 of file adodb-oci8.inc.php.

$session_sharing_force_blob = false

Definition at line 94 of file adodb-oci8.inc.php.

$sysDate = "TRUNC(SYSDATE)"

Definition at line 60 of file adodb-oci8.inc.php.

$sysTimeStamp = 'SYSDATE'

Definition at line 61 of file adodb-oci8.inc.php.

$useDBDateFormatForTextInput = false

Definition at line 99 of file adodb-oci8.inc.php.

The documentation for this class was generated from the following file:
 All Data Structures Namespaces Files Functions Variables Enumerations