Function isReadOnlyRoutine

packages/oracledb/src/OracleConnection.ts:38–44

Read-only functions can run on a separate Oracle connection inside an EM transaction — write-ish routines would silently auto-commit.

(routine: Routine)

/** Read-only functions can run on a separate Oracle connection inside an EM transaction — write-ish routines would silently auto-commit. */
function isReadOnlyRoutine(routine: Routine): boolean {
  if (routine.type !== 'function') {
    return false;
  }

  return routine.dataAccess === 'no-sql' || routine.dataAccess === 'reads-sql-data';
}

export class OracleConnection extends AbstractSqlConnection {
  private oraclePool?: oracledb.Pool;