Re: Bug #2489: Error while parsing SELECT from 2 instances

On 11 Oct 1999 webmaster@bpcbs.com wrote: > 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. hmm, it could be the ora_commitoff($conn); please try without. tc > > > > -- > PHP Development Mailing List <http://www.php.net/> > To unsubscribe, e-mail: php-dev-unsubscribe@lists.php.net > For additional commands, e-mail: php-dev-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net > > Thies C. Arntzen "One Big-Mac, Small Fries and a Coke!" Digital Collections Phone +49 40 235350 Fax +49 40 23535180 Hammerbrookstr. 93 20097 Hamburg / Germany