anthony-tuininga Added support for indicating if the subscription is still registered …
…with the

database when a notification is received.
Latest commit 980f3d4 Jun 19, 2018
Permalink
..
Failed to load latest commit information.
sql Added support for receiving notifications when AQ messages are availa… May 30, 2018
tutorial Modified the solutions of the HoL for Collaborate (#170) Apr 21, 2018
AdvancedQueuing.py Added support for receiving notifications when AQ messages are availa… May 30, 2018
AdvancedQueuingNotification.py Added support for receiving notifications when AQ messages are availa… May 30, 2018
AppContext.py Rework test suite and samples so that they are independent of each ot… Jul 14, 2017
ArrayDMLRowCounts.py Adjust data values to clarify distinction between "parent" and "child… May 18, 2018
BatchErrors.py Adjust data values to clarify distinction between "parent" and "child… May 18, 2018
BindInsert.py Added samples that were originally created for Open World 2016. Jul 14, 2017
BindQuery.py Added samples that were originally created for Open World 2016. Jul 14, 2017
CQN.py Added support for indicating if the subscription is still registered … Jun 19, 2018
DMLReturningMultipleRows.py Rework test suite and samples so that they are independent of each ot… Jul 14, 2017
DRCP.py Correct name of data dictionary view for DRCP sample. Nov 18, 2017
DatabaseChangeNotification.py Added support for indicating if the subscription is still registered … Jun 19, 2018
DatabaseShutdown.py Add comment to each sample indicating minimum version of cx_Oracle th… Mar 20, 2017
DatabaseStartup.py Add comment to each sample indicating minimum version of cx_Oracle th… Mar 20, 2017
Editioning.py Add missing import; clarify example. May 10, 2018
GenericRowFactory.py Added samples that were originally created for Open World 2016. Jul 14, 2017
ImplicitResults.py Rework test suite and samples so that they are independent of each ot… Jul 14, 2017
InsertGeometry.py Rework test suite and samples so that they are independent of each ot… Jul 14, 2017
PLSQLCollection.py Added samples that were originally created for Open World 2016. Jul 14, 2017
PLSQLFunction.py Added samples that were originally created for Open World 2016. Jul 14, 2017
PLSQLProcedure.py Added samples that were originally created for Open World 2016. Jul 14, 2017
PLSQLRecord.py Added samples that were originally created for Open World 2016. Jul 14, 2017
Query.py Added samples that were originally created for Open World 2016. Jul 14, 2017
QueryArraysize.py Added samples that were originally created for Open World 2016. Jul 14, 2017
README.md Various improvements to installation documentation. Jan 30, 2018
RefCursor.py Added sample demonstrating the use of REF cursors. May 18, 2018
ReturnLobsAsStrings.py Rename sample and adjust documentation in sample to clarify use. May 18, 2018
ReturnNumbersAsDecimals.py Simplify sample for returning numbers as decimal objects. Oct 25, 2017
ReturnUnicode.py Rework test suite and samples so that they are independent of each ot… Jul 14, 2017
RowsAsInstance.py Rework test suite and samples so that they are independent of each ot… Jul 14, 2017
SampleEnv.py Change default connectstring to localhost/orclpdb to be consistent wi… Aug 8, 2017
ScrollableCursors.py Rework test suite and samples so that they are independent of each ot… Jul 14, 2017
SpatialToGeoPandas.py Add a more explicit note about the dependency on GeoPandas. Apr 30, 2018
Subclassing.py Adjust data values to clarify distinction between "parent" and "child… May 18, 2018
Threads.py Rework test suite and samples so that they are independent of each ot… Jul 14, 2017
TransactionGuard.py Remove unnecessary line. Nov 18, 2017
TypeHandlers.py Rework test suite and samples so that they are independent of each ot… Jul 14, 2017
UniversalRowids.py Rework test suite and samples so that they are independent of each ot… Jul 14, 2017

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 SQL script sql/SetupSamples.sql. The syntax is:

     sqlplus / as sysdba @sql/SetupSamples.sql
    

    The script will create users pythondemo and pythoneditions and will create an edition called python_e1.

    If you wish to change the names of the users or the name of the edition you can edit the file sql/SampleEnv.sql. You will also need to edit the file SampleEnv.py or set environment variables as documented in it.

  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 SQL script sql/DropSamples.sql. The syntax is

     sqlplus / as sysdba @sql/DropSamples.sql