Robot Framework连接Oracle数据库报错求助，求提供连接示例

Hey there, let's work through this Oracle connection issue with Robot Framework together! The error "No keyword with the name cx_Oracle" pops up because Robot Framework doesn't recognize raw Python module calls as keywords out of the box. Here's how to fix it and get your database connection up and running:

First, Understand the Root Cause #

Robot Framework operates using predefined or custom keywords, so you can’t directly run cx_Oracle.connect() in your test case like you would in a standard Python script. You need to either use a pre-built Robot library that wraps database operations, or encapsulate cx_Oracle functionality into custom Robot keywords.

Solution 1: Use Robot Framework's DatabaseLibrary (Easiest Approach) #

This is the simplest route since it’s a maintained library that handles database connections (including Oracle via cx_Oracle) out of the box.

Step 1: Install Required Packages #

First, make sure you have both cx_Oracle and the DatabaseLibrary installed:

pip install cx_Oracle robotframework-databaselibrary

Also, ensure you have the Oracle Instant Client configured:

• On Windows: Download the Instant Client, unzip it, and add its folder to your system PATH environment variable.
• On Linux: Set LD_LIBRARY_PATH to point to the Instant Client’s lib directory, or add the path to /etc/ld.so.conf and run ldconfig.

Step 2: Example Robot Test Case #

Here’s a complete example to connect, run a query, and clean up the connection:

*** Settings ***
Library    DatabaseLibrary

*** Test Cases ***
Oracle Connection and Query Test
    # Format: Connect To Database    cx_Oracle    username/password@host:port/service_name
    Connect To Database    cx_Oracle    my_user/my_pass@192.168.1.100:1521/ORCLPDB1
    ${query_result}    Query    SELECT FIRST_NAME, LAST_NAME FROM EMPLOYEES WHERE EMPLOYEE_ID = 100
    Log    Retrieved Employee Data: ${query_result}
    Disconnect From Database

Solution 2: Create a Custom Python Keyword Library #

If you need more control over database operations (like custom error handling or complex workflows), wrap cx_Oracle in a custom Robot library.

Step 1: Write the Custom Library (OracleLibrary.py) #

import cx_Oracle

class OracleLibrary:
    def __init__(self):
        self.db_connection = None

    def connect_to_oracle(self, username, password, dsn_details):
        """Establish connection to Oracle. DSN format: host:port/service_name"""
        self.db_connection = cx_Oracle.connect(username, password, dsn_details)
        return "Successfully connected to Oracle database"

    def run_sql_query(self, sql_statement):
        """Execute a SQL query and return all results"""
        if not self.db_connection:
            raise Exception("No active connection! Call 'Connect To Oracle' first.")
        
        cursor = self.db_connection.cursor()
        cursor.execute(sql_statement)
        results = cursor.fetchall()
        cursor.close()
        return results

    def disconnect_from_oracle(self):
        """Close the active database connection"""
        if self.db_connection:
            self.db_connection.close()
            self.db_connection = None
            return "Disconnected from Oracle successfully"

Step 2: Use the Custom Library in Robot #

*** Settings ***
Library    OracleLibrary    # Ensure OracleLibrary.py is in your test script's directory or Python path

*** Test Cases ***
Custom Oracle Connection Test
    ${connect_msg}    Connect To Oracle    my_user    my_pass    192.168.1.100:1521/ORCLPDB1
    Log    ${connect_msg}
    ${department_employees}    Run SQL Query    SELECT * FROM EMPLOYEES WHERE DEPARTMENT_ID = 50
    Log    Employees in Department 50: ${department_employees}
    ${disconnect_msg}    Disconnect From Oracle
    Log    ${disconnect_msg}

Quick Fix (For Testing Only): Use Execute Python Code #

If you just want to validate the connection without setting up libraries, you can run raw Python code via Robot’s Execute Python Code keyword. This is less maintainable for long-term tests but great for quick checks:

*** Test Cases ***
Quick Oracle Connection Test
    # Establish connection
    ${conn}    Execute Python Code    import cx_Oracle; return cx_Oracle.connect('my_user/my_pass@192.168.1.100:1521/ORCLPDB1')
    # Run count query
    ${cursor}    Execute Python Code    return ${conn}.cursor()
    Execute Python Code    ${cursor}.execute('SELECT COUNT(*) FROM EMPLOYEES')
    ${total_employees}    Execute Python Code    return ${cursor}.fetchone()[0]
    Log    Total Employees in Database: ${total_employees}
    # Cleanup
    Execute Python Code    ${cursor}.close(); ${conn}.close()

内容的提问来源于stack exchange，提问作者mac