These are examples for the cx_Oracle driver.
Download and install from PyPI or issue the command:
python -m pip install cx_Oracle --upgrade
Documentation Issues and questions
-
The schemas and SQL objects that are referenced in the samples can be created by running the Python script SetupSamples.py. The script requires SYSDBA privileges and will prompt for these credentials as well as the names of the schemas and edition that will be created, unless a number of environment variables are set as documented in the Python script SampleEnv.py. Run the script using the following command:
python SetupSamples.pyAlternatively, the SQL script can be run directly via SQL*Plus, which will always prompt for the names of the schemas and edition that will be created.
sqlplus sys/syspassword@hostname/servicename @sql/SetupSamples.sql -
Run a Python script, for example:
python Query.py -
After running cx_Oracle samples, the schemas and SQL objects can be dropped by running the Python script DropSamples.py. The script requires SYSDBA privileges and will prompt for these credentials as well as the names of the schemas and edition that will be dropped, unless a number of environment variables are set as documented in the Python script SampleEnv.py. Run the script using the following command:
python DropSamples.pyAlternatively, the SQL script can be run directly via SQL*Plus, which will always prompt for the names of the schemas and edition that will be dropped.
sqlplus sys/syspassword@hostname/servicename @sql/DropSamples.sql