Skip to content

Latest commit

 

History

History
 
 

python

Folders and files

NameName
Last commit message
Last commit date

parent directory

..
CRUD-examples
CRUD-examples
 
 
sql
sql
 
 
AdvancedQueuingNotification.py
AdvancedQueuingNotification.py
 
 
AppContext.py
AppContext.py
 
 
ArrayDMLRowCounts.py
ArrayDMLRowCounts.py
 
 
BatchErrors.py
BatchErrors.py
 
 
BindInsert.py
BindInsert.py
 
 
BindQuery.py
BindQuery.py
 
 
BulkAQ.py
BulkAQ.py
 
 
CQN.py
CQN.py
 
 
CQN2.py
CQN2.py
 
 
CallTimeout.py
CallTimeout.py
 
 
ConnectionPool.py
ConnectionPool.py
 
 
DMLReturningMultipleRows.py
DMLReturningMultipleRows.py
 
 
DRCP.py
DRCP.py
 
 
DatabaseChangeNotification.py
DatabaseChangeNotification.py
 
 
DatabaseShutdown.py
DatabaseShutdown.py
 
 
DatabaseStartup.py
DatabaseStartup.py
 
 
DbmsOutput.py
DbmsOutput.py
 
 
DropSamples.py
DropSamples.py
 
 
Editioning.py
Editioning.py
 
 
GenericRowFactory.py
GenericRowFactory.py
 
 
ImplicitResults.py
ImplicitResults.py
 
 
InsertGeometry.py
InsertGeometry.py
 
 
LastRowid.py
LastRowid.py
 
 
MultiConsumerAQ.py
MultiConsumerAQ.py
 
 
ObjectAQ.py
ObjectAQ.py
 
 
PLSQLCollection.py
PLSQLCollection.py
 
 
PLSQLFunction.py
PLSQLFunction.py
 
 
PLSQLProcedure.py
PLSQLProcedure.py
 
 
PLSQLRecord.py
PLSQLRecord.py
 
 
Query.py
Query.py
 
 
QueryArraysize.py
QueryArraysize.py
 
 
README.md
README.md
 
 
RawAQ.py
RawAQ.py
 
 
RefCursor.py
RefCursor.py
 
 
ReturnLobsAsStrings.py
ReturnLobsAsStrings.py
 
 
ReturnNumbersAsDecimals.py
ReturnNumbersAsDecimals.py
 
 
RowsAsInstance.py
RowsAsInstance.py
 
 
SampleEnv.py
SampleEnv.py
 
 
ScrollableCursors.py
ScrollableCursors.py
 
 
SessionCallback.py
SessionCallback.py
 
 
SessionCallbackPLSQL.py
SessionCallbackPLSQL.py
 
 
SetupSamples.py
SetupSamples.py
 
 
ShardingNumberKey.py
ShardingNumberKey.py
 
 
SodaBasic.py
SodaBasic.py
 
 
SodaBulkInsert.py
SodaBulkInsert.py
 
 
SpatialToGeoPandas.py
SpatialToGeoPandas.py
 
 
Subclassing.py
Subclassing.py
 
 
TransactionGuard.py
TransactionGuard.py
 
 
TypeHandlers.py
TypeHandlers.py
 
 
UniversalRowids.py
UniversalRowids.py
 
 

README.md

This directory contains samples for cx_Oracle.

  1. 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.py

    Alternatively, 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

  2. Run a Python script, for example:

     python Query.py

  3. 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.py

    Alternatively, 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