|
php.net | support | documentation | report a bug | advanced search | search howto | statistics | random bug | login |
PatchesPull RequestsHistoryAllCommentsChangesGit/SVN commits
[2006-04-20 12:26 UTC] tony2001@php.net
[2006-04-20 12:40 UTC] jerome dot kaluza at skynet dot be
|
|||||||||||||||||||||||||||
Copyright © 2001-2025 The PHP GroupAll rights reserved. |
Last updated: Fri Oct 24 13:00:02 2025 UTC |
Description: ------------ I have a problem using OVI8 api with oracle 10g release 2 i am using open suse 10.0, apache 2.2, oracle 10g release 2 and PHP 5.1.2 ORACLE_HOME is defined as well as the SID, the command line will work when i don't specify SID, if i specify a third parameter to oci_connect, the operation will fail. (not TNS resolved) i have configured PHP with this custom configure : #!/bin/sh export OPTIM=-02 ./configure --prefix=/usr/local \ --with-apxs2=/usr/local/bin/apxs \ --with-inifile=/usr/local/etc/php.ini \ --with-xsl \ --enable-soap \ --with-gettext \ --with-oci8=/opt/oracle/product \ --enable-mbstring --with-mbstring=all \ --enable-memory-limit \ --disable-debug \ --with-libxml-dir=/usr/lib \ I hope this will be fixed soon as i saw while browsing that this problem occured a certain number of times to several different php users Reproduce code: --------------- function connecter() { try { self::$connexion = ADONewConnection(self::BD); if (!self::$connexion){ throw new ExceptionStock("Connexion impossible au serveur de base de donn?e Oracle!"); } //self::$connexion->debug = true; if (!self::$connexion->PConnect(self::TNS,self::$login,self::$motDePasse)){ throw new ExceptionStock("Connexion impossible ? la base ". "de donn?e ".self::TNS."!"); } self::executerRequete("ALTER SESSION SET nls_numeric_characters='.,'"); } catch (Exception $e){ die($e->getMessage()); } } Expected result: ---------------- the application should access database, verify the user exists in users sql table and then redirect on the default user's page Actual result: -------------- Warning: ociplogon() [function.ociplogon]: OCIEnvNlsCreate() failed. There is something wrong with your system - please check that ORACLE_HOME is set and points to the right directory in /srv/www/stock/lib/adodb/drivers/adodb-oci8.inc.php on line 212