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
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If you forgot your password, you can retrieve your password here.
Password:
Status:
Package:
Bug Type:
Summary:
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 \
	--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

Pull Requests

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-2025 The PHP Group
All rights reserved.
Last updated: Wed Feb 05 13:01:33 2025 UTC