#3 Enhancements to OCI8 support

[Richard Archer]

Here is a compilation of enhancements and bug fixes to
php-lib-devel/php/db/oci8/db_sql.inc

I don't have an Oracle database (yet!) so I'm not
willing to commit the changes (even to the -devel tree)
without testing. Could someone with Oracle running
please make sure these work as expected?

Some of these changes are bug fixes that should
probably be committed to -stable as well.

These changes are sourced from:
The -stable tree
A patch posted to the list by Ignatius TeoA patch
posted to the list by Jesse Swensen
Jesse says:
Here are my changes to oci8.inc. There are four
things changed you need to be aware of:
1) new instance variable, $autoCommit.
Default is 1, commit. You can either set it when
you subclass db_sql for the default value or you can
set it interactively for each db_sql instance, i.e.
$db = new DB_Example;
$db->autoCommit = 0;
2) new methods commit and rollback.
3) every time query is called it will recycle the
old cursor(call to freeStatement). As a result, you
can call query as many times as you like without
fear of the "too many open cursors" error.
4) new method freeStatement.

[Richard Archer]

diff against -devel/php/db/oci8/db_sql.inc

[nathan hruby]

Logged In: YES
user_id=19736

Anything ever happen with this? Has it been added, tested..?