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 t
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
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 ca
Sent: 20 April 2005 14: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 upperca
riginal Message-
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: Juffe
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 Bind
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:
Both queries should result in the sa
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 SE
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
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
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 O
Did you install the Oracle client?
-Original Message-
From: Tom Tsongas [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 07, 2001 11:53 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] OCI support not functioning
Hi folks. I posted on the install board but I figured I would run this
by the gu
On Tue, Aug 07, 2001 at 09:52:37AM -0700, Tom Tsongas wrote:
> 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:
>
On Thu, Jul 26, 2001 at 01:18:11PM +0200, cristiano wrote:
> A question...
> How is shared the connection with oracle db by using OCIPLogon() function?
>
> - One for each child web processes
that's the way it works...
tc
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe
On Sat, Feb 24, 2001 at 05:43:58PM +0100, Sven Voigt wrote:
> On Friday 23 February 2001 17:03, you wrote:
> > I suppose the authors never concieved a replacement parameter for select
> >
> > specification.
> >
> > try:
> > > $sql =3D "select foo, bar, rid from masterdata WHERE rid=3D:rid"
> >
> >
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 how
On Friday 23 February 2001 17:03, you wrote:
> I suppose the authors never concieved a replacement parameter for select
>
> specification.
>
> try:
> > $sql =3D "select foo, bar, rid from masterdata WHERE rid=3D:rid"
>
> You need to loose the colon ":" or place it to the right of a where cla
> use
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
F114C0EF28F3D211B7E8400061
Hallo Andreas, hi Richard, hola David,
with your help I now found the problem.
when I checked with
echo phpinfo(INFO_ENVIRONMENT);
I saw that ORACLE_HOME was not set anymore and LD_LIBRARY_PATH was set wrong.
I first tried to set these variables with
putenv("ORACLE_HOME=/opt/oracle/product.
> even so my php4 is running on the server where the database is installed,
>
> I tried your putenv to all of the oracle variables.
putenv won't help. The Oracle client libraries are initialized during
server startup, so they won't see the environment set via putenv in a
PHP script. This applie
Hi Richard, hola David,
even so my php4 is running on the server where the database is installed,
I tried your putenv to all of the oracle variables.
It did not change any.
All these variables are usually set by the root profile where oracle and
apache start:
K10oracle
K20apache
I had the OCIInte
For what it's worth, here is the script I've been using to hook up to
Oracle (specific for my system removed, of course...):
Success" ;
} else {
echo "Failed connecting to oracle. Exiting program.";
exit;
}
?>
The key proved to be the two putenv statements at the beginning.
22 matches
Mail list logo
