From: tgross@rhrk.uni-kl.de (Thomas Gross)
Subject: DBI-Oraperl Problem with empty Result Sets
Date: 2000/05/04
Message-ID: <slrn8h2jc5.btii.tgross@aixd1.rhrk.uni-kl.de>#1/1
Organization: University of Kaiserslautern, Germany
User-Agent: slrn/0.9.5.4 (UNIX)
Newsgroups: comp.database.oracle,comp.databases.oracle,comp.databases.oracle.tools,comp.lang.perl.modules



Hi everyone,

i'm having a problem with oraperl. I'm using the current DBI and DBD-Oraperl 
from CPAN. I have tested this with perl-5.0005 and perl5.6. Both from 
HP-UX and Linux as a client machine. The Oracle Database Server is Oracle 7.x
running on HP-UX. Oh yes DBD-Oraperl is linked against an Oracle 8 Client 
installation on both clients.

There is a Problem fetching data from an Oracle 7 Database.

I can connect to the Database und start a query. The query is parsed by the
Database. I'm sure of this because i get the right error messges if there is
something wrong with the query.

The Problem is that i only get empty result sets. There are no rows to fetch.
If i try the very same query with sqlplus i get the correct results. Perhaps
this is because i'm tryring to fetch data vom a view combinig several tables.
I have another Oracle 7 Database running on a different host which work normal.
But there i'm fetching from regular tables.

Anybody has had this problem before. Any suggestions?

Could you please answer per email to tgross@rhrk.uni-kl.de in addition 
to posting here? I sometimes have a hard time getting the newsgroups.

 Thanks
   Thomas