[DB-SIG] DCOracle2 Beta1 Announcement
Matthew T. Kromer
Tue, 5 Jun 2001 13:59:07 -0400
This is my announcment for DCOracle2 Beta 1; while the bulk text below is
aimed at Zope users, the DCOracle2 module should be fully utilizable for any
DCOracle2 is a replacement for DCOracle, written primarily in C. DCOracle 1
uses OCI 7 bindings for most Oracle calls, with OCI 8 mixed in for LOB
support. Oracle 8i disallows mixing of calls within a statement, and so
breaks LOB support. DCO2 uses entirely OCI 8 calls, and thus can use LOBs.
New in this Release
Stored procedure input works properly, cycles in stored procedures removed.
Stored procedures now have meaningful docstrings (describing their
parameters). Type coercion change from a tuple kludge to a TypeCoercion
object. Set ability (and default) to do static binding for BindingArrays,
working around dynamic fetch occasional NULL bug on Linux. Batch
executemany(). Add backward compatable dbiRaw and execute modes.
Nested Cursors, e.g. SELECT ENAME, CURSOR(SELECT ENAME FROM EMP WHERE
MGR=7908) FROM EMP WHERE EMPNO=7908). API 2.0 type objects. Add trim() to
LobLocators. Wrap LOB permissions for Zope in ZOracleDA. Change result on
execute w/o results to None, not . Return statement type code after
Stored procedure fixes, and debugging enhancements.
Stored procedure IN/OUT variables, changes to executemany()
Changed ZOracleDA to not use method call to connect(). Partial stored
Bug fixes, largely packaging, from Alpha 1. Added SQLT_AFC handler, SPARC
First www.zope.org release
This release contains both DCOracle2 and a slightly modified ZOracleDA; it
will register as ZOracleDA would (to silently upgrade Oracle connections)
and thus cannot be run concurrently with ZOracleDA/DCOracle.
To replace ZOracleDA, untar into lib/python/Products and make, move
ZOracleDA out of lib/python/Products, and rename lib/python/Products/DCO2 to
This release is intended for testing with ZOracleDA feature compatibility
(including LOB support) and is also intended for general use.
NT support has been tested, Microsoft Visual Studio project files are
included; this has only received testing with Oracle 8.0 and Oracle 8.1 on
Linux, Solaris, and Windows NT; a wider variety of platform experience is
The product is available at http://www.zope.org/Members/matt/dco2.