Re: persistent database connections with OCI

On Sun, Aug 06, 2000 at 11:00:54AM +0200, Christian Ruppnig wrote: > Hi, > > I intend to use persistent database connections with OCI. What happens at > the end of the script ? > Is there a implicit commit or even rollback ? Do I have to code a commit for > this reason ? 1. by default OCIExecute() does COMMIT_ON_SUCCESS (so you don't have to commit at all!) - if you want to commit yourself you have to do OCIExecute($stmt,OCI_DEFAULT) in your script. 2. all outstanding transactions are rolled back at the end of the script. > Do I have to free any resources ? (statements below are for PHP 4) no - but it's considered "good-style";-) > What does it mean if I code a OCILogoff ? you log-off from the DB -but- the server-connection will stay open till the end of the script. tc > > Thank you ! > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > For additional commands, e-mail: php-general-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net -- Thies C. Arntzen "One Big-Mac, Small Fries and a Coke!" Digital Collections Phone +49 40 235350 Fax +49 40 23535180 Hammerbrookstr. 93 20097 Hamburg / Germany