[Phplib-trackers] [ phplib-Patches-450706 ] Enhancements to OCI8 support

[<no...@so...>]

Patches item #450706, was opened at 2001-08-13 22:56
You can respond by visiting: 
http://sourceforge.net/tracker/?func=detail&atid=403613&aid=450706&group_id=31885

Category: None
Group: None
Status: Open
Resolution: None
Priority: 5
Submitted By: Richard Archer (richardarcher)
Assigned to: Nobody/Anonymous (nobody)
Summary: Enhancements to OCI8 support

Initial Comment:
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.



----------------------------------------------------------------------

You can respond by visiting: 
http://sourceforge.net/tracker/?func=detail&atid=403613&aid=450706&group_id=31885