@norvento/db.oracle

oracle-db

Usage no npm install needed!

<script type="module">
  import norventoDbOracle from 'https://cdn.skypack.dev/@norvento/db.oracle';
</script>

README

Norvento oracle db

Doc

Table of Contents

OracleDB

OracleDB

OracleDB

Parameters

dbconfig {user: string, password: string, connectString: string, poolMax: number, poolMin: number, poolIncrement: number, poolTimeout: number}

simpleExecute

Executes the given sql string

Parameters

sql string the sql to execute
bindParams Object object with the sql params
options Object object with options

simpleExecuteWithErrorControl

Executes the given sql

Parameters

sql string the sql to execute
bindParams Object object with the sql params
options Object object with options
Throws DBError

complexExecute

Executes the sql and returns a complex response

Parameters

sql string the sql to execute
bindParams Object object with the sql params
options Object object with options

cursorExecute

Executes the sql for a cursor type param

Parameters

sql string the sql to execute
bindParams Object object with the sql params
options Object object with options

executeMany

Executes the sql for each of the rows of the insertRows params

Parameters

sql string the sql to execute
insertRows
options Object object with options

formatError

Formats the given db error

Parameters

error Error