# Oracle Database - Workflow node | Docs - nodulz

Source: https://nodulz.com/docs/nodes/oracle

Language: en

Execute Oracle SQL with bound parameters.

## Usage and specifics

Configure a compatible credential and service query or operation. Response shape depends on the service; inspect it before mapping. Account permissions apply to reads and writes.

Technical type : `oracle`. Runtime : `nodulz`.

## Credentials and prerequisites

- [Oracle Database](/docs/credentials) (`database` / `oracle`). Oracle connection using host, port and service name (Thin mode).

Create credentials in your nodulz instance’s Credentials area, then select them on the node. Availability depends on ownership and sharing. See the [credentials guide](/docs/credentials) for access and rotation.

## Parameters

Names below are technical keys. Defaults are not a ready-to-run configuration: complete fields required by your operation. Paths containing [] describe list items; some fields depend on the selected mode.

| Parameter | Type | Default | Values / limits |
| --- | --- | --- | --- |
| `credentialId` | `string` | `""` | - |
| `query` | `string` | `"SELECT 1 AS OK FROM DUAL"` | - |
| `parameters` | `string` | `"[]"` | - |
| `maxRows` | `number` | `100` | -; ≥ 1, ≤ 10000 |
| `timeout` | `number` | `30` | -; ≥ 1, ≤ 600 |

## Configuration help

| Setting | Purpose and guidance |
| --- | --- |
| `maxRows`<br>Maximum rows | Between 1 and 10,000 rows. The truncated output indicates whether more rows exist. |
| `timeout`<br>Timeout (seconds) | Between 1 and 600 seconds. Cancellation interrupts the running request. |

## Initial configuration

Initial catalog configuration example, to adapt before running. Keep secrets in credentials.

```json
{
  "credentialId": "",
  "query": "SELECT 1 AS OK FROM DUAL",
  "parameters": "[]",
  "maxRows": 100,
  "timeout": 30
}
```

## Verification

Test with representative data. Check node output in the inspector and logs, then use editor mapping for downstream fields. A trigger test with a simulated payload does not validate external service delivery.

See also : [Expressions and data](/docs/expressions), [Executions](/docs/executions), [Node catalog](/docs/nodes).

## Explore further

- [Features - nodulz](https://nodulz.com/product/overview)
- [Node catalog - nodulz](https://nodulz.com/product/catalog)
- [MCP server - nodulz](https://nodulz.com/product/mcp)
- [Pricing - nodulz](https://nodulz.com/pricing)
- [Use cases and workflow automation - nodulz](https://nodulz.com/use-cases)
- [Choose what your workflows can do. - nodulz](https://nodulz.com/compare)
- [Documentation - nodulz](https://nodulz.com/docs)