Updates for cx_Oracle 7 and Oracle Client 18.3 as well as some miscel… · TinyClev/python-cx_Oracle@d9be1ec · GitHub
Skip to content

Commit d9be1ec

Browse files
anthony-tuiningaanthony-tuininga
committed
Updates for cx_Oracle 7 and Oracle Client 18.3 as well as some miscellaneous
tweaks.
1 parent fc8cfbd commit d9be1ec

12 files changed

Lines changed: 148 additions & 112 deletions

samples/tutorial/Python-and-Oracle-Database-12c-Scripting-for-the-Future.html renamed to samples/tutorial/Python-and-Oracle-Database-Scripting-for-the-Future.html

Lines changed: 106 additions & 104 deletions
Large diffs are not rendered by default.

‎samples/tutorial/bind_sdo.py‎

Lines changed: 2 additions & 0 deletions

‎samples/tutorial/connect.py‎

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -1,5 +1,5 @@
11
#------------------------------------------------------------------------------
2-
# connect.py (Section 1.1 and 1.2)
2+
# connect.py (Section 1.2 and 1.3)
33
#------------------------------------------------------------------------------
44

55
#------------------------------------------------------------------------------

‎samples/tutorial/drcp_query.sql‎

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -1,5 +1,5 @@
11
-------------------------------------------------------------------------------
2-
-- drcp_query.sql (Section 2.5)
2+
-- drcp_query.sql (Section 2.4 and 2.5)
33
-------------------------------------------------------------------------------
44

55
/*-----------------------------------------------------------------------------

‎samples/tutorial/query.py‎

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -1,5 +1,5 @@
11
#------------------------------------------------------------------------------
2-
# query.py (Section 1.3)
2+
# query.py (Section 1.4 and 1.5)
33
#------------------------------------------------------------------------------
44

55
#------------------------------------------------------------------------------

‎samples/tutorial/solutions/bind_sdo.py‎

Lines changed: 2 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -50,6 +50,8 @@
5050
cur.execute("insert into testgeometry values (1, :objbv)", objbv = obj)
5151
print("Row added!")
5252

53+
# (Change below here)
54+
5355
# Define a function to dump the contents of an Oracle object
5456
def dumpobject(obj, prefix = " "):
5557
if obj.type.iscollection:

‎samples/tutorial/solutions/connect_pool2.py‎

Lines changed: 2 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -14,7 +14,8 @@
1414
import db_config
1515

1616
pool = cx_Oracle.SessionPool(db_config.user, db_config.pw, db_config.dsn + ":pooled",
17-
min = 2, max = 5, increment = 1, threaded = True)
17+
min = 2, max = 5, increment = 1, threaded = True,
18+
getmode = cx_Oracle.SPOOL_ATTRVAL_WAIT)
1819

1920
def Query():
2021
con = pool.acquire(cclass="PYTHONHOL", purity=cx_Oracle.ATTR_PURITY_SELF)

‎samples/tutorial/solutions/query-2.py‎

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -1,5 +1,5 @@
11
#------------------------------------------------------------------------------
2-
# query.py (Section 1.4)
2+
# query.py (Section 1.5)
33
#------------------------------------------------------------------------------
44

55
#------------------------------------------------------------------------------

‎samples/tutorial/solutions/query.py‎

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -1,5 +1,5 @@
11
#------------------------------------------------------------------------------
2-
# query.py (Section 1.3)
2+
# query.py (Section 1.4 and 1.5)
33
#------------------------------------------------------------------------------
44

55
#------------------------------------------------------------------------------

‎samples/tutorial/solutions/query_scroll.py‎

Lines changed: 29 additions & 0 deletions

0 commit comments

Comments
 (0)