Oracle List Schemas
Lists all accessible schemas in an Oracle database using the configured Oracle credentials. It loads credentials, calls the Oracle service to retrieve schema names, and returns formatted outputs including human-readable text and structured JSON.
Usage
Use this node when you need to discover which schemas are available in an Oracle instance before querying tables or building data workflows. Typically placed early in a database workflow to guide subsequent table discovery or query-building steps.
| Field | Required | Type | Description | Example |
|---|
| credentials_path | True | STRING | Path or reference to the saved Oracle credentials. Must match the 'oracle' credential template. | /configs/credentials/oracle.json |
| timeout | True | INT | Maximum time in seconds to wait for the Oracle service to respond. | 60 |
Outputs
| Field | Type | Description | Example |
|---|
| text | TEXT | Readable summary listing the Oracle schemas. | Oracle Schemas: HR, SYS, SYSTEM, APP_USER |
| json | JSON | Structured data containing the list of schemas and any metadata returned by the service. | {"schemas": ["HR", "SYS", "SYSTEM", "APP_USER"], "count": 4} |
| html | HTML | HTML-formatted table or list of the schemas (may be empty if not requested by the service). | |
| xlsx | XLSX | Spreadsheet export of the schemas (if generated by the service). | |
| pdf | PDF | PDF export of the schemas (if generated by the service). | |
Important Notes
- Credentials: This node requires valid Oracle credentials configured under the 'oracle' credential template.
- Permissions: The connected user must have sufficient privileges to list schemas; results are limited to schemas the user can access.
- Timeouts: Large instances or network latency may require increasing the timeout value.
- Output formats: Text and JSON are always provided; HTML, XLSX, and PDF may depend on service capabilities or configuration.
- No additional parameters: This node does not take schema filters; it returns all accessible schemas.
Troubleshooting
- Authentication failed: Verify credentials_path points to a valid Oracle credential file and that username/password and connection details are correct.
- No schemas returned: Ensure the user has permissions to view schemas. Try a different account with broader access.
- Timeout errors: Increase the timeout input and verify network connectivity to the Oracle service and database.
- Service unavailable: Confirm the Oracle data service is running and reachable from your environment.
- Partial results or permission errors: Check Oracle roles and grants; some system schemas may be restricted.
