4097a37ff2Bump copyright notice into 2019 for changed files.
Anthony Tuininga
2019-01-22 16:00:29 -07:00
ba0d41412fAdded test cases for inserting and fetching XMLType objects as strings.
Anthony Tuininga
2019-01-22 14:28:25 -07:00
2cfdb4037cAdd a note indicating that TABLE%ROWTYPE records can also be used.
Anthony Tuininga
2019-01-22 14:27:43 -07:00
ed88224241Added support for a session callback (written in either PL/SQL or Python) which will be called when the actual tag assigned to a session doesn't match the tag requested.
Anthony Tuininga
2019-01-22 14:25:33 -07:00
b13c998999Timed waits for acquiring a session from a session pool is only available in Oracle 12.2 and higher.
Anthony Tuininga
2019-01-22 14:22:39 -07:00
551204ebcbCorrect documentation on pool.release().
Anthony Tuininga
2019-01-22 14:22:06 -07:00
951e8f4b2bUpdate ODPI-C.
Anthony Tuininga
2019-01-22 11:45:17 -07:00
43a485042fAdd additional check for calling setinputsizes() with an empty dictionary in order to avoid the error "cx_Oracle.ProgrammingError: positional and named binds cannot be intermixed" (https://github.com/oracle/python-cx_Oracle/issues/199).
Anthony Tuininga
2019-01-08 14:41:01 -07:00
b340771c37Rework handling of numbers so that, unless using the NATIVE_INT, NATIVE_FLOAT or NATIVE_DOUBLE types, all numbers are converted to strings and passed through to ODPI-C in all Python versions; improved error message when a value cannot be represented by an Oracle number value; improved test suite to verify that calling executemany() with integers, floats and decimal values intermixed with each other works as expected (https://github.com/oracle/python-cx_Oracle/issues/241).
Anthony Tuininga
2018-12-07 19:16:33 -07:00
ef036cbefcEnsure that all references to TestTempTable use the column names instead of assuming the number of columns (in preparation for adding additional nullable columns for other tests).
Anthony Tuininga
2018-12-03 10:19:22 -07:00
8fbc43ac08Added additional SODA test cases.
Anthony Tuininga
2018-11-29 17:21:36 -07:00
bc89547249Update ODPI-C.
Anthony Tuininga
2018-11-29 17:20:51 -07:00
00de5ea10fHandle case when first call to cursor.executemany() has one or more columns that are always null and a subsequent call to cursor.executemany() has a value other than None in the same column (https://github.com/oracle/python-cx_Oracle/issues/236).
Anthony Tuininga
2018-11-29 17:19:39 -07:00
e4cef63804Add comment which is displayed during the test run.
Anthony Tuininga
2018-11-29 17:19:20 -07:00
7ab01bb1b9Installation tweaks for macOS; replace 12.2 references with 18.3.
Anthony Tuininga
2018-11-16 15:24:50 -07:00
1be0461174Be clearer about the syntax used for connecting to the database as sys.
Anthony Tuininga
2018-11-05 09:53:39 -07:00
7f1bfd1eb3Update ODPI-C.
Anthony Tuininga
2018-11-02 16:29:35 -06:00
1abd09717cCorrect grammar.
Anthony Tuininga
2018-11-02 15:47:37 -06:00
ae8b4f84aaEntries can remain in v$sql_monitor for a period of time so only look at the executing one.
Anthony Tuininga
2018-11-02 15:45:09 -06:00
e988d74363Bump version to 7.1-dev now that changes have been made from version 7.0.
Anthony Tuininga
2018-10-31 09:19:27 -06:00
548440016eAdd support for passing an object type (such as those created by the method connection.gettype()) as the first parameter to cursor.var(), as requested (https://github.com/oracle/python-cx_Oracle/issues/231).
Anthony Tuininga
2018-10-30 16:32:05 -06:00
1fe66420e3Added code to display new support in cx_Oracle 7 for retrieving a collection as a dictionary.
Anthony Tuininga
2018-10-18 11:08:43 -07:00
74d9d71484Use cx_Oracle.connect() in preference to cx_Oracle.Connection() in samples and tests. Although the two are aliases of one another, it makes sense to be consistent and to use the one that the DB API prefers as well.
Anthony Tuininga
2018-09-21 11:05:40 -06:00
20c930e2e0Be more clear about the requirements for use of SODA.
Anthony Tuininga
2018-09-14 11:07:22 -06:00
dfd809b7c8Correct typos.
Anthony Tuininga
2018-09-13 21:16:02 -06:00
39d975193aUpdated for cx_Oracle 7.
Anthony Tuininga
2018-09-13 14:38:20 -06:00
4d368ae980Preparing to release cx_Oracle 7.0.
7.0
Anthony Tuininga
2018-09-13 13:38:37 -06:00
28d6166bb6Emphasize the file location.
Anthony Tuininga
2018-09-13 13:36:35 -06:00
d9be1ec98eUpdates for cx_Oracle 7 and Oracle Client 18.3 as well as some miscellaneous tweaks.
Anthony Tuininga
2018-09-12 15:05:29 -06:00
fc8cfbdf60Improve documentation for SODA.
Anthony Tuininga
2018-09-11 20:50:28 -06:00
f647d738a5Correct documentation now that variables bound to DML returning statements always return an array.
Anthony Tuininga
2018-09-10 15:27:52 -06:00
bc69e784f8Adjust copyright notices to match requirements of Oracle Legal.
Anthony Tuininga
2018-09-10 11:39:51 -06:00
d266d6d0faAdjust sample now that DML returning variables return an array.
Anthony Tuininga
2018-09-10 11:39:11 -06:00
118952b07dUpdate ODPI-C.
Anthony Tuininga
2018-09-10 11:39:03 -06:00
64f65050a2Add support (as preview) for SODA.
Anthony Tuininga
2018-09-10 11:37:53 -06:00
b611246a7bAdd support for getting the contents of a collection as a dictionary where the keys are the indexes of the collection and the values are elements of the collection.
Anthony Tuininga
2018-09-03 10:19:26 -06:00
7946142c88Update ODPI-C.
Anthony Tuininga
2018-09-03 10:19:04 -06:00
30088c6cdbAdded support for closing the session pool.
Anthony Tuininga
2018-09-03 10:17:22 -06:00
c46bc2165eAdjust wording for Oracle Linux yum server.
Anthony Tuininga
2018-08-16 14:09:15 -06:00
effbb09e09Correct links.
Anthony Tuininga
2018-08-08 16:17:54 -06:00
18100ccdf3Standardize GitHub issue template.
Anthony Tuininga
2018-08-06 16:06:27 -06:00
07386a6547Add note indicating that the full version is not available when using client libraries 12.2 or lower with Oracle Database 18 or higher.
Anthony Tuininga
2018-08-06 16:05:55 -06:00
fce6a42c76Add subtitle to macOS section to try to stop the prereq being missed.
Anthony Tuininga
2018-08-06 16:05:17 -06:00
888325989fAdjust documentation now that better error message is produced.
Anthony Tuininga
2018-08-06 16:04:40 -06:00
ea4a9d120eSupport for Python 3.4 has been dropped.
Anthony Tuininga
2018-08-06 15:34:50 -06:00
d1d9b7da30Documentation updates for Oracle Client 18 and a few other tweaks.
Anthony Tuininga
2018-08-06 15:34:23 -06:00
7b66391ea0Update ODPI-C.
Anthony Tuininga
2018-08-06 15:30:18 -06:00
fc3450d48aAdd support for call timeouts available in Oracle 18c and higher.
Anthony Tuininga
2018-07-12 10:46:12 -06:00
dc2601729aRemove __future__ attributes for functionality which is now enabled permanently in cx_Oracle 7: connections as context managers now close the connection and variables in DML returning statements now return an array.
Anthony Tuininga
2018-07-12 10:45:40 -06:00
866df60fbcBump version to 7.0 and use ODPI-C master branch (3.0).
Anthony Tuininga
2018-07-12 10:45:15 -06:00
c832ed10d1Preparing to release cx_Oracle 6.4.1.
6.4.1
Anthony Tuininga
2018-07-09 11:21:02 -06:00
e801579d93Update ODPI-C.
Anthony Tuininga
2018-07-09 11:20:24 -06:00
fee92abe5aIf cursor.setinputsizes() is called without any parameters, do not set the flag indicating that bind variables should be returned since otherwise binding with named arguments will raise the error "cx_Oracle.ProgrammingError: positional and named binds cannot be intermixed" (https://github.com/oracle/python-cx_Oracle/issues/199).
Anthony Tuininga
2018-07-03 13:36:10 -06:00
4f85998a84Bump version in README.
Anthony Tuininga
2018-07-02 16:01:31 -06:00
1a7b7257a7Bump version to 6.4.
6.4
Anthony Tuininga
2018-07-02 13:51:00 -06:00
bc1f7e6eadPreparing to release cx_Oracle 6.4.
Anthony Tuininga
2018-07-02 13:46:59 -06:00
77b853d4fbUpdate ODPI-C.
Anthony Tuininga
2018-06-26 20:31:28 -06:00
e6d5153e43Added additional test cases for heterogeneous pools.
Anthony Tuininga
2018-06-19 11:10:26 -06:00
7adf99f0adAdded support for unsubscribing from events in the database.
Anthony Tuininga
2018-06-19 11:09:40 -06:00
510ab50ba7Remove mention of the next() method which is only there in Python 2.x if the cursor is being used as an iterator and is not actually part of cx_Oracle's code.
Anthony Tuininga
2018-06-19 11:08:04 -06:00
cf1265cb2dUse the non-deprecated function for subscribing to events in the database and note that the subscription ID will always be zero and will be removed in cx_Oracle 7.
Anthony Tuininga
2018-06-19 11:07:30 -06:00
feab53cbffUse unsigned integers instead of signed integers where it makes sense to do so.
Anthony Tuininga
2018-06-19 11:06:58 -06:00
4e53b9074bImprove documentation.
Anthony Tuininga
2018-06-19 11:05:44 -06:00
787fc5b33cUse ODPI-C v2.x branch for cx_Oracle 6.4.
Anthony Tuininga
2018-06-19 11:04:03 -06:00
980f3d491cAdded support for indicating if the subscription is still registered with the database when a notification is received.
Anthony Tuininga
2018-06-19 11:00:53 -06:00
7b9ce90842Bump version.
Anthony Tuininga
2018-06-11 20:20:39 -06:00
42e1663abbAdjust documentation to improve clarity.
Anthony Tuininga
2018-05-29 21:56:37 -06:00
85a0ad3ee3Use the built-in type SYS_REFCURSOR instead of creating a new one.
Anthony Tuininga
2018-05-29 21:55:45 -06:00
c31eef50deCorrect handling of statements and rowids in DML returning statements.
Anthony Tuininga
2018-05-29 21:55:26 -06:00
211298209bAdded support for receiving notifications when AQ messages are available to be dequeued.
Anthony Tuininga
2018-05-29 21:54:06 -06:00
6583cdfc51Update ODPI-C.
Anthony Tuininga
2018-05-29 21:51:50 -06:00
67d374b296Update ODPI-C.
Anthony Tuininga
2018-05-19 21:35:06 -06:00
99866aed94Clarify documentation a bit.
Anthony Tuininga
2018-05-18 14:35:30 -06:00
7b2195c37cAdded sample demonstrating the use of REF cursors.
Anthony Tuininga
2018-05-18 14:25:20 -06:00
52f4e7090cRename sample and adjust documentation in sample to clarify use.
Anthony Tuininga
2018-05-18 14:24:52 -06:00
84ee1301bcAdjust data values to clarify distinction between "parent" and "child" values.
Anthony Tuininga
2018-05-18 14:23:54 -06:00
c8c44ff698Rename sample to match feature name.
Anthony Tuininga
2018-05-18 14:23:08 -06:00
b167c8421eBump version to latest release; add commonly used abbreviation for continuous query notification.
Anthony Tuininga
2018-05-18 10:30:08 -06:00
b9381892a5Added support for timed waits when acquiring a session from a session pool and added support for specifying the timeout and maximum lifetime session of sessions in the pool when the pool is being created.
Anthony Tuininga
2018-05-16 14:09:59 -06:00
62f11ac570Clarify documentation on variables.
Anthony Tuininga
2018-05-16 14:09:33 -06:00
4ec7685f95Added support for grouping notifications from subscriptions.
Anthony Tuininga
2018-05-16 14:09:01 -06:00
bab41ac544Added support for specifying the IP address the subscription should use instead of having the Oracle Client library determine the IP address on its own.
Anthony Tuininga
2018-05-16 14:08:28 -06:00
23fac6841aUpdate ODPI-C.
Anthony Tuininga
2018-05-16 14:08:20 -06:00
005a00c03dAdded additional test cases and corrected test case for ltxid when using 11.2 client.
Anthony Tuininga
2018-05-09 19:36:13 -06:00
756442ee24Added checks on passing invalid parameters to cursor.var(), cursor.arrayvar(), cursor.callfunc() and cursor.setinputsizes().
Anthony Tuininga
2018-05-09 19:35:49 -06:00
f7a9eae0e7Correct formatting.
Anthony Tuininga
2018-05-09 19:35:28 -06:00
2272af1563Add support for specifying an integer for the parameters argument to cursor.executemany(). This allows for batch execution when no parameters are required or when parameters have previously been bound. This replaces cursor.executemanyprepared() which is now deprecated and will be removed in cx_Oracle 7.
Anthony Tuininga
2018-05-09 19:35:00 -06:00
d9c50574f5Added test cases for AQ transformations and trimming collections.
Anthony Tuininga
2018-05-09 19:34:21 -06:00
449d6b8b3cAdd missing import; clarify example.
Anthony Tuininga
2018-05-09 19:33:26 -06:00
96b93adf9cClarify documentation surrounding variable.actualElements.
v6.3.x
Anthony Tuininga
2018-05-07 21:12:03 -06:00