|  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
View Add Comment Developer Edit
Welcome! If you don't have a Git account, you can't do anything here.
You can add a comment by following this link or if you reported this bug, you can edit this bug over here.
Block user comment
Status: Assign to:
Bug Type:
From: webmaster at bpcbs dot com
New email:
PHP Version: OS:


 [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 \

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

        $conn = ora_logon("catalog/xxxx@xbpc_bpc","xxxx");
        $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/ on line 6

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


Add a Patch

Pull Requests

Add a Pull Request


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-2021 The PHP Group
All rights reserved.
Last updated: Wed Aug 04 07:01:24 2021 UTC