Skip to main content

Oracle

Connect to and interact with Oracle databases for enterprise data operations and automation.

Overview​

The Oracle package provides database connectivity for Oracle Database. Use it when you need to query data, insert records, execute statements, or perform transactions against Oracle databases.

Key Features​

  • Query Execution - Run SELECT queries and get results
  • Data Modification - INSERT, UPDATE, DELETE operations
  • Transactions - Manage database transactions
  • Table Creation - Create new database tables

Available Nodes​

  • Connect - Establish connection to Oracle database
  • Disconnect - Close database connection
  • Query - Execute SELECT query and return results
  • Non Query - Execute INSERT, UPDATE, DELETE statements
  • Insert - Insert data into a table
  • Create - Create a new database table
  • Start - Begin a database transaction
  • Commit - Commit the current transaction

When to Use This Package​

  • Data Extraction: Query and export data from Oracle
  • Data Entry: Insert automation results into database
  • Report Generation: Pull data for automated reports
  • System Integration: Connect RPA with Oracle backend
  • Database Administration: Create tables, manage data

Connection​

Supports Oracle connection with host, port, service name or SID:

host:port/service_name

Typical Workflow​

  1. Connect with credentials
  2. Query to retrieve data
  3. Process data in your automation
  4. Insert or Non Query to write results
  5. Disconnect when finished

Transaction Support​

For atomic operations:

  1. Start transaction
  2. Perform multiple operations
  3. Commit if all succeed