code: def test_execute(self, mock_get_db_hook):
      sql = "SELECT * FROM test_table"
      oracle_conn_id = "oracle_default"
      parameters = {"parameter": "value"}
      autocommit = False
      context = "test_context"
      task_id = "test_task_id"
  
      with pytest.warns(
          AirflowProviderDeprecationWarning,
          match="This class is deprecated.*",
      ):
          operator = OracleOperator(
              sql=sql,
              oracle_conn_id=oracle_conn_id,
              parameters=parameters,
              autocommit=autocommit,
              task_id=task_id,
          )
      operator.execute(context=context)
      mock_get_db_hook.return_value.run.assert_called_once_with(
          sql=sql,
          autocommit=autocommit,
          parameters=parameters,
          handler=fetch_all_handler,
          return_last=True,
      )
  
file_path: airflow/tests/providers/oracle/operators/test_oracle.py
imports: from __future__ import annotations
  import random
  import re
  from unittest import mock
  import oracledb
  import pytest
  from airflow.exceptions import AirflowProviderDeprecationWarning
  from airflow.models import TaskInstance
  from airflow.providers.common.sql.hooks.sql import fetch_all_handler
  from airflow.providers.oracle.hooks.oracle import OracleHook
  from airflow.providers.oracle.operators.oracle import OracleOperator, OracleStoredProcedureOperator
label_desc: Use image node_id 1 for calling the TestOracleOperator obj's underlying member method code with example usage: obj.test_execute(mock_get_db_hook) without return types