Bug #2489: Error while parsing SELECT from 2 instances

From: webmaster@bpcbs.com Operating system: Linux 2.2.5 (RedHat) PHP version: 3.0.12 PHP Bug Type: Oracle related Bug description: Error while parsing SELECT from 2 instances 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.