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
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
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
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
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
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
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
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
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:
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
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
-
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
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
: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
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
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 =
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
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
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
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
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
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
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
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
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);
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
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
27 matches
Mail list logo