Re: [phplib] How to use db_Sql with Oracle 8? From: Dave Thomas (davelists <email protected>)
Date: 12/12/00

I think you're right that PHPlib uses ora_pconnect, which opens a persistent connection (if PHP can). Unfortunately as best as I can tell, PHPlib only implements them using the ora* functions, not the oci8* functions. So now you can't access and manipulate stored procedures, triggers, and all the great features that makes Oracle Oracle. From OCI8, you've got the ability to issue commands like you would in SQL/PLUS.

Am I wrong in this? Is anyone interested in writing a DB_SQL class implementing OCI8? I'd be glad to contribute.

Dave

Thus spake zoltan.sebestyen <email protected> (zoltan.sebestyen <email protected>):

> Hi,
>
> As far as I know, Oracle has persistent connections, and phplib use them.
> My problem is that the phplib doc does not advise to use the disconnect
> method at the end of the php page. By the way I tried out, without any luck.
> What I would like to know now is what is the 'correct' way to user phplib
> with Oracle 8, how to deal with it. May be I misconfigured something and
> that causes this problem, I can't tell :(
>
> Zoltan
>
> > -----Original Message-----
> > From: Philip Strnad [mailto:philip <email protected>]
> > Sent: Saturday, December 09, 2000 4:41 AM
> > To: Sebestyén Zoltán
> > Subject: Re: [phplib] How to use db_Sql with Oracle 8?
> >
> >
> > Are you closing the connections? Is there a persistent connection
> > mechanism in PHP for Oracle?
> >
> > Philip
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: phplib-unsubscribe <email protected>
> For additional commands, e-mail: phplib-help <email protected>

---------------------------------------------------------------------
To unsubscribe, e-mail: phplib-unsubscribe <email protected>
For additional commands, e-mail: phplib-help <email protected>