Adriano Rocha wrote:
I'm running Linux RedHat7.3 with PHP 4.3.3.
root # ./configure --with-oci8 (no errors)
root # make (no errors)
root # make install (no errors)
... it does not create the oci8.so file. Obviously, php pages on OCILogon
and related functions crashes with undefined
Roger,
You can see the real Oracle error number if you replace the getMessage()
calls with getDebugInfo() or getUserInfo().
Making this change gave this output:
Connecting . . .
CREATE TRIGGER test_trigger before insert on test for each row begin
select test_seq.nextval into :new.id
Roger Spears wrote:
I'm using PHP/PEAR to execute my queries on an oracle table. I'm trying
to store very long pieces of text into a CLOB field. Currently I'm
getting a string too long error.
I've tried:
OCIBindByName($sql,:fieldName,$myVariable, -1);
But I'm not sure I'm using it correctly
Sergio Hernandez wrote:
Hi, we are working in php with oracle and we have a stupid problem.
We are trying to obtain the return value of a variable. But after
execute the function it give to us an empty value, its return 0 columns
and 1 row. We have prove this function in oracle and it give a
Roger Spears wrote:
I've been working on this all day. I'm trying to insert some text
($essay) into a CLOB field (essay) in my table (clob_test).
Can someone please tell me why the following PHP code returns ORA-01036:
illegal variable name/number? Better yet, please tell me how to fix it??
Johan Kruger-Haglert wrote:
I've been trying to get Linux+apache+php+oracle working here with no
success, so I've to ask for some help.
Versions:
RedHat 9.0
PHP 4.3.4RC1
Oracle Enterprise Server 9.2.x
Oracle client 8.1.7
The machine has to run RedHat, and newest version would be good.
Oracle9.x
kss wrote:
I'm using php/oracle9.2 .
i cant' login into oracle db using ocilogon() as SYS user.
above 9i , in order to login as SYS user
5th parameter of OCISessionBegin must be OCI_SYSDBA(not OCI_DEFAULT);
my suggestion !!
PHP ocilogon specification
resource ocilogon ( string username,
John Mullins wrote:
Has anyone come across this behavior? We've built php 4.3.2 with
Oracle support (both --with-oracle and --with-oci8), but when I
try to start up Apache with the ORACLE_HOME env variable set to
the Oracle home location, it core dumps with this error:
KGP-00600: internal
Ludnyi Levente wrote:
Hello
I'm trying to use the OCINewCollection function, but if I don't specify the 'schema'
parameter for this function, then I get the 'ocinewcollection(): OCI8 Recursive call!'
error message, and the page never appears (I must restart IIS). If I give a typename,
that
MaNu wrote:
Function :
FUNCTION PREZZO_TOT (
pUtente in v_utenti.utente%type,
pTrasp in char
) return NUMBER;
Php
$query = SELECT poe.carrello.prezzo_tot('AATCXNK2EN3RDKB','1') PIPPO FROM dual;
$parsed = ociparse($conn,$query);
I don't have this combo to test unfortunately.
It may be an include path problem. Check the Makefile has a
valid -I path for the Oracle headers.
An unrelated issue to be aware of is http://bugs.php.net/bug.php?id=25980
Chris
Daniel Sand wrote:
Hello,
The system is Solaris sun4u sparc
Using OCIBindByName($stmt,$bindname,${bindval$ci},-1); probably gives
a warning that call-time pass-by-reference has been deprecated.
The OCIBindByName manual entry at
http://www.php.net/manual/en/function.ocibindbyname.php
has a user comment from alexander dot zimmer at gmx dot at that this
Jed wrote:
Hello All,
I'm new to PHP but was able to get some simple sample programs working
accessing a local Oracle database using the php_oci8.dll extension provided
with the php 4.3.4 distribution. I installed the PHP5 beta version but
there is no php_oci8.dll provided, only
Christopher Jones wrote:
Jed wrote:
Hello All,
I'm new to PHP but was able to get some simple sample programs working
accessing a local Oracle database using the php_oci8.dll extension
provided
with the php 4.3.4 distribution. I installed the PHP5 beta version but
there is no php_oci8.dll
I see the answer has already been given on php-install.
A suggestion which hasn't been made is to use PHP's new oci8
interface in preference to the old one called oracle whenever
possible.
To quote from a note on Oracle's PHP forum (see
http://forums.oracle.com/forums/forum.jsp?forum=178 )
Douglas,
To try and reduce confusion, a Client install refers to the option
of that name in the Oracle9i Database Release installer. (The other
options are Database, Mgt Intg, and Cluster Mgt).
This will install the headers needed to link PHP, if your previous
installer choice didn't load them.
nabil wrote:
I have php 4.3.4 on windows as a development environments,
i could not connect to oracle using the native functions,
What error do you get?
should i connect using ODBC ??
OCI8 has some benefits, depending on what you want to do
now and/or in the future. What are you trying to
William Cheung wrote:
Win 2K server
IIS 4.0
PHP 4.3.4
ADODB 4.10
Oracle 9.2
I got the following error
Warning: ociplogon():_oci_open_server: Error while trying to retrieve
text for error ORA-12538 in C:\PHPRoot\ADODB\drivers\adodb-oci8.inc.php
on line 128
You might be hitting a combination
Ricardo Lopes wrote:
Is possible to call database stored procedures from php with oracle or any other db?
There is a complete Oracle example in Frank Naudé's Oracle/PHP FAQ:
http://otn.oracle.com/tech/opensource/php_faq.html#PROC
Chris
--
PHP Database Mailing List (http://www.php.net/)
To
William Cheung wrote:
All the system errors are solved. However, the query seems not returning
any rows. I got undefined index error on any query returns.
Am I hitting the brick wall? Do PHP and ADODB work with Oracle 9.2? Are
there anyone know the answer?
I am using Windows 2K, IIS and
Luis Moran Ochoa wrote:
I've build the typical script for starting apache, it's like this:
$ORACLE_HOME=blablahblah...
more oracle variables
Are the environment variables exported in the script?:
ORACLE_HOME=/my/oracle/home
export ORACLE_HOME
Are all variables needed set?
Are
neither.
I don't know what more tests to do
I check the permissions too They appear to be right.
I'm completely lost
Christopher Jones wrote:
Luis Moran Ochoa wrote:
I've build the typical script for starting apache, it's like this:
$ORACLE_HOME=blablahblah...
more
What's the exact error you get when you try to connect to oracle and
what command are you using to connect?
Does a phpinfo() script show the Oracle env vars correctly under the
Environment section?
Chris
Luis Moran Ochoa wrote:
These are the exact details...
/usr/oracle permissions 750 owner
Delfins wrote:
i have successfully installed Oracle 9.2 on Slackware 9.0
database works fine also any other applications runs ok.
but when i compiled PHP5 with OCI8 (path i was specified as ORACLE_HOME)
but running some scrip, i have this error :
Warning: ocilogon(): _oci_open_server: Error
Elke Stahl wrote:
i successfully stored blobs in an oracle table via php. but it seems to be
impossible getting them back to filesystem!
It is a binary (no picture or executable) which arives via mail and is
written into a unix-filesystem.
ive stored this binary as blob datatype together with
Josef Suchanek wrote:
my platform is W2K or WXP. For the first I tried Apache 1.3.22
included in Oracle 9i installation with bad result. Then I tested
Apache 1.3.29 with the same bad result. Then I tried IIS without
problem and last test was with Apache 2.0.48. It worked fine too.
What about
Comments below.
Jim Morrison wrote:
Hello all,
Hope this isn't an FAQ - have trawled google, otn.oracle, php.net etc -
not sure I can find the answer..
I've been using phpmySql for a while now and getting on great - however
I'm now tasked with getting my php to talk to a _remote_ ( right next
Justin Patrin wrote:
Adam Williams wrote:
Hi, I have oracle and PHP working together on a remote server called
zed that runs redhat linux. I have another computer called
accessserver that runs win2k pro with PHP that I am trying to connect
to oracle on zed. Both computers have the oracle
Joseph Burch wrote:
Foolks -
In building the Apache PHP-Oracle interface we have discovered a
discrepancy between the functions listed in the PHP on-line
documentation and the function list obtained by nm for libphp4.so.
Our UNIX Solaris build comprises Apache_1.3.29, PHP-4.3.4, and the full
Philippe wrote:
Hi,
I am experiencing the message in the title of this message when starting
or restarting Apache. I have the following configuration:
- Windows XP
- Apache 2.0.49
- PHP 4.3.6
- Oracle Client 8i
If anyone has any information as to why this is happening and how I can
solve it, I
as a database management tool called Aqua Data Studio which
uses native connections.
Christopher Jones wrote:
Philippe wrote:
Hi,
I am experiencing the message in the title of this message when
starting or restarting Apache. I have the following configuration:
- Windows XP
- Apache 2.0.49
- PHP 4.3.6
Philippe wrote:
Well, the exact message is: Unable to load dynamic library
php_oci8.dll: The specified procedure could not be found
If I remove the library the message becomes The specified module could
not be found. It seems to be able to find the library (all the paths
are correct) but it
Joshua,
I see this is the question asked on
http://forums.oracle.com/forums/thread.jsp?forum=178thread=248354tstart=0trange=15
I'll followup on the OTN forum, not to this PHP-DB mail list.
Chris
Joshua Skagemo wrote:
Hi,
I am trying to call a procedure in Oracle 9i but I just can't get it to
Justin Patrin wrote:
Charles Morris wrote:
putenv(ORACLE_SID=PROJ);
putenv(ORACLE_HOME=/home/oracle9);
I have tried putenv myself and it doesn't seem to work for Oracle
connections. Putting those in your shell environment, then restarting
apache. Check to see if the env vars are set
Rafi Sheikh wrote:
Hi list. I am a newbie and would like to ask if anyone could give me the
proper syntax for connecting with oracle DB. For example with MySQL it is:
mysql_connect..., mysql_query...
For MS SQL Server:
mssql_connect..., mssql_query...
There are various examples in the PHP
Peter Beckman wrote:
How do I get connected from a remote PHP+Apache box to Oracle9i on linux?
The current Oracle Instant Client bundle is fine for using PHP on
Windows, but does not have headers for compiling PHP with Oracle
support on other platforms. An Instant Client SDK with headers is
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
Jon Foreman wrote:
Does anyone have any suggestions for the following problem:
I'm running Apache/1.3.31 and PHP Version 4.3.8 connecting to an Oracle
database. Periodically, PHP is unable to connect to the database. When this
problem occurs, I am able to connect to the database from the
, I won't win the programmers Nobel-Prize for that crap, but it
works so far; dropped connections are reconnected.
Dieter
Christopher Jones sagte:
D.Wilkening wrote:
Hi everyone,
i've a problem using php with oracle 10g.
(php 5.0.1 compiled against Oracle 10.1.0.2-libs, apache2 and apache1)
One
Chris wrote:
Is row-level locking happening?
I think that the lock doesn t work
When are you checking the locks?
I am checking the lock with an SQLPLUS session
If i lock my table with SQLPLUS, PHP can make an select for update
But if i try to lock with PHP i can make an other select for update
[EMAIL PROTECTED] wrote:
I'm trying to write text to a BLOB. I got a valid return code but it did not write the BLOB.
I was able to use similar code writing to a CLOB. Any examples I've seen for BLOBs
are reading
from Binary files. Here's how I did the CLOB, but it would not work for
Chris Back wrote:
Hi,
I am hoping that someone can help diagnose this issue.
I am able to successfully connect to and query a remote Oracle 9.2
database from apache2/php5. However, when I have multiple clients
hitting my php scripts, all of which require a connection to the
database, problems
During my presentation at the PHP Conference in Frankfurt I put
out a call for participation in creating a roadmap for Oracle
connectivity in PHP.
When I get back to work (I'm on a short vacation in Europe with
intermittent email access) I'll be following up on this. While I'm
away, feel free
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
Juffermans, Jos wrote:
Hi,
Some of our scripts that generate customer-facing pages, need a connection
to a database. The problems is that the database is in Norway and -
allthough we have a VPN setup - the connection isn't always available.
In case the connection cannot be made, we can redirect
Here are some things you could try.
Remove all the @ suppressions and make sure error_reporting = E_ALL
and display_errors = On are set in your php.ini.
Echo the SQL statement inside SQLInsertLob() to make sure it is
constructed OK.
Echo the filename to check it includes the appropriate path. If
use tnsnames.ora with sqlplus or tnsping.
Does anybody have any ideas what is going wrong? Is this a bug?
thanks,
neil
--
Christopher Jones, Oracle Corporation, Australia.
Email: [EMAIL PROTECTED] Tel: +61 3 8616 3622
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http
Leo D. Geoffrion wrote:
I recently upgraded to PHP5 and now have a curious Oracle problem.
The PHP scripts query the database fine. Then overnight, the database
shuts down for backup and restarts. The next day, PHP can no longer
connect to the database until I restart Apache. Then, it's happy
tnsnames.ora
However this is not good, so if you have any other idea please let me
know. I'm flumuxed.
thanks,
neil
gt;From: Christopher Jones lt;[EMAIL PROTECTED]gt;
gt;To: neil smith lt;[EMAIL PROTECTED]gt;
gt;CC: php-db@lists.php.net, [EMAIL PROTECTED]
gt;Subject: Re: [PHP-DB] php4 can't find
neil smith wrote:
Hi Martin,
It's a legacy application that is huge and sprawling and teh programmers
who developed it left along time ago , apparently. It would probably be
easier to write a whole new application then convert it to php 4 or 5
and thankfully thats not what I've been asked to
The --with-oracle option is a long deprecated interface to Oracle
and no-one has updated the configure script to work with Oracle 10g.
Can you use the new --with-oci8 option? Otherwise you'll need to
update ext/oracle/config.m4. The code in ext/oci8/config.m4 may help.
With either configure
Use the phpinfo() function to check that the same php is being used in
Apache and on the command line.
Make sure LD_LIBRARY_PATH contains $ORACLE_HOME/lib
Relink with --with-oci8
Another suggestion is upgrade PHP to 4.4 and manually get the new
refactored oci8 drivers. After you upgrade to
What line of code is 1546? How are you binding/executing/fetching?
Are you using OCI_B_CLOB?
If you post a complete (small) testcase we may can look at it.
Please include DDL to create any table.
Most importantly, use the refactored OCI8 driver:
http://pecl.php.net/package/oci8
-- cj
Rasim ÞEN wrote:
Hi friends ,
my code like this
$sql=SELECT mid,substr(ROWID,0,100) as nROWID,MEMBER_ID, NAME, SURNAME,
E_MAIL, SUBJECT, MAIL_BODY, to_char(DATE_CREATED,'DD.MM. HH24:MI:SS') as
DATE_CREATED, RETRY, PRIORITY, E_MAIL_FROM, RECEIVER_MEMBER_ID,
RECEIVER_NAME,
RIOTTEAU Gwénaël wrote:
Hi,
i try to connect my PHP application with Oracle.
But i have some random errors (with the function OCIStmtExecute) :
ORA-12152: TNS:unable to send break message
ORA-03114: not connected to ORACLE
sometimes it works well, sometimes not (for the same query)
:
--with-oci8
I suspect you'll have to compile php from source, you won't be able to
use a package to do this, but I could be wrong.
--
Postgresql php tutorials
http://www.designmagick.com/
--
Christopher Jones, Oracle Corporation, Australia.
Email: [EMAIL PROTECTED]
Blog: http
(version 8,9 or 10) on another machine
check the steps on using PHP with Oracle Instant Client, this
should be easier to work with the the full Oracle client.
Chris
--
Christopher Jones, Oracle Corporation, Australia.
Email: [EMAIL PROTECTED] Tel: +61 3 8616 3622
Blog: http://blogs.oracle.com
)');
oci_bind_by_name($s, ':bv', $v, 20, SQLT_CHR);
foreach ($a as $v) {
$r = oci_execute($s, OCI_DEFAULT);
}
oci_commit($c);
Or explore calling a PL/SQL block and do a bulk FORALL insert.
I'll blog about bulk FORALL in a few days.
Chris
--
Christopher Jones, Oracle
Email: [EMAIL PROTECTED
using PHP string concatenation.
Chris
--
Christopher Jones, Oracle
Email: [EMAIL PROTECTED]Tel: +1 650 506 8630
Blog: http://blogs.oracle.com/opal/
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
exist within the library.)
Thank you for any help you can offer. I have searched the web and the
archives of this list but I couldn't find much.
--
Christopher Jones, Oracle
Email: [EMAIL PROTECTED]Tel: +1 650 506 8630
Blog: http://blogs.oracle.com/opal/
--
PHP Database Mailing List (http
of installation documents that show how to configure
PHP with oci8 enabled. One is at:
http://www.oracle.com/technology/tech/php/pdf/underground-php-oracle-manual.pdf
Chris
--
Christopher Jones, Oracle
Email: [EMAIL PROTECTED]Tel: +1 650 506 8630
Blog: http://blogs.oracle.com/opal/
--
PHP
client for linux ( I just wonder why).
Thanks.
On 12/27/06, Christopher Jones [EMAIL PROTECTED] wrote:
PHP's oci8 extension on Windows is now compiled with an Oracle 10g client
and depends on new functionality in it. The 10g Oracle Instant Client is
freely available (and trivial to install) from
?
--
Christopher Jones, Oracle
Email: [EMAIL PROTECTED]Tel: +1 650 506 8630
Blog: http://blogs.oracle.com/opal/
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
/) To unsubscribe, visit:
http://www.php.net/unsub.php
--
Christopher Jones, Oracle
Email: [EMAIL PROTECTED]Tel: +1 650 506 8630
Blog: http://blogs.oracle.com/opal/
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
/technology/forums/xml.html
The people who monitor those lists are specialists.
Chris
Ritesh Nadhani wrote:
I just checked: http://www.oracle.com/technology/tech/xml/xmldb/index.html
Is the solution free or we have to pay license cost? I dont see any
information about that.
Christopher Jones wrote
. PHP is running on my local box.
I've got TNS_ADMIN set as an env variable
Any help gratefully received :-)
Cheers
Steve
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
Christopher Jones, Oracle
Email: [EMAIL PROTECTED]Tel: +1
the network listener to get encrypted traffic. Check your license too:
the Advanced Security Option (ASO) is probably a separately licensble
product.
Chris
--
Christopher Jones, Oracle
Email: [EMAIL PROTECTED]Tel: +1 650 506 8630
Blog: http://blogs.oracle.com/opal/ Free PHP Book: http://tinyurl.com
on page 141 of
the current (1.4) version of
http://www.oracle.com/technology/tech/php/pdf/underground-php-oracle-manual.pdf
Also see the use of SDO_UTIL.GETVERTICES in
http://forums.oracle.com/forums/thread.jspa?messageID=1448667#1448667
Chris
--
Christopher Jones, Oracle
Email: [EMAIL PROTECTED
/tdtdeinepid/td/tr/table
(The value is repeated because the array contains numerically and
associatively indexed values.)
Chris
--
Christopher Jones, Oracle
Email: [EMAIL PROTECTED]Tel: +1 650 506 8630
Blog: http://blogs.oracle.com/opal/ Free PHP Book: http://tinyurl.com/f8jad
--
PHP Database
projekte_generisch where pid='u0test'
PID ANFANG ENDELAENGE
u0test utest 8
Hope this helps diagnosting the error.
Do other queries with binds work? Is PHP using the correct
NLS language configuration?
Chris
--
Christopher Jones, Oracle
Email: [EMAIL PROTECTED]Tel: +1 650 506 8630
Blog
) to the former but not the latter.
If anyone volunteers to write some test cases I can merge a patch to
OCI8 to allow:
oci_bind_by_name($s, ':bv', $bv, -1, SQLT_AFC);
Chris
--
Christopher Jones, Oracle
Email: [EMAIL PROTECTED]Tel: +1 650 506 8630
Blog: http://blogs.oracle.com/opal
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
Walter Galvão wrote:
Hi,
Im using the oracle instant client basic in my php app, with apache server.
When a query returns few rows, there is no problem.
Otherwise, the oci_execute method doesn return any records neither errors!
How can i solve this problem??
My implementation:
function
Walter Galvão wrote:
Are you exceeding the PHP script time out, or exceeding the memory
limit?
I dont know. Doesnt appear any message. The script prints the
last message before the oci_execute call.
I'd start by looking at the max_execution_time and memory_limit settings in
php.ini.
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
mignon hunter wrote:
I'm am trying to find some definitive best practises on database connections
with php on both mysql and oracle.
I'm starting to redesign a corporate website and am trying to find out more
about security and the best practises for database queries and user input form
mignon hunter wrote:
Hi Christopher
One other question. Our current site is written in jsp with
Oracle. I'd like to use PHP. Do you have any thoughts on this?
My recommendation is to utilize the existing skills you have; this
echoes Fergus's comment. However, PHP is very popular and if
Hi Fred,
[EMAIL PROTECTED] is a development mail list. The best place to
post to is [EMAIL PROTECTED] I'm ccing that list: please remove
pecl-dev from any followup mail.
Fred Silsbee wrote:
I have Fedora 9 2.6.27.5-37.fc9.i686 and Oracle 11g1
[EMAIL PROTECTED] oci8-1.3.4$ phpize also
Fred Silsbee wrote:
provide some detailed instructions for oc8/linux install that leave no gaps
instructions that work for newbies
For newbies we recommend installing Zend Core for Oracle.
Are you the same person as person who has been posting to the OTN
forum, e.g. this post
I'm CCing the php-db list.
Fred Silsbee wrote:
install Zend?...never! I have Fedora 9 and 11g1 Enterprise
I have Apache working and Oracle 11g1 installed and working!
Zend installs both of these and could screw up my working system.
Zend Core for Oracle will use your existing Apache.
It
I'm CCing php-db again.
Fred Silsbee wrote:
This worked:
sqlplus hr/[EMAIL PROTECTED]
so I tried: (didn't work)
if ($conn=oci_connect('hr', 'hr', '//localhost/LMKIIIGD'))
Excuse me repeating the example PHP code I gave earlier for this
SQL*Plus case:
Or if you connect like:
Fred Silsbee wrote:
there is a file /etc/httpd/conf/httpd.conf
I tried putting the ORACLE_HOME in this file but it failed
What failed and how?
How was it set?
[phpinfo output of]
Compile-time ORACLE_HOME no value
The lack of a value here is an artifact aka buglet of installing from
Fred Silsbee wrote:
GREAT!!but how!
How what?
http://us.php.net/manual/en/oci8.setup.php
What about it?
[phpinfo output of]
Compile-time ORACLE_HOME no value
The lack of a value here is an artifact aka buglet of
installing from
the PECL package. I'll add it to the
Fred Silsbee wrote:
http://bugs.php.net/bug.php?id=43186
Why do you think it's a clue? Are you getting a crash?
Does your PHP command line work?
So far we have almost zero information about your configuration in particular
we don't have phpinfo() output (despite suggestions you check it).
Fred Silsbee wrote:
I have the following in /etc/httpd/conf/httpd.conf
SetEnv ORACLE_HOSTNAME localhost.localdomain
SetEnv TNS_ADMIN /u01/app/oracle/product/11.1.0/db_1/network/admin
SetEnv ORACLE_BASE /u01/app/oracle
SetEnv ORACLE_HOME /u01/app/oracle/product/11.1.0/db_1
SetEnv
Themis Vassiliadis wrote:
On Tue, Dec 2, 2008 at 4:18 PM, Christopher Jones
[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote:
Oracle 11g DRCP support is available in PHP. See this whitepaper:
http://www.oracle.com/technology/tech/php/pdf/php-scalability-ha-twp.pdf
Change
Themis Vassiliadis wrote:
DRCP is really a big improvement. But for me it has a great holdback:
the pool controlled in the server side isn't defined for a specific
schema, so if we have an application server serving different
connections demanding different credentials certainly the
Tonado wrote:
Hi all,
I used the following in my code
oci_connect('$user','$pass',$connectionString,'UTF8');
and got the following warning:
Warning: oci_connect() [function.oci-connect]: Invalid character set
name: UTF8
I tried many times and found it could only work when I
Jérôme Loyet wrote:
Hello,
I used to use oci8 version 1.2.3 and I wanted to update to last
version (1.3.4). Everything works fine except the fact that
sqlnet.ora does not seems to be read.
I use the following string to describe my database in oci_connect: MEN1PRD.
In sqlnet.ora there is
Jérôme Loyet wrote:
My init script where the ENV are set:
export ORACLE_HOME=/usr/local/oracle/VERSIONS/Linux/CL.9.2.0
PATH=$PATH:$ORACLE_HOME/bin:$ORACLE_HOME/network/admin:$ORACLE_HOME/lib:/usr/local/bin
(The admin and lib directories aren't needed in the PATH because they
don't contain
Chris wrote:
Warning: ocilogon() [function.ocilogon]: OCIEnvNlsCreate() failed.
There is something wrong with your system - please check that
LD_LIBRARY_PATH includes the directory with Oracle Instant Client
libraries in/Library/WebServer/Documents/oracle.php on line 25
Oracle
Grant Croker wrote:
DYLD_LIBRARY_PATH=/opt/oracle/instanceclient
LD_LIBRARY_PATH=/opt/oracle/instanceclient
ORACLE_BASE=/opt/oracle/instanceclient
ORACLE_HOME=/opt/oracle/instanceclient
export DYLD_LIBRARY_PATH LD_LIBRARY_PATH ORACLE_BASE ORACLE_HOME
(note: As Chris Jones mentioned
Thomas Robitaille wrote:
I've managed to fix the issue by switching to a 32-bit installation of
MySQL and Apache. The problem appeared to be due to the 64-bit versions
somehow.
If you think there's a bug (and you tested the latest version of PHP),
please report the problem at
kesavan trichy rengarajan wrote:
could be rewritten as:
mysqli_stmt_bind_param($submitadmin, isss, $numrows, $admin,
sha1($password), $email);
Turning on E_STRICT in PHP 5.3 will show
PHP Strict Standards: Only variables should be passed by reference
This is also true in earlier
Fred Silsbee wrote:
Oracle Connect Error
What error? What Oracle client libraries do you have? Where
are they located
just upgraded Fedora 9-10
using new php.ini file containing:
; Note: packaged extension modules are now loaded via the .ini files
; found in the directory
Fred Silsbee wrote:
in /etc/httpd/conf/httpd.conf
SetEnv ORACLE_HOSTNAME localhost.localdomain
SetEnv TNS_ADMIN
/u01/app/oracle/product/11.1.0/db_1/network/admin
SetEnv ORACLE_BASE /u01/app/oracle
SetEnv ORACLE_HOME /u01/app/oracle/product/11.1.0/db_1
SetEnv ORACLE_SID lmkiiiGDNSID
Sanjeev Kumar wrote:
Hi,
In the implemetation of Pdo-driver (extension) , what's the Sequence/Index
scheme for parameter: 'colno' ?
This param 'colno' is input in driver calls (of PDO statement) :
int SKEL_stmt_describe_col(pdo_stmt_t *stmt, int colno TSRMLS_DC)
int
Now that Oracle Database 11.2 has been released
(http://blogs.oracle.com/opal/2009/09/oracle_database_11gr2_enhancem.html),
we'd like to make some enhancements to PHP OCI8 for PHP 5.3.2 PHP 6:
1. Allow the oci_set_prefetch() count to be 0, i.e. just fetch/buffer
one row at a time and don't
Andy Shellam (Mailing Lists) wrote:
First, when connecting, the function would first try to find a
(persistent) link that's already open with the same host, username
and password. If one is found, an identifier for it will be returned
instead of opening a new connection.
Therefore,
, but perhaps it would be worth waiting for 5.3.
-Sara
The mysqli extension appears to use mysqli_ as the hash key prefix
so there won't be PHP connection structure sharing here either.
Chris
Christopher Jones wrote:
Andy Shellam (Mailing Lists) wrote:
First, when connecting, the function
1 - 100 of 114 matches
Mail list logo
