$root.$sessions.ORACLE8

Parent: $root.$sessions

Properties

Object specific
$authmode The authentication mode to be used with this connection
$binaryfloat If kTrue, Omnis Number floating dp columns are mapped to BINARY_FLOAT
$binarytoblob If true, Omnis binary fields will be mapped to BLOB columns. If false, the LONG RAW data type is used
$booltonum If true, Omnis boolean fields will be mapped to NUMBER(1,0)
$bytesreceived The number of bytes received through the session object since logon. Assigning to this property resets the value to zero.
$bytessent The number of bytes sent through the session object since logon. Assigning to this property resets the value to zero.
$clientversion Version number of the connected client library
$codepage The code page used to interpret non-Unicode character data, a kUni… constant (see codepage constants)
$commitdelay The delay (in milliseconds) between each commit retry
$commitretries The number of times a commit operation will retry before conceding
$credentials Specifies the type of credentials to use for establishing the user session; kCredRDBMS or kCredEXT
$datetype The Oracle data type used by $createnames() & $coltext() for Omnis Datetime fields
$debugfile If assigned, the DAM writes debug information to the specified file
$debuglevel Specifies the level of debug information required
$debugsize The maximum size of debug file generated before truncation occurs. Assigning zero disables truncation.
$emptyasnull If true, empty strings are inserted as NULL. If false, empty strings are inserted as chr(0)
$encoding The Unicode encoding used by the database (see encoding constants) kSessionEncodingAnsi kSessionEncodingUtf16 kSessionEncodingUtf32 kSessionEncodingUtf8
$falsetext The text inserted when Omnis boolean (kFalse) fields are mapped to VARCHAR2
$fetch64bitints If kTrue, 64-bit integers are fetched into 64-bit Integer fields. If kFalse, they are fetched as 32-bit Integers and truncated accordingly
$filedirectory The directory on the local filesystem where oversized CLOBs, BLOBs & BFILEs will be written
$filethreshold The size in bytes above which CLOBs, BLOBs & BFILEs are no longer returned directly but instead written as files
$internalcharmapping If true (default), character mapping to/from the Omnis character set is enabled
$longchartoclob If true, Omnis character fields > $maxvarchar2 will be mapped to CLOB columns. If false, the LONG data type is used
$maxvarchar2 Threshold above which character columns are mapped to LONG/CLOB
$nationaltonclob If true, Omnis national fields > $maxvarchar2 will be mapped to NCLOB. Character fields > $maxvarchar2 will be mapped to CLOB
$nationaltonvarchar If true, Omnis national fields <= $maxvarchar2 will be mapped to NVARCHAR2. Character fields <= $maxvarchar2 will be mapped to VARCHAR2
$nativewarncode Code of reported warning
$nativewarntext Warning message
$newpassword If set, DAM will attempt to change the user's (expired) password during $logon()
$nullasempty If true, nulls retrieved from Oracle will be treated as empty
$querytimeout The time in seconds before an executing statement times-out (Linux only)
$quotedidentifier If kTrue, table instances and session methods will generate quoted column & table name identifiers
$timezone The session timezone- used to modify incoming/outgoing timestamps containing time zone attributes
$trailingspaces If false, trailing spaces on data being inserted are stripped
$truetext The text inserted when Omnis boolean (kTrue) fields are mapped to VARCHAR2
$unicode If kTrue, Unicode data types/mappings are used. If kFalse, DAM reverts to ANSI behavior
$useprecision If true, DAM attempts to map Oracle Number types to Omnis number (dp)
Standard $allowstransactions $apiversion $autobegintran $blobsize $charmap $commitmode $damname $defaultdate $emptydateisnull $errorcode $errortext$hostname $ident $lobchunksize $lobthreshold $maptable $name $nativeerrorcode $nativeerrorpending $nativeerrortext $password $rollbackmode$sessionobject $sessionobjref $sqldecimalseparator $sqlstripspaces $sqlthousandseparator $state $transactionmode $username $version

Methods

Object specific
$endproxy Terminates a proxy session
$newstatement $newstatement([cStatementname]) Creates and returns a new dynamic instance of a statement object for the session; typically used to return a new statement object to an object variable with no subtype specified
ORACLE8 statement object
$newstatementref $newstatementref([cStatementname]) Creates and returns a new dynamic instance of a statement object for the session, to be used with an Object reference variable; typically used to return a new statement to an object reference variable
ORACLE8 statement object
$proxyas Creates a proxy session based on the current connection
Standard $begin $clear $coltext $commit $createnames $insertnames $logoff $logon $makeschema $nextnativeerror $rollback $rpcdefine $selectnames $updatenames$wherenames