Re: Oracle logging on and off
| From: | Andy Hoffman | Date: | Fri, 17 Nov 2000 20:10:07 +0000 |
| Subject: | Re: Oracle logging on and off | ||
| References: | 1 | Groups: | php.windows |
| Request: | Send a blank email to php-windows+get-3958@lists.php.net to get a copy of this message | ||
"Asendorf, John" wrote:
> OCIPLogon ()
>
> if ( form is set) { do some searching
> return the results
> OCIlogoff () }
>
> else {form is not set
> echo a form to fill out that returns to this page}
>
> Am I causing myself a problem by having the OCIPLogon where I do?
John, since you keep getting problems with "rollback" errors (even when
you're only doing selects), have you tried calling commit() before logging
off? I know that sounds silly, when you're not making any changes to the
data, but it's just a feeling.
if (form is set) {
do some searching;
return the results;
ocicommit();
ocilogoff();
}
Maybe it'll help, maybe it won't...
--
Andy Hoffman
Web Developer
Bristol-Myers Squibb
email: andy.hoffman@bms.com