Class OracleDb

constructor

• new OracleDb(useArrayFormat?: boolean): OracleDb

  Construct a new OracleDb object for connecting and querying Oracle Database.

  Parameters

  • OptionaluseArrayFormat: boolean

    if set to true, OUT_FORMAT_ARRAY will be used as the default out format for SQL results, otherwise OUT_FORMAT_OBJECT will be used.

  Returns OracleDb

ARRAY

BIND_IN

BIND_INOUT

BIND_OUT

Connection

DATE

DB_TYPE_BINARY_DOUBLE

DB_TYPE_BINARY_FLOAT

DB_TYPE_BINARY_INTEGER

DB_TYPE_BLOB

DB_TYPE_BOOLEAN

DB_TYPE_CHAR

DB_TYPE_CLOB

DB_TYPE_DATE

DB_TYPE_INTERVAL_DS

DB_TYPE_INTERVAL_YM

DB_TYPE_JSON

DB_TYPE_LONG

DB_TYPE_LONG_RAW

DB_TYPE_NCHAR

DB_TYPE_NCLOB

DB_TYPE_NUMBER

DB_TYPE_NVARCHAR

DB_TYPE_OBJECT

DB_TYPE_RAW

DB_TYPE_ROWID

DB_TYPE_TIMESTAMP

DB_TYPE_TIMESTAMP_LTZ

DB_TYPE_TIMESTAMP_TZ

DB_TYPE_UROWID

DB_TYPE_VARCHAR

DB_TYPE_VECTOR

DEFAULT

FLOAT32ARRAY

FLOAT64ARRAY

INT8ARRAY

NUMBER

OBJECT

ORACLE_BLOB

ORACLE_CLOB

ORACLE_DATE

ORACLE_INTERVAL_DS

ORACLE_INTERVAL_YM

ORACLE_NUMBER

ORACLE_TIMESTAMP

ORACLE_TIMESTAMP_TZ

OracleDb

OUT_FORMAT_ARRAY

OUT_FORMAT_OBJECT

parameters

ResultSet

SODA_COLL_MAP_MODE

SodaCollection

SodaDatabase

SodaDocument

SodaDocumentCursor

SodaOperation

SparseVector

STMT_TYPE_ALTER

STMT_TYPE_BEGIN

STMT_TYPE_CALL

STMT_TYPE_COMMIT

STMT_TYPE_CREATE

STMT_TYPE_DECLARE

STMT_TYPE_DELETE

STMT_TYPE_DROP

STMT_TYPE_EXPLAIN_PLAN

STMT_TYPE_INSERT

STMT_TYPE_MERGE

STMT_TYPE_ROLLBACK

STMT_TYPE_SELECT

STMT_TYPE_UNKNOWN

STMT_TYPE_UPDATE

STRING

UINT8ARRAY

extendedMetaData

• get extendedMetaData(): boolean

  Returns boolean

• set extendedMetaData(value: boolean): void

  Parameters

  • value: boolean

  Returns void

fetchArraySize

• get fetchArraySize(): number

  Returns number

• set fetchArraySize(value: number): void

  Parameters

  • value: number

  Returns void

fetchAsPlsqlWrapper

• get fetchAsPlsqlWrapper(): number[]

  Returns number[]

• set fetchAsPlsqlWrapper(value: number[]): void

  Parameters

  • value: number[]

  Returns void

fetchAsString

• get fetchAsString(): number[]

  Returns number[]

• set fetchAsString(value: number[]): void

  Parameters

  • value: number[]

  Returns void

fetchTypeHandler

• get fetchTypeHandler(): FetchTypeHandler

  Returns FetchTypeHandler

  Since

  Oracle 23.7

• set fetchTypeHandler(value: FetchTypeHandler): void

  Parameters

  • value: FetchTypeHandler

  Returns void

  Since

  Oracle 23.7

maxRows

• get maxRows(): number

  Returns number

• set maxRows(value: number): void

  Parameters

  • value: number

  Returns void

outFormat

• get outFormat(): number

  Returns number

• set outFormat(value: number): void

  Parameters

  • value: number

  Returns void

defaultConnection

• defaultConnection(): IConnection

  Returns the default connection object for executing SQL queries in the Oracle Database using mle-js-oracledb. Note that with MLE, because JavaScript is executed directly in the database, there is no need to establish a specific connection, which is why the default connection object should be used.

  Returns IConnection

  default connection object for executing SQL queries with mle-js-oracledb.