RE: [PHP] More php Questions about PHP 4.3.4 (cli)

I don't think this is the problem... The problem is that oci* functions haven't been compiled. You probably have the ora_* functions though... I haven't compiled PHP myself so someone will have to tell you the right make options to use to compile oci support. HTH Martin > -----Original Message----- > From: Marcelo Pereira Fonseca da Silva > [mailto:marcelopfs@yahoo.com.br] > Sent: Friday, 12 March 2004 2:46 PM > To: PHP > Subject: Re: [PHP] More php Questions about PHP 4.3.4 (cli) > > > The ocilogon() function should have in third parameter > something like > > $db="(DESCRIPTION= > (ADDRESS_LIST= > (ADDRESS=(PROTOCOL=TCP) > (HOST=HOST_HERE)(PORT=PORT_HERE) > ) > ) > > (CONNECT_DATA=(SERVICE_NAME=DATABASE_NAME_HERE)) > )"; > > and two variables must be "able" on script.. > putenv("ORACLE_HOME=/path/to/oracle"); > and ORACLE_SID > putenv("ORACLE_SID", "ORACLE_SID_HERE"); > > hope that helps > > --Marcelo > > > > > > > --- Martin McCormick <martin@dc.cis.okstate.edu> > escreveu: > I installed the FreeBSD port of php4.3.4. > In order > > to query a > > remote database server running Oracle8I, I am > > supposed to use oci > > commands. I have a test script that one would think > > should do nothing > > except briefly connect to the remote server: > > #!/usr/local/bin/php > > <? > > //Login to SQL > > $numero= ocilogon("application", "password", > > "servername"); > > > > Instead, I get: > > > > Fatal error: Call to undefined function: ocilogon() > > in /usr/home/martin/tmp/vm on line 8 > > > > There is a user configuration box to set up when > > building the > > port. I do not disturb the default flags, but also > > selected the mssql > > support as well as mysql support. I also selected > > Oracle support, but > > that turns out to be for Oracle versions up to 7. > > If you have Oracle7 > > or higher, you should use the oci8 support. There > > is no oci8 > > selection in the user configuration box, so it isn't > > like I forgot it. > > > > Any ideas as to why php gives me this fatal error? > > > > Our queries to the mssql server do work, but I am > > having no > > luck at all establishing communication with the > > Oracle8I server which > > runs on a Windows platform. > > > > Is there a good oci command to use to prove that I > > have > > established communication with the server? > > > > As always, thanks for any constructive ideas. This > > is kind of > > a border-line question between whether it should be > > in this list or > > the FreeBSD-questions mailing list, but it is also a > > bit specialized, > > and maybe someone will recognize the problem. > > > > Martin McCormick WB5AGZ Stillwater, OK > > OSU Information Technology Division Network > > Operations Group > > > > -- > > PHP General Mailing List (http://www.php.net/) > > To unsubscribe, visit: http://www.php.net/unsub.php > > > > ______________________________________________________________________ > > Yahoo! Mail - O melhor e-mail do Brasil! Abra sua conta agora: > http://br.yahoo.com/info/mail.html > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > __________ Information from NOD32 1.617 (20040206) __________ > > This message was checked by NOD32 for Exchange e-mail monitor. > http://www.nod32.com > > > >