Re: [PHP-DB] oci driver performance

2008-10-20 Thread Christopher Jones
Chris wrote: Hi all, Using php 5.2.6 + oci driver 1.3.4 from pecl Has anyone had any issues with the oci8 driver performance? I'm doing some profiling using xdebug and all of the time seems to be spent in oci_execute and oci_fetch_array. This shows up when I use jmeter to hit the app

[PHP-DB] oci driver performance

2008-10-16 Thread Chris
Hi all, Using php 5.2.6 + oci driver 1.3.4 from pecl Has anyone had any issues with the oci8 driver performance? I'm doing some profiling using xdebug and all of the time seems to be spent in oci_execute and oci_fetch_array. This shows up when I use jmeter to hit the app pretty hard. The

Re: [PHP-DB] OCI

2008-07-22 Thread Christopher Jones
Daniel Brown wrote: On Mon, Jul 21, 2008 at 12:22 PM, Mad Unix [EMAIL PROTECTED] wrote: How could I build the OCI8 extension module for php5 under CentOS5? I have installe PHP/APACHE/MYSQL through yum install ... OCI8 is a PECL extension. 'pecl install oci8' If you need

[PHP-DB] OCI

2008-07-21 Thread Mad Unix
How could I build the OCI8 extension module for php5 under CentOS5? I have installe PHP/APACHE/MYSQL through yum install ... [EMAIL PROTECTED] arabic]# rpm -aq | grep php php-5.1.6-20.el5_2.1 php-pdo-5.1.6-20.el5_2.1 php-odbc-5.1.6-20.el5_2.1 php-xml-5.1.6-20.el5_2.1

Re: [PHP-DB] OCI

2008-07-21 Thread Daniel Brown
On Mon, Jul 21, 2008 at 12:22 PM, Mad Unix [EMAIL PROTECTED] wrote: How could I build the OCI8 extension module for php5 under CentOS5? I have installe PHP/APACHE/MYSQL through yum install ... OCI8 is a PECL extension. 'pecl install oci8' If you need more help with that, you can

[PHP-DB] OCI calls with segmentation fault

2006-09-27 Thread pons
I am running on that server Entrp. Oracle10g (installed on the server )on SLES 9 SUSE Linux with apache_1.3.35/ php-4.4.2 Web visitors retrieve datahttp://www.codecomments.com/PHP_Programming/message1053354.html#from the web by php calls through oci cobnnection from 10g release2 PHP is configured

[PHP-DB] oci logoff can not be done !!!

2005-06-30 Thread wendy
Hi, All. I've got a problem to disconnect oracle server. Though i call ocilogoff(), the client cannot disconnect to server. I already know it's a known bug, and i can't do something on oracle server (no authority) Is there a patch file or any other method to solve this problem ? I need your help

[PHP-DB] oci logoff cannot be done !!!

2005-06-30 Thread wendy
Hi, All. I've got a problem to disconnect oracle server. Though i call ocilogoff(), the client cannot disconnect to server. I already know it's a known bug, and i can't do something on oracle server (no authority) Is there a patch file or any other method to solve this problem ? I need your help

[PHP-DB] OCI Binding problem

2005-04-20 Thread Juffermans, Jos
Hi, Imagine this code: ?php $database_connection = ocilogon(username, password, connection string); // the actual connection code is slightly different but that is not relevant to my problem $postalcode = 3055; // option 1: paste the postalcode into the query:

RE: [PHP-DB] OCI Binding problem

2005-04-20 Thread N . A . Morgan
Sorry, trigger happy. Also try :postalcode in uppercase. Neil -Original Message- From: Juffermans, Jos [mailto:[EMAIL PROTECTED] Sent: 20 April 2005 12:18 To: 'php-db@lists.php.net' Subject: [PHP-DB] OCI Binding problem Hi, Imagine this code: ?php $database_connection

RE: [PHP-DB] OCI Binding problem

2005-04-20 Thread N . A . Morgan
Jos, This may or may not sort out the problem, but OCI_ASSOC | OCI_FETCHSTATEMENT_BY_ROW should be OCI_ASSOC+OCI_FETCHSTATEMENT_BY_ROW. Neil -Original Message- From: Juffermans, Jos [mailto:[EMAIL PROTECTED] Sent: 20 April 2005 12:18 To: 'php-db@lists.php.net' Subject: [PHP-DB] OCI

RE: [PHP-DB] OCI Binding problem

2005-04-20 Thread Juffermans, Jos
- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 20 April 2005 13:40 To: [EMAIL PROTECTED]; php-db@lists.php.net Subject: RE: [PHP-DB] OCI Binding problem Sorry, trigger happy. Also try :postalcode in uppercase. Neil -Original Message- From: Juffermans, Jos [mailto:[EMAIL

[PHP-DB] Recall: [PHP-DB] OCI Binding problem

2005-04-20 Thread Juffermans, Jos
Juffermans, Jos would like to recall the message, [PHP-DB] OCI Binding problem. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] OCI Binding problem

2005-04-20 Thread Juffermans, Jos
:05 To: 'php-db@lists.php.net' Subject: RE: [PHP-DB] OCI Binding problem Hi, Since flags are normally bitmaps, FLAG1 | FLAG2 should have the same result as FLAG1 + FLAG2. I've tried your suggestion anyway but it had no result. I've also tried to uppercase :postalcode (in the query

Re: [PHP-DB] OCI ignoring NLS_DATE_FORMAT parameter

2005-03-31 Thread Christopher Jones
Doug McMaster wrote: Regardless of how I set the NLS_DATE_FORMAT parameter, when I do a select statement DATE fields are returned in the Oracle default DD-MON-RR format. I can successfully set NLS_DATE_FORMAT using either an environment variable and restarting apache or by using ALTER SESSION

[PHP-DB] OCI ignoring NLS_DATE_FORMAT parameter

2005-03-24 Thread Doug McMaster
Regardless of how I set the NLS_DATE_FORMAT parameter, when I do a select statement DATE fields are returned in the Oracle default DD-MON-RR format. I can successfully set NLS_DATE_FORMAT using either an environment variable and restarting apache or by using ALTER SESSION SET NLS_DATE_FORMAT =

[PHP-DB] oci functions

2002-11-07 Thread Maziar
Hi everybody What should I do for useing OCI functions of oracle 9i in PHP4. I think I should recompile PHP with somthing but I don't know with what and how should I do this. I installed oracle 9i on SUSE linux 8.0. Best Regards Maizar -- PHP Database Mailing List (http://www.php.net/) To

Re: [PHP-DB] oci functions

2002-11-07 Thread .: B i g D o g :.
Compile php with the OCI configuration option. That will work with oracle9i. On Thu, 2002-11-07 at 08:32, Maziar wrote: Hi everybody What should I do for useing OCI functions of oracle 9i in PHP4. I think I should recompile PHP with somthing but I don't know with what and how should I do

Re: [PHP-DB] oci function

2002-11-07 Thread Maxim Maletsky
you need to compile it with oci8 extension: http://uk.php.net/manual/it/ref.oci8.php -- Maxim Maletsky [EMAIL PROTECTED] Maziar [EMAIL PROTECTED] wrote... : Hi everybody What should I do for useing OCI functions of oracle 9i in PHP4. I think I should recompile PHP with somthing but I

[PHP-DB] oci function

2002-11-06 Thread Maziar
Hi everybody What should I do for useing OCI functions of oracle 9i in PHP4. I think I should recompile PHP with somthing but I don't know with what and how should I do this. I installed oracle 9i on SUSE linux 8.0. Best Regards Maizar -- PHP Database Mailing List (http://www.php.net/) To

[PHP-DB] OCI Query Results

2001-12-12 Thread Rankin, Randy
We are using OCI to query an Oracle DB. Everything seems to work fine (i.e; data is returned to the browser), however, the first record of every recordset is NOT returned. I can run the same query in SQLPlus and all records are returned. It seems something in PHP is stripping of the first record

RE: [PHP-DB] OCI Query Results

2001-12-12 Thread Rankin, Randy
Nevermind, I figured it out. There was a duplicate OCIfetchinto statement in the script. Randy -Original Message- From: Rankin, Randy [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 12, 2001 10:12 AM To: PHP List Cc: Barker, John Subject: [PHP-DB] OCI Query Results We are using

[PHP-DB] OCI support not functioning

2001-08-07 Thread Tom Tsongas
Hi folks. I posted on the install board but I figured I would run this by the guru's here as well. :) I am attempting to get php up and running with oracle and oci8 support bundled in. My configure statement is as follows: /configure --with-oci8=/oracle/product/8.1.7

Re: [PHP-DB] OCI 8 and rowid cause SIGSEGV

2001-02-24 Thread Joe Brown
The the colon has special meaning. Look up the OCI man page, specifically - look up the OCIBindByName function. http://www.php.net/manual/en/ref.oci8.php It may give you a hint for the use of the colon and it's use in positioning bound variables. -- Without knowing your table structure and

[PHP-DB] OCI 8 and rowid cause SIGSEGV

2001-02-23 Thread SVEN . VOIGT
Hi there! I am using the following code on SuSE 6.4, Apache 1.3.14 and PHP 4.0.4: # $sql is dyanmically built, e.g. $sql = "select foo, bar, :rid from masterdata"; $db = OCILogOn("picht","picht"); $stmt = OCIParse($db, $sql); $rowid = OCINewDescriptor($db,OCI_D_ROWID);

Re: [PHP-DB] OCI 8 and rowid cause SIGSEGV

2001-02-23 Thread Joe Brown
I suppose the authors never concieved a replacement parameter for select specification. try: $sql = "select foo, bar, rid from masterdata WHERE rid=:rid" You need to loose the colon ":" or place it to the right of a where clause. [EMAIL PROTECTED] wrote in message

[PHP-DB] OCI-24324 in apache error log

2001-01-24 Thread Matthias Kopolt
For some strange reason I get an : Warning: failed to rollback outstanding transactions!: ORA-24324 : Service handle not initialised in ... on line 0 I'm running 4.0.3pl1 as server module with OCI8-support for apache 1.3.14 and had no problems with the same script under php3. After some