Oracle List Tables
Lists all tables available in a specified Oracle schema using stored Oracle credentials. If no schema name is provided, it lists tables from the current user’s default schema. Returns a readable summary along with structured data for downstream automation.
Usage
Use this node when you need to discover what tables exist in an Oracle database before exploring columns, building queries, or creating joins. Typical workflows place this node before a table-info node or a visual/assisted query builder to guide selection.
| Field | Required | Type | Description | Example |
|---|
| credentials_path | True | CREDENTIALS | Path or reference to the saved Oracle credential set to authenticate against the database. | |
| timeout | False | INT | Maximum number of seconds to wait for the request before timing out. | 60 |
| schema_name | True | STRING | Oracle schema to list tables from. Leave empty to use the current user’s schema. | HR |
Outputs
| Field | Type | Description | Example |
|---|
| text | STRING | Human-readable summary of the tables found in the target schema. | Oracle Tables in Schema: HR - EMPLOYEES - DEPARTMENTS - LOCATIONS |
| json | STRING | Structured JSON string of the result, suitable for downstream parsing. | {"tables": ["EMPLOYEES", "DEPARTMENTS", "LOCATIONS"]} |
| html | STRING | Optional HTML representation of the result (may be empty depending on formatting). | |
| xlsx | STRING | Optional XLSX content or reference for tabular export (may be empty depending on formatting). | |
| pdf | STRING | Optional PDF content or reference for export (may be empty depending on formatting). | |
Important Notes
- Leaving schema_name empty will list tables from the current authenticated user’s default schema.
- Valid Oracle credentials must be provided via credentials_path; insufficient privileges may result in empty or partial results.
- The timeout value controls how long the operation waits for the service to respond.
- Output formats beyond text and JSON may be empty depending on configuration and availability of export formatting.
Troubleshooting
- No tables returned: Confirm the schema_name is correct and the user has privileges to view tables in that schema.
- Authentication or authorization error: Verify the credentials file at credentials_path and that it matches the required Oracle environment.
- Request timed out: Increase the timeout value or check network connectivity and database responsiveness.
- Unexpected JSON parse issues downstream: Use the json output field rather than parsing the text output.
