Re: ora error
| From: | Mark | Date: | Thu, 08 Feb 2001 14:53:24 +0000 |
| Subject: | Re: ora error | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-38757@lists.php.net to get a copy of this message | ||
First guess is correct, yeah I did use the cool ora_plogin thing
I'm only doing selects so why do I need to do any commits
-Mark
""Richard Lynch"" <richard@zend.com> wrote in message
news:09ab01c091b8$3e6b4000$64aa8ed8@142.170.100...
> > Oracle Error: 2042 (ORA-02042: too many distributed transactions
> ORA-02063:
> > preceding line from SHEETS -- while processing OCI function OPARSE)
> > Session halted.
>
> Well, maybe you have a lot of transactions and never commit them.
>
> Wild Guesses:
> You used that cool ora_plogin persistent thing, so the connection never
> really closes as far as Oracle is concerned, and there's an automatic
> transaction started when you login, so eventually, every httpd has a
> transaction going.
>
> You didn't use the cool ora_plogin persistent thing, but everything else
> above is still true.
>
> You are using transactions somewhere but never commit nor rollback.
>
> --
> Visit the Zend Store at http://www.zend.com/store/
> Wanna help me out? Like Music? Buy a CD:
> http://l-i-e.com/artists.htm
> Volunteer a little time: http://chatmusic.com/volunteer.htm
>
>
>
> --
> 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
>