Full index

Package indexes

• OIS
• db_oci8

$AdminEmail

db_oci8::$AdminEmail in oci8_class.php

$AffectedRows

db_oci8::$AffectedRows in oci8_class.php

$appname

db_oci8::$appname in oci8_class.php

AffectedRows

db_oci8::AffectedRows() in oci8_class.php

Returns count of affected rows.

$connectRetries

db_oci8::$connectRetries in oci8_class.php

CheckSharedFolder

CheckSharedFolder() in functions.php

Performs checks if given data folder exists and is writeable.

checkSock

db_oci8::checkSock() in oci8_class.php

Checks if we are already connected to our database.

clearOutputHash

db_oci8::clearOutputHash() in oci8_class.php

Clears the internal output hash array.

Commit

db_oci8::Commit() in oci8_class.php

Commits current transaction.

Connect

db_oci8::Connect() in oci8_class.php

Performs the connection to Oracle.

ConvertSize

ConvertSize() in functions.php

Converts bytes to an appropiate unit (kb,MB etc.).

config.inc.php

config.inc.php in config.inc.php

$database

db_oci8::$database in oci8_class.php

$debug

db_oci8::$debug in oci8_class.php

DBOF_CACHE_QUERY

DBOF_CACHE_QUERY in oci8_class.php

Used for Query Cache (V0.38+)

DBOF_CACHE_STATEMENT

DBOF_CACHE_STATEMENT in oci8_class.php

Used for Query Cache (V0.38+)

DBOF_COLNAME

DBOF_COLNAME in oci8_class.php

These defines are used in DescTable()

DBOF_COLPREC

DBOF_COLPREC in oci8_class.php

These defines are used in DescTable()

DBOF_COLSIZE

DBOF_COLSIZE in oci8_class.php

These defines are used in DescTable()

DBOF_COLTYPE

DBOF_COLTYPE in oci8_class.php

These defines are used in DescTable()

DBOF_DEBUGFILE

DBOF_DEBUGFILE in oci8_class.php

DEBUG: Debug to error_log()

DBOF_DEBUGOFF

DBOF_DEBUGOFF in oci8_class.php

DEBUG: No Debug Info

DBOF_DEBUGSCREEN

DBOF_DEBUGSCREEN in oci8_class.php

DEBUG: Debug on-screen

DBOF_RETURN_ALL_ERRORS

DBOF_RETURN_ALL_ERRORS in oci8_class.php

Connect and error handling (V0.57+).

DBOF_SHOW_ALL_ERRORS

DBOF_SHOW_ALL_ERRORS in oci8_class.php

Connect and error handling (V0.57+).

DBOF_SHOW_NO_ERRORS

DBOF_SHOW_NO_ERRORS in oci8_class.php

Connect and error handling (V0.57+).

DB_ERRORMODE

DB_ERRORMODE in dbdefs.inc.php

Modify default error handling mode if you wish (V1.34+).

DB_NUM_DECIMAL

DB_NUM_DECIMAL in dbdefs.inc.php

DB_NUM_GROUPING

DB_NUM_GROUPING in dbdefs.inc.php

db_oci8

db_oci8::db_oci8() in oci8_class.php

Class Constructor.

db_oci8

db_oci8 in oci8_class.php

OCI8 Database Class.

DB_REGISTER

DB_REGISTER in dbdefs.inc.php

DB_SET_NUMERIC

DB_SET_NUMERIC in dbdefs.inc.php

DescTable

db_oci8::DescTable() in oci8_class.php

Describes a table by returning an array with all table info.

Disconnect

db_oci8::Disconnect() in oci8_class.php

Disconnects from Oracle.

Dumper

Dumper() in functions.php

Simple wrapper for print_r().

dbdefs.inc.php

dbdefs.inc.php in dbdefs.inc.php

$errvars

db_oci8::$errvars in oci8_class.php

Execute

db_oci8::Execute() in oci8_class.php

Executes a prepare()d statement and returns the result.

ExecuteHash

db_oci8::ExecuteHash() in oci8_class.php

Executes a prepare()d statement and returns the result.

FetchResult

db_oci8::FetchResult() in oci8_class.php

Fetches next datarow.

FormatTime

FormatTime() in functions.php

Returns given seconds in HH:MM:SS format.

FreeResult

db_oci8::FreeResult() in oci8_class.php

Frees result obtained by QueryResult().

functions.php

functions.php in functions.php

GetBindVars

db_oci8::GetBindVars() in oci8_class.php

Function extracts all bind vars out of given query.

GetClassVersion

db_oci8::GetClassVersion() in oci8_class.php

Returns version of this class.

GetConnectionHandle

db_oci8::GetConnectionHandle() in oci8_class.php

Returns current connection handle.

getConnectRetries

db_oci8::getConnectRetries() in oci8_class.php

Returns the number of retries in case of connection problems.

getDBID

getDBID() in functions.php

Determines current Database ID to be used.

GetErrorText

db_oci8::GetErrorText() in oci8_class.php

This function tries to get the description for a given error message.

getmicrotime

getmicrotime() in functions.php

Returns current microtime.

getmicrotime

db_oci8::getmicrotime() in oci8_class.php

Returns microtime in format s.mmmmm.

getOutputHash

db_oci8::getOutputHash() in oci8_class.php

Returns the contents of the output_hash variable.

GetQueryCount

db_oci8::GetQueryCount() in oci8_class.php

Returns amount of queries executed by this class.

GetQueryTime

db_oci8::GetQueryTime() in oci8_class.php

Returns amount of time spend on queries executed by this class.

getSQLError

db_oci8::getSQLError() in oci8_class.php

Returns hash with error informations from last query.

$host

db_oci8::$host in oci8_class.php

header.inc.php

header.inc.php in header.inc.php

index.php

index.php in index.php

index2.php

index2.php in index2.php

instance_stats.php

instance_stats.php in instance_stats.php

lock_info.php

lock_info.php in lock_info.php

manageExports.php

manageExports.php in manageExports.php

manageExports_del.php

manageExports_del.php in manageExports_del.php

manageExports_dl.php

manageExports_dl.php in manageExports_dl.php

manager.php

manager.php in manager.php

manager_add.php

manager_add.php in manager_add.php

manager_addNote.php

manager_addNote.php in manager_addNote.php

manager_db.php

manager_db.php in manager_db.php

manager_delDB.php

manager_delDB.php in manager_delDB.php

manager_delNote.php

manager_delNote.php in manager_delNote.php

manager_edit.php

manager_edit.php in manager_edit.php

manager_editNote.php

manager_editNote.php in manager_editNote.php

manager_Notes2db.php

manager_Notes2db.php in manager_Notes2db.php

manager_viewDetails.php

manager_viewDetails.php in manager_viewDetails.php

manager_viewNotes.php

manager_viewNotes.php in manager_viewNotes.php

MAXDB

MAXDB in nocache.php

$no_exit

db_oci8::$no_exit in oci8_class.php

nocache.php

nocache.php in nocache.php

nls_info.php

nls_info.php in nls_info.php

$ORACLE_OBJECT_TYPES

$ORACLE_OBJECT_TYPES in nocache.php

All supported object types of Oracle (V1.34+).

$output_hash

db_oci8::$output_hash in oci8_class.php

oci8_class.php

oci8_class.php in oci8_class.php

OCIAPPNAME

OCIAPPNAME in dbdefs.inc.php

OCIDB_ADMINEMAIL

OCIDB_ADMINEMAIL in dbdefs.inc.php

Set address to be shown in case of an error.

OCIDB_HOST

OCIDB_HOST in dbdefs.inc.php

OCIDB_PASS

OCIDB_PASS in dbdefs.inc.php

OCIDB_SENTMAILONERROR

OCIDB_SENTMAILONERROR in dbdefs.inc.php

Set this define to 1 if you want auto-emails to be sent whenever an

OCIDB_USER

OCIDB_USER in dbdefs.inc.php

OIS_DATA_DIR

OIS_DATA_DIR in config.inc.php

OIS supports exporting of various data elements from within Oracle.

$password

db_oci8::$password in oci8_class.php

pError

pError() in functions.php

Prints out an error string and optionally terminates execution.

Prepare

db_oci8::Prepare() in oci8_class.php

Preparses a query but do not execute it (yet).

PrintDebug

db_oci8::PrintDebug() in oci8_class.php

Handles debug output according to internal debug flag.

printFooter

printFooter() in functions.php

Prints out the standard footer used in OIS.

printFormError

printFormError() in functions.php

Prints out an error message with included Form data.

Print_Error

db_oci8::Print_Error() in oci8_class.php

Prints out an Oracle error.

$querycounter

db_oci8::$querycounter in oci8_class.php

$querytime

db_oci8::$querytime in oci8_class.php

Query

db_oci8::Query() in oci8_class.php

Performs a single row query with Bindvar support.

QueryHash

db_oci8::QueryHash() in oci8_class.php

Performs a single row query with Bindvar support passed as associative hash.

QueryResult

db_oci8::QueryResult() in oci8_class.php

Performs a multirow-query and returns result handle.

QueryResultHash

db_oci8::QueryResultHash() in oci8_class.php

Executes a query with parameters passed as hash values.

ReadSharedFolder

ReadSharedFolder() in functions.php

Reads all available exports in "shared" folder of current directory.

RemoveFromQueryCache

db_oci8::RemoveFromQueryCache() in oci8_class.php

Removes query from cache.

Rollback

db_oci8::Rollback() in oci8_class.php

Rollback current transaction.

$SAPI_type

db_oci8::$SAPI_type in oci8_class.php

$showError

db_oci8::$showError in oci8_class.php

$SITE_VER

$SITE_VER in version.inc.php

The site version string.

$sock

db_oci8::$sock in oci8_class.php

$sqlcache

db_oci8::$sqlcache in oci8_class.php

$sqlcount

db_oci8::$sqlcount in oci8_class.php

$sqlerr

db_oci8::$sqlerr in oci8_class.php

$sqlerrmsg

db_oci8::$sqlerrmsg in oci8_class.php

$stmt

db_oci8::$stmt in oci8_class.php

SaveBLOB

db_oci8::SaveBLOB() in oci8_class.php

Allows to save a file to a binary object field (BLOB).

schemabrowser.php

schemabrowser.php in schemabrowser.php

schemabrowser_showDDL.php

schemabrowser_showDDL.php in schemabrowser_showDDL.php

schemabrowser_tables.php

schemabrowser_tables.php in schemabrowser_tables.php

schemabrowser_tables_export.php

schemabrowser_tables_export.php in schemabrowser_tables_export.php

SearchQueryCache

db_oci8::SearchQueryCache() in oci8_class.php

Searches internal query cache for given statement id.

SendMailOnError

db_oci8::SendMailOnError() in oci8_class.php

Sends an error email.

SetConnectionHandle

db_oci8::SetConnectionHandle() in oci8_class.php

Allows to set internal socket to external value.

setConnectRetries

db_oci8::setConnectRetries() in oci8_class.php

Change the number of retries the class performs in case of connection problems.

SetDebug

db_oci8::SetDebug() in oci8_class.php

Function allows debugging of SQL Queries.

setErrorHandling

db_oci8::setErrorHandling() in oci8_class.php

Allows to set the handling of errors.

setOutputHash

db_oci8::setOutputHash() in oci8_class.php

Use this function to pass output hash data to QueryHash() function.

setPConnect

db_oci8::setPConnect() in oci8_class.php

Sets connection behavour.

setPrefetch

db_oci8::setPrefetch() in oci8_class.php

Allows to set the prefetch value when returning results.

showDBInfo.php

showDBInfo.php in showDBInfo.php

showJobs.php

showJobs.php in showJobs.php

showMemory.php

showMemory.php in showMemory.php

showProcesses.php

showProcesses.php in showProcesses.php

showProcessesDetail.php

showProcessesDetail.php in showProcessesDetail.php

showRedoLogs.php

showRedoLogs.php in showRedoLogs.php

showRollbackSegments.php

showRollbackSegments.php in showRollbackSegments.php

showSQL.php

showSQL.php in showSQL.php

showSQL_Details.php

showSQL_Details.php in showSQL_Details.php

showTablespaces.php

showTablespaces.php in showTablespaces.php

showTSDetails.php

showTSDetails.php in showTSDetails.php

showTuning.php

showTuning.php in showTuning.php

showUsers.php

showUsers.php in showUsers.php

SQLDebug

db_oci8::SQLDebug() in oci8_class.php

Allows to en- or disable the SQL_TRACE feature of Oracle.

SubmitButton

SubmitButton() in functions.php

Prints a Submit button embedded in an own table container.

title.inc.php

title.inc.php in title.inc.php

$usePConnect

db_oci8::$usePConnect in oci8_class.php

$user

db_oci8::$user in oci8_class.php

version.inc.php

version.inc.php in version.inc.php

Version

db_oci8::Version() in oci8_class.php

Returns Oracle Server Version.

viewHistory.php

viewHistory.php in viewHistory.php