Fw: Re: [PHP-DB] oci8 1.3.4 working for months on my simple browser based php

2009-05-31 Thread Fred Silsbee
arted working with the new password Whew! --- On Sun, 5/31/09, Fred Silsbee wrote: > From: Fred Silsbee > Subject: Re: [PHP-DB] oci8 1.3.4 working for months on my simple browser > based php > To: "danaketh" > Date: Sunday, May 31, 2009, 11:41 PM > Thanks! I thoug

Re: [PHP-DB] oci8 1.3.4 working for months on my simple browser based php

2009-05-31 Thread danaketh
Look what extensions are you loading. You should find that in php.ini file. Maybe something nasty happened and you php.ini has extension=php_oracle.dll instead of extension=php_oracle.so. Also, if you are about to compile a module for PHP, first you have to run phpize, than ./configure and make

Re: [PHP-DB] oci8 1.3.4 working for months on my simple browser based php

2009-05-31 Thread Phpster
If I had to guess the config.w32 is the window 32 bit config file. So I would try the other Bastien Sent from my iPod On May 31, 2009, at 15:28, Fred Silsbee wrote: For months I've had a Oracle 11g1 browser based table access site/ program working. I do regular Fedora 9 yum updates and

[PHP-DB] oci8 1.3.4 working for months on my simple browser based php

2009-05-31 Thread Fred Silsbee
For months I've had a Oracle 11g1 browser based table access site/program working. I do regular Fedora 9 yum updates and have seen some pecl/pear stuff whizzing by. Just tried the Oracle 11g1 browser based table access site/program and NOTHING shows on the Firefox 3.0.10 screen. Not even an e

[PHP-DB] oci8

2008-11-19 Thread Fred Silsbee
oci8 OCI8 Supportenabled Version 1.3.4 Revision$Revision: 1.269.2.16.2.38.2.20 $ Active Persistent Connections 0 Active Connections 0 Compile-time ORACLE_HOMEno value Libraries Used no value Temporary Lob support enabled Collections support enabled Direc

Re: [PHP-DB] OCI8 , PHP and APACHE issue

2008-09-01 Thread Evert Lammerts
ginal Message- > From: Evert Lammerts [mailto:[EMAIL PROTECTED] > Sent: Monday, September 01, 2008 10:32 PM > To: Jack van Zanen > Cc: php-db@lists.php.net > Subject: Re: [PHP-DB] OCI8 , PHP and APACHE issue > > No interesting entries in the logs? > > On Mon, Sep 1,

RE: [PHP-DB] OCI8 , PHP and APACHE issue

2008-09-01 Thread Jack van Zanen
it worked ok I really need to understand more about windows I guess Jack -Original Message- From: Evert Lammerts [mailto:[EMAIL PROTECTED] Sent: Monday, September 01, 2008 10:32 PM To: Jack van Zanen Cc: php-db@lists.php.net Subject: Re: [PHP-DB] OCI8 , PHP and APACHE issue No

Re: [PHP-DB] OCI8 , PHP and APACHE issue

2008-09-01 Thread Evert Lammerts
No interesting entries in the logs? On Mon, Sep 1, 2008 at 2:27 PM, Jack van Zanen <[EMAIL PROTECTED]> wrote: > I have the phpinidir directive set in apache so it loads the exact same > php.ini as the cli > > Jack > > 2008/9/1 Evert Lammerts <[EMAIL PROTECTED]> >> >> I see that in both cases c:\PH

Re: [PHP-DB] OCI8 , PHP and APACHE issue

2008-09-01 Thread Jack van Zanen
I have the phpinidir directive set in apache so it loads the exact same php.ini as the cli Jack 2008/9/1 Evert Lammerts <[EMAIL PROTECTED]> > I see that in both cases c:\PHP\php.ini is loaded. Are you sure that > after trying the command line you didn't cut - paste the file to > c:\windows? What

Re: [PHP-DB] OCI8 , PHP and APACHE issue

2008-09-01 Thread Evert Lammerts
I see that in both cases c:\PHP\php.ini is loaded. Are you sure that after trying the command line you didn't cut - paste the file to c:\windows? What do apache's and PHP's logs say? On Mon, Sep 1, 2008 at 1:25 PM, Jack van Zanen <[EMAIL PROTECTED]> wrote: > Attached is phpinfo() both from the com

Re: [PHP-DB] OCI8 , PHP and APACHE issue

2008-09-01 Thread Jack van Zanen
Attached is phpinfo() both from the command line and from apache on the same machine I have done the exact same setup on my laptop and it works fine from apache and cli. I even copied over the httpd.conf and the php.ini file from my laptop as all paths and versions were identical. Oracle 10.2.0.

Re: [PHP-DB] OCI8 , PHP and APACHE issue

2008-09-01 Thread Jack van Zanen
at home now, will log on maybe later and get these Thanks so far 2008/9/1 Evert Lammerts <[EMAIL PROTECTED]> > Can you send your and the output of phpinfo when run from the command > line and when run from the browser? > > On Mon, Sep 1, 2008 at 6:35 AM, Jack van Zanen <[EMAIL PROTECTED]> wrote:

Re: [PHP-DB] OCI8 , PHP and APACHE issue

2008-09-01 Thread Evert Lammerts
Can you send your and the output of phpinfo when run from the command line and when run from the browser? On Mon, Sep 1, 2008 at 6:35 AM, Jack van Zanen <[EMAIL PROTECTED]> wrote: > Hi List, > > > I have installed Oracle, PHP and apache on my windows machine and have the > following issue > > If I

[PHP-DB] OCI8 , PHP and APACHE issue

2008-08-31 Thread Jack van Zanen
Hi List, I have installed Oracle, PHP and apache on my windows machine and have the following issue If I run phpinfo() from the command line it shows OCI8 as enabled and I can connect to oracle databases. When I copy my php.ini to my windows directory (from my php directory) and start apache an

RE: [PHP-DB] oci8

2004-11-21 Thread Manoj Kumar
: [PHP-DB] oci8 I am facing problem in connecting to Oracle from php. I followed the instructions listed in www.oracle.com/technology/tech/opensource/php/apache/inst_php_apache_linux.h tml. However, when I run phpinfo(), it show that oci8 is not loaded and eventually the ocilogon() is not working

[PHP-DB] oci8

2004-11-21 Thread Joe
I am facing problem in connecting to Oracle from php. I followed the instructions listed in www.oracle.com/technology/tech/opensource/php/apache/inst_php_apache_linux.h tml. However, when I run phpinfo(), it show that oci8 is not loaded and eventually the ocilogon() is not working. I'd really a

[PHP-DB] oci8 cannot connect after restarting DB

2004-11-16 Thread Michael Caplan
Every evening, for whatever reason, our Oracle db (9.2.0) is restated. After it is restarted, I am unable to build a connection with Oracle from PHP untill Apache is restarted. Whenever I do an ociplogon() or ocilogon() following an Oracle DB restart, it fails but I am unable to get a descripti

RE: [PHP-DB] OCI8

2004-08-13 Thread Yannick GUENET
Thanks for your help, but i tried with OCIPLogon, and get same result. -Message d'origine- De : Ford, Mike [LSS] [mailto:[EMAIL PROTECTED] Envoyé : vendredi 13 août 2004 16:03 À : 'yannick'; [EMAIL PROTECTED] Objet : RE: [PHP-DB] OCI8 On 13 August 2004 13:29, yannick w

RE: [PHP-DB] OCI8

2004-08-13 Thread Ford, Mike [LSS]
On 13 August 2004 13:29, yannick wrote: > I have some trouble with Oracle Database and php... > > see this code: > while (1) { > $conn=OCILogon($username,$password,$database); Try OCIPLogon() rather than OCILogon(). > $stmt=OCIParse($conn,"select 50 as toto from dual"); > OCIDefineByName($stmt

RE: [PHP-DB] OCI8

2004-08-13 Thread Yannick GUENET
PROTECTED] Objet : Re: [PHP-DB] OCI8 It might be a feature of PHP's connection caching. Why don't you log a bug in the PHP bug DB so the problem can be tracked? Do you really need to keep reconnecting? See http://www.oracle.com/technology/tech/opensource/php/php_troubleshooting_faq

Re: [PHP-DB] OCI8

2004-08-13 Thread Christopher Jones
It might be a feature of PHP's connection caching. Why don't you log a bug in the PHP bug DB so the problem can be tracked? Do you really need to keep reconnecting? See http://www.oracle.com/technology/tech/opensource/php/php_troubleshooting_faq.html#conmgt Chris yannick wrote: I have some troub

[PHP-DB] OCI8

2004-08-13 Thread yannick
I have some trouble with Oracle Database and php... see this code: when i execute it, the number of fd on ocius.msg is growing. but there is only 1 connection at database. Can someone help me ? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.

RE: [PHP-DB] OCI8 Memory Leak?

2004-02-20 Thread Shawn Coomey
m Oracle's tnsnames.ora file. I did, and it seems to have helped... though I'm not convinced. Thanks! Shawn -Original Message- From: Greg Skouby [mailto:[EMAIL PROTECTED] Sent: Friday, February 20, 2004 3:28 PM To: Shawn Coomey Subject: RE: [PHP-DB] OCI8 Memory Leak? Hi Shawn,

[PHP-DB] OCI8 Memory Leak?

2004-02-20 Thread Shawn Coomey
Hi folks- I am building an application which uses OCI8 functions (abstracted with PEAR::DB) to perform queries against an Oracle 9i database. Here's my platform info: Solaris 8 (SunOS 5.2) on a Sun Ultra II workstation Oracle 9i PHP 4.3.5RC2-dev Apache 1.3.29 Here's my problem: Ever

[PHP-DB] OCI8 issue (and some apc too): configure bugs?

2002-03-06 Thread Diego Francisco de Gastal Morales
Hello all, I've read several messages and articles about php/oci8 combination, but I still have some issues not resolved. On this system: Debian (stable), PHP 4.0.6, Oracle 8.1.7, Apache 1.3.9-14, I compile php like this: #Begin ORACLE_HOME=/oracle/product/8.1.7 ./configure \ --prefix

Re: [PHP-DB] OCI8

2002-01-18 Thread Thies C. Arntzen
On Thu, Jan 17, 2002 at 01:20:47PM -0700, Randall Barber wrote: > I've been using the OCI8 extension and have a question about the Persistent >Connections. > > While debugging the site, I will run into the following error (paraphrased): > > BeginSession: too many processes running > > etc... >

[PHP-DB] OCI8

2002-01-17 Thread Randall Barber
I've been using the OCI8 extension and have a question about the Persistent Connections. While debugging the site, I will run into the following error (paraphrased): BeginSession: too many processes running etc... I have my scripts setup in the following way: I never do call OCILogOff(...

[PHP-DB] OCI8 Function Clarification

2002-01-09 Thread Randall Barber
I have a simple SELECT statement that returns more than one row. When I do something like this: do { . } while (OCIFetch($qryResult) != false); I get an "Out of sequence" error on OCIFetch. So then I tried this: $numRows = OCIRowCount($qryResult); for($i = 0; $i < $numRows; $i++) { OCI

[PHP-DB] OCI8

2001-11-13 Thread pierre Richard louis
Anyone can help with php and OCI8, to get the connection with Oracle? I am running Oracle 9.0 and the error message is ORA-12705 (invalid or unknown NLS parameter in /usr/local/apache/htdocs/xyz.php on line 5). I am running PHP 4.0.6, Apache 1.3.22 on Suse linux 7.1 Thanks in advance -- PHP D

[PHP-DB] oci8.max_links missing from php.ini

2001-09-29 Thread John Lim
Hello, I checked the windows php.ini and i did not see any reference to oci8.allow_persistent=On ; allow or prevent persistent links oci8.check_persistent=On ; check that a connection is still validbefore reuse oci8.max_persistent=-1 ; maximum number of persistent links. -1 means no limit oci8.m

Re: [PHP-DB] oci8 and arrays as parameter

2001-09-10 Thread Thies C. Arntzen
On Mon, Sep 10, 2001 at 03:50:08PM +0200, Ez-Berlin, E2boxb wrote: > hi list, read my paper from conf.php.net/oci - it should explain all that! tc > > I'm using PHP 4.0.6 and i want to give an array as parameter > from a php script to an oracle pl/sql - procedure... > > We had an o

[PHP-DB] oci8 and arrays as parameter

2001-09-10 Thread Ez-Berlin, E2boxb
I am using PHP 4.0.6 and i want to give an array as parameter from a php script to an oracle pl/sql - procedure... We had an older asp - site, witch used the same stored procedure, so that it's clear, the procedure works... In asp it calls "AddTable" to bind the parameter as array call without t

[PHP-DB] oci8 and arrays as parameter

2001-09-10 Thread Ez-Berlin, E2boxb
hi list, I'm using PHP 4.0.6 and i want to give an array as parameter from a php script to an oracle pl/sql - procedure... We had an older asp - site, witch used the same stored procedure, so that it's clear, the procedure works... In asp it calls "AddTable" to bind the parameter as array call

[PHP-DB] oci8 and arrays as parameter

2001-09-10 Thread Ez-Berlin, E2boxb
hi list, I'm using PHP 4.0.6 and i want to give an array as parameter from a php script to an oracle pl/sql - procedure... We had an older asp - site, witch used the same stored procedure, so that it's clear, the procedure works... In asp it calls "AddTable" to bind the parameter as array call

[PHP-DB] OCI8: searching for testcase that causes "failed to rollback outstanding transactions" or SEGFAULTs

2001-02-18 Thread Thies C. Arntzen
resend cause of type in adress - Forwarded message from "Thies C. Arntzen" <[EMAIL PROTECTED]> - Date: Sun, 18 Feb 2001 17:26:25 +0100 From: "Thies C. Arntzen" <[EMAIL PROTECTED]> To: [EMAIL PROTECTED], [EMAIL PROTECTED], [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: OCI8: search

Re: [PHP-DB] OCI8 error problems

2001-02-18 Thread Thies C. Arntzen
On Thu, Feb 15, 2001 at 10:07:23AM -0500, Brian Lalor wrote: > On Thu, 15 Feb 2001, Thies C. Arntzen wrote: > > > how should it? > > > > you would have to pass in the correct statement|connection > > handle - elsewise it simply won't work! > > Ok, that was a cobbled-up code snippet;

Re: [PHP-DB] OCI8 error problems

2001-02-15 Thread Brian Lalor
On Thu, 15 Feb 2001, Thies C. Arntzen wrote: > how should it? > > you would have to pass in the correct statement|connection > handle - elsewise it simply won't work! Ok, that was a cobbled-up code snippet; replace $this->conn with $conn, and $statement with $s. It still doesn't wor

Re: AW: [PHP-DB] OCI8 error problems

2001-02-15 Thread Brian Lalor
On Thu, 15 Feb 2001, Matthias Kopolt wrote: > > Warning: OCIStmtExecute: ORA-1: unique constraint (CUSTOM.SYS_C007900) > violated ORA-06512: at > >"CUSTOM.MULT_SHIP_ADDRESS_PKG", line 162 ORA-06512: at line 1 in db.php on > line 344 > > this has nothing to do with PHP, this is your person

Re: [PHP-DB] OCI8 error problems

2001-02-15 Thread Thies C. Arntzen
On Wed, Feb 14, 2001 at 05:40:02PM -0500, Brian Lalor wrote: > Good afternoon, all. Sorry if this has been covered before, but a search > of the archives doesn't turn up any relevant answers. > > I'm having a problem with the OCI8 commands. I'm using PHP 4.0.4pl1 with > Oracle 8.0.5 (yes, I kno

AW: [PHP-DB] OCI8 error problems

2001-02-14 Thread Matthias Kopolt
> Warning: OCIStmtExecute: ORA-1: unique constraint (CUSTOM.SYS_C007900) violated ORA-06512: at >"CUSTOM.MULT_SHIP_ADDRESS_PKG", line 162 ORA-06512: at line 1 in db.php on line 344 this has nothing to do with PHP, this is your personal DB-Problem ;-) A "constraint" is a DB-Rule that ke

[PHP-DB] OCI8 error problems

2001-02-14 Thread Brian Lalor
Good afternoon, all. Sorry if this has been covered before, but a search of the archives doesn't turn up any relevant answers. I'm having a problem with the OCI8 commands. I'm using PHP 4.0.4pl1 with Oracle 8.0.5 (yes, I know that's old, but somebody seems to have lost the CD for 8.1...). Cons

Re: [PHP-DB] OCI8 and Listener

2001-01-17 Thread R Maier
Hi. Stefan the returned error is TNS-12162 TNS:service name is incorrectly specified Cause: The connect descriptor corresponding to the service name in TNSNAMES.ORA is incorrectly specified. Action: Make sure there are no syntax errors in the connect descriptor. Particularly look for unmatched p

RE: [PHP-DB] OCI8 and Listener

2001-01-15 Thread Alarion
here. Try searching google for that error... Sean -Original Message- From: Stefan Fokuhl [SMTP:[EMAIL PROTECTED]] Sent: Monday, January 15, 2001 7:06 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] OCI8 and Listener Hi, i've compiled my php modul with oci8.But I can'

Re: [PHP-DB] OCI8 and Listener

2001-01-15 Thread Steve Farmer
Stefan, can you connect with oracles SQL*Plus tool? Steve Farmer At 8:05 AM +0100 15/1/01, Stefan Fokuhl wrote: >Hi, > >i've compiled my php modul with oci8.But I can't connect to my db. It >tells me the error ORA-12162. In the documentation there is no such >error mentioned. > >Do I need to s

[PHP-DB] OCI8 and Listener

2001-01-14 Thread Stefan Fokuhl
Hi, i've compiled my php modul with oci8.But I can't connect to my db. It tells me the error ORA-12162. In the documentation there is no such error mentioned. Do I need to start to Oracle listner? Is tere somebody who had solved this problem in the past? Thanks Stefan -- PHP Database Mail