[ Index ]

PHP Cross Reference of Moodle 1.9.3 [Build 15-Oct-2008]

title

Body

[close]

/lib/adodb/drivers/ -> adodb-oci8.inc.php (summary)

(no description)

File Size: 1525 lines (44 kb)
Included or required:0 times
Referenced: 0 times
Includes or requires: 0 files

Defines 3 classes

ADODB_oci8:: (40 methods):
  ADODB_oci8()
  MetaColumns()
  Time()
  _connect()
  ServerInfo()
  _pconnect()
  _nconnect()
  _affectedrows()
  IfNull()
  DBDate()
  BindDate()
  BindTimeStamp()
  DBTimeStamp()
  RowLock()
  MetaTables()
  MetaIndexes()
  BeginTrans()
  CommitTrans()
  RollbackTrans()
  SelectDB()
  ErrorMsg()
  ErrorNo()
  SQLDate()
  GetRandRow()
  SelectLimit()
  UpdateBlob()
  UpdateBlobFile()
  Execute()
  Prepare()
  ExecuteCursor()
  Bind()
  Param()
  Parameter()
  _query()
  _close()
  MetaPrimaryKeys()
  MetaForeignKeys()
  CharMax()
  TextMax()
  qstr()

ADORecordset_oci8:: (12 methods):
  ADORecordset_oci8()
  Init()
  _initrs()
  _FetchField()
  FetchField()
  MoveNext()
  GetArrayLimit()
  Fields()
  _seek()
  _fetch()
  _close()
  MetaType()

ADORecordSet_ext_oci8:: (2 methods):
  ADORecordSet_ext_oci8()
  MoveNext()

Defines 2 functions

  oci_lob_desc()

Class: ADODB_oci8  - X-Ref

ADODB_oci8()   X-Ref
No description

MetaColumns($table)   X-Ref
No description

Time()   X-Ref
No description

_connect($argHostname, $argUsername, $argPassword, $argDatabasename,$mode=0)   X-Ref
No description

ServerInfo()   X-Ref
No description

_pconnect($argHostname, $argUsername, $argPassword, $argDatabasename)   X-Ref
No description

_nconnect($argHostname, $argUsername, $argPassword, $argDatabasename)   X-Ref
No description

_affectedrows()   X-Ref
No description

IfNull( $field, $ifNull )   X-Ref
No description

DBDate($d)   X-Ref
No description

BindDate($d)   X-Ref
No description

BindTimeStamp($d)   X-Ref
No description

DBTimeStamp($ts)   X-Ref
No description

RowLock($tables,$where,$flds='1 as ignore')   X-Ref
No description

MetaTables($ttype=false,$showSchema=false,$mask=false)   X-Ref
No description

MetaIndexes($table, $primary = FALSE, $owner=false)   X-Ref
No description

BeginTrans()   X-Ref
No description

CommitTrans($ok=true)   X-Ref
No description

RollbackTrans()   X-Ref
No description

SelectDB($dbName)   X-Ref
No description

ErrorMsg()   X-Ref
No description

ErrorNo()   X-Ref
No description

SQLDate($fmt, $col=false)   X-Ref
No description

GetRandRow($sql, $arr = false)   X-Ref
No description

SelectLimit($sql,$nrows=-1,$offset=-1, $inputarr=false,$secs2cache=0)   X-Ref
No description

UpdateBlob($table,$column,$val,$where,$blobtype='BLOB')   X-Ref
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...

UpdateBlobFile($table,$column,$val,$where,$blobtype='BLOB')   X-Ref
Usage:  store file pointed to by $var in a blob


Execute($sql,$inputarr=false)   X-Ref
Execute SQL

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

Prepare($sql,$cursor=false)   X-Ref
No description

ExecuteCursor($sql,$cursorName='rs',$params=false)   X-Ref
No description

Bind(&$stmt,&$var,$size=4000,$type=false,$name=false,$isOutput=false)   X-Ref
No description

Param($name,$type=false)   X-Ref
No description

Parameter(&$stmt,&$var,$name,$isOutput=false,$maxLen=4000,$type=false)   X-Ref
No description

_query($sql,$inputarr)   X-Ref
No description

_close()   X-Ref
No description

MetaPrimaryKeys($table, $owner=false,$internalKey=false)   X-Ref
No description

MetaForeignKeys($table, $owner=false)   X-Ref
No description

CharMax()   X-Ref
No description

TextMax()   X-Ref
No description

qstr($s,$magic_quotes=false)   X-Ref
Quotes a string.
An example is  $db->qstr("Don't bother",magic_quotes_runtime());

param: s            the string to quote
param: [magic_quotes]    if $s is GET/POST var, set to get_magic_quotes_gpc().
return: quoted string to be sent back to database

Class: ADORecordset_oci8  - X-Ref

ADORecordset_oci8($queryID,$mode=false)   X-Ref
No description

Init()   X-Ref
No description

_initrs()   X-Ref
No description

_FetchField($fieldOffset = -1)   X-Ref
No description

FetchField($fieldOffset = -1)   X-Ref
No description

MoveNext()   X-Ref
No description

GetArrayLimit($nrows,$offset=-1)   X-Ref
No description

Fields($colname)   X-Ref
No description

_seek($row)   X-Ref
No description

_fetch()   X-Ref
No description

_close()   X-Ref
No description

MetaType($t,$len=-1)   X-Ref
No description

Class: ADORecordSet_ext_oci8  - X-Ref

ADORecordSet_ext_oci8($queryID,$mode=false)   X-Ref
No description

MoveNext()   X-Ref
No description

Functions
Functions that are not part of a class:

oci_lob_desc($type)   X-Ref
No description



Generated: Wed Jan 14 11:33:29 2009 Cross-referenced by PHPXref 0.7