php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #2489 Error while parsing SELECT from 2 instances
Submitted: 1999-10-11 07:17 UTC Modified: 1999-11-02 12:58 UTC
From: webmaster at bpcbs dot com Assigned:
Status: Closed Package: Oracle related
PHP Version: 3.0.12 OS: Linux 2.2.5 (RedHat)
Private report: No CVE-ID: None
 [1999-10-11 07:17 UTC] webmaster at bpcbs dot com
I have an error when trying to access another instance of pyra through
a database link

PHP is built with Oracle 8.0.5 for Linux connected to
Oracle 7.3.4

There is no php3.ini

./configure \
	--with-apache=/home/web/apache_1.3.9 \
	--with-oracle=/home/oracle \
	--with-zlib \
	--enable-sysvshm=yes \
	--enable-sysvsem=yes \
	--with-config-file-path=/etc \
	--with-system-regex=yes \
	--with-exec-dir=/home/web/php-bin \
	--enable-track-vars=yes \
	--enable-bcmath=yes \
	--enable-memory-limit=yes

pyra is a public database link, this select is working on sqlplus.

<?PHP
        $conn = ora_logon("catalog/xxxx@xbpc_bpc","xxxx");
        ora_commitoff($conn);
        $curs = ora_open($conn);

        $err = ora_parse($curs, "SELECT * from artic@pyra");
?> 

Warning: Ora_Parse failed (ORA-02248: invalid option for ALTER SESSION ORA-02063: preceding line from PYRA -- while processing OCI
function OPARSE) in /bpc/intra.bpcbs.com/seb/oracle/bug.php3 on line 6

Using a synonym or view of the remote table doesn't solve this error.

Patches

Add a Patch

Pull Requests

Add a Pull Request

History

AllCommentsChangesGit/SVN commitsRelated reports
 [1999-11-02 12:58 UTC] webmaster at bpcbs dot com
ORACLE_HOME was not defined, added in /etc/rc.d/init.d/httpd
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved.
Last updated: Thu Mar 28 13:01:28 2024 UTC