Norvento oracle db

Doc

Table of Contents

• OracleDB
  • Parameters
  • simpleExecute
    • Parameters
  • simpleExecuteWithErrorControl
    • Parameters
  • complexExecute
    • Parameters
  • cursorExecute
    • Parameters
  • executeMany
    • Parameters
  • formatError
    • Parameters

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