Re: PHP 4.3.4, ADODB and Oracle9.2
| From: | Christopher Jones | Date: | Mon, 19 Jan 2004 08:13:57 +0000 |
| Subject: | Re: PHP 4.3.4, ADODB and Oracle9.2 | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-32486@lists.php.net to get a copy of this message | ||
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 128You might be hitting a combination of problems. I noticed the message "Error while trying to retrieve text". This means that your ORACLE_HOME is not set properly somewhere, and after the ORA-12538 occurs Oracle can't look up actual text for it. Other, more important things are likely to fail if the environment is not set properly. There's a note about the environment variables and Apache in the Oracle/PHP troubleshooting FAQ: http://otn.oracle.com/tech/opensource/php/php_troubleshooting_faq.html#envvars It might give some background that applies to IIS too. As to why the ORA error occurs - I'm not sure yet. I've seen ORA-12538 with ADOdb 4.10 in scripts that work with ADOdb 3.60. See http://phplens.com/lens/lensforum/msgs.php?id=8330 Chris