16 Commits

Author SHA1 Message Date
Anthony Tuininga
4b72d0de02 Rename samples and test files in order to be consistent. 2021-04-23 13:36:00 -06:00
Christopher Jones
5f60401c4a Use aq_administrator_role for AQ samples 2021-03-03 17:12:57 +11:00
Anthony Tuininga
543c1b9d99 Minor tweaks to samples and documentation to take into account recent changes. 2021-01-05 11:20:29 -07:00
Anthony Tuininga
7e7133b09a The value of prefetchrows for REF CURSOR variables is now honored
(https://github.com/oracle/python-cx_Oracle/issues/482).
2020-11-12 14:24:42 -07:00
Anthony Tuininga
3a941687ea Added multiple consumer AQ example. 2020-06-19 10:39:19 -06:00
Anthony Tuininga
952580a565 Adjust samples so that they run unchanged against Oracle Cloud databases:
- administrative user is ADMIN on the Oracle Cloud databases and SYSTEM on
  local databases (SYSDBA is not available on the Oracle Cloud database)
- use dbms_session.sleep() instead of dbms_lock.sleep() where possible
- environment variables CX_ORACLE_SAMPLES_SYSDBA_USER and
  CX_ORACLE_SAMPLES_SYSDBA_PASSWORD are replaced with
  CX_ORACLE_SAMPLES_ADMIN_USER and CX_ORACLE_SAMPLES_ADMIN_PASSWORD
- new environment variable CX_ORACLE_SAMPLES_DRCP_CONNECT_STRING used for
  specifying the connect string to use for DRCP usage
2019-11-13 16:43:07 -07:00
Anthony Tuininga
ee5fe39544 Rename queues and queue tables to be more clear as to which is which. 2019-06-11 19:13:21 -06:00
Anthony Tuininga
d4498cf9e0 Added support for Advanced Queueing RAW queues and bulk enqueue/dequeue. 2019-05-03 13:21:39 -06:00
Anthony Tuininga
81583c224d Reworked samples so that no default passwords are defined anywhere; added
Python script to create sample schemas and drop them in addition to having a
SQL*Plus script.
2019-01-31 10:15:40 -07:00
Anthony Tuininga
b51ed5bc87 Added samples for session callbacks in Python and PL/SQL. 2019-01-23 16:32:29 -07:00
Anthony Tuininga
64f65050a2 Add support (as preview) for SODA. 2018-09-10 11:37:53 -06:00
Anthony Tuininga
211298209b Added support for receiving notifications when AQ messages are available to be
dequeued.
2018-05-29 21:54:06 -06:00
Anthony Tuininga
7b2195c37c Added sample demonstrating the use of REF cursors. 2018-05-18 14:25:20 -06:00
Anthony Tuininga
84ee1301bc Adjust data values to clarify distinction between "parent" and "child" values. 2018-05-18 14:23:54 -06:00
Anthony Tuininga
76f01f0d4c Correct usage. 2017-10-13 19:14:17 -06:00
Anthony Tuininga
340dcb7195 Rework test suite and samples so that they are independent of each other and
so that the SQL scripts used to create/drop schemas are easily adjusted to
use different schema names, if desired. Improve documentation for test suite
and samples.
2017-07-14 16:50:41 -06:00