Tree @6d879e77-af24-46fb-8da8-d053e0f3750e/upstream (Download .tar.gz)
- ..
- sql
- tutorial
- AdvancedQueuingNotification.py
- AppContext.py
- ArrayDMLRowCounts.py
- BatchErrors.py
- BindInsert.py
- BindQuery.py
- BulkAQ.py
- CallTimeout.py
- ConnectionPool.py
- CQN.py
- CQN2.py
- DatabaseChangeNotification.py
- DatabaseShutdown.py
- DatabaseStartup.py
- DbmsOutput.py
- DMLReturningMultipleRows.py
- DRCP.py
- DropSamples.py
- Editioning.py
- GenericRowFactory.py
- ImplicitResults.py
- InsertGeometry.py
- LastRowid.py
- MultiConsumerAQ.py
- ObjectAQ.py
- PLSQLCollection.py
- PLSQLFunction.py
- PLSQLProcedure.py
- PLSQLRecord.py
- Query.py
- QueryArraysize.py
- RawAQ.py
- README.md
- RefCursor.py
- ReturnLobsAsStrings.py
- ReturnNumbersAsDecimals.py
- RowsAsInstance.py
- SampleEnv.py
- ScrollableCursors.py
- SessionCallback.py
- SessionCallbackPLSQL.py
- SetupSamples.py
- ShardingNumberKey.py
- SodaBasic.py
- SodaBulkInsert.py
- SpatialToGeoPandas.py
- Subclassing.py
- TransactionGuard.py
- TypeHandlers.py
- UniversalRowids.py
This directory contains samples for cx_Oracle.
-
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
-
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.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
History of samples @6d879e77-af24-46fb-8da8-d053e0f3750e/upstream
- Various documentation and tutorial improvements. Anthony Tuininga 3 years ago
- Tutorial improvements. Anthony Tuininga 3 years ago
- Added multiple consumer AQ example. Anthony Tuininga 3 years ago
- Tutorial updates to get ready for the coming weekend's Quest session. Anthony Tuininga 3 years ago
- Remove sample that is only relevant with Python 2. Anthony Tuininga 3 years ago
- Remove remaining references to Python 2 syntax. Anthony Tuininga 3 years ago
- Various documentation and samples improvements. Anthony Tuininga 3 years ago
- Update tutorial links. Anthony Tuininga 4 years ago
- Use with clause when acquiring connections from a pool so that they are Anthony Tuininga 4 years ago
- Added sample demonstrating the use of sharding capabilities. Anthony Tuininga 4 years ago
- Add a second CQN example to demonstrate how to fetch modified rows inside the Anthony Tuininga 4 years ago
- Remove unnecessary imports. Anthony Tuininga 4 years ago
- cx_Oracle 8 when it is released will not support Python 2.7. Anthony Tuininga 4 years ago
- Added a sample demonstrating the use of cursor.lastrowid. Anthony Tuininga 4 years ago
- Adjust samples so that they run unchanged against Oracle Cloud databases: Anthony Tuininga 4 years ago
- Adjust sample to take into account changes made to AQ support. Anthony Tuininga 4 years ago
- Update to new default PDB service name. Anthony Tuininga 4 years ago
- Use most recent default connect string in tutorial. Anthony Tuininga 4 years ago
- Added a SODA section to the tutorial. Anthony Tuininga 4 years ago
- Adjusted tutorial to use new AQ syntax. Anthony Tuininga 4 years ago
- Eliminated deprecation of attribute "id" on subscriptions. It is now populated Anthony Tuininga 4 years ago
- Rename queues and queue tables to be more clear as to which is which. Anthony Tuininga 4 years ago
- Added support for Advanced Queueing RAW queues and bulk enqueue/dequeue. Anthony Tuininga 5 years ago
- For Python 2.7, raw_input is needed to request input; also ensure that Anthony Tuininga 5 years ago
- Added support for SODA bulk insert available in Oracle Client 18.5 and higher. Anthony Tuininga 5 years ago
- Add sample for using the call timeout feature available with cx_Oracle 7.0 and Anthony Tuininga 5 years ago
- The call to cursor.setinputsizes() is not needed for cx_Oracle 6 and higher. Anthony Tuininga 5 years ago
- Reworked samples so that no default passwords are defined anywhere; added Anthony Tuininga 5 years ago
- Added samples for session callbacks in Python and PL/SQL. Anthony Tuininga 5 years ago
- Add a note indicating that TABLE%ROWTYPE records can also be used. Anthony Tuininga 5 years ago