Disconnect
Closes and disconnects from an Oracle database connection.
Common Properties
- Name - The custom name of the node.
- Color - The custom color of the node.
- Delay Before (sec) - Waits in seconds before executing the node.
- Delay After (sec) - Waits in seconds after executing node.
- Continue On Error - Automation will continue regardless of any error. The default value is false.
info
If the ContinueOnError property is true, no error is caught when the project is executed, even if a Catch node is used.
Inputs
- Connection Id - The ID of the connection to disconnect.
How It Works
The Disconnect node closes an Oracle database connection by:
- Validating the provided Connection Id
- Looking up the connection in the shared connections dictionary
- Closing the database connection
- Removing the connection from the connections dictionary
Error Handling
The node will return specific errors in the following cases:
- Empty or invalid Connection Id
- Connection ID not found in the connections dictionary
Usage Notes
- The connection must have been previously established using the Connect node
- The connection ID must be valid and correspond to an active connection
- After disconnecting, the connection ID is no longer valid for other database operations
- It's important to disconnect from connections when they are no longer needed to free up resources