Well that is a head scratcher. It will be hard to replicate this error
so look like you will have to do the debugging for us.
If you can set up a small Perl script that you know works in the old
system and then set the debug level to at least 6
next if you can run the same script on your new location
If you can send the output to the list we might be able to see what is
going on.
I am not sure what Oracle Rdb OCI Server is so I will have to ask one
of DBs here what it is used for. Perhaps the product is no longer
support in 10 and 11??
cheers John Scoles
Bruce Johnson wrote:
I've been banging my head against the wall for two weeks now on this one.
I'm desperately trying to update my existing production system (Oracle
8.1.7, DBD::Oracle 1.14, on a system with a dying RAID controller) to
a new system running a current version of Oracle. and have run into a
really nasty snag.
Oracle versions: two systems, one 10.2.0.1 the other 11.1.0.6
I have a database link to an RDB system via Oracle's Rdb OCI Server.
(RDB info:
Oracle
Oracle Compatible Release 10.2.0.2.0
Oracle Rdb OCI Server Release 7.3.0.0.1 - Production, Level 1.7
Oracle Rdb SQL Release 7.2.3.1.0 - Production
Oracle JDBC driver
9.0.1.0.0
)
Using DBD::Oracle 1.17 and 1.22
Oracle client versions used:
8.1.7 (I copied my entire 8.1.7 product directory over, kind of like
duct-taping a pickup truck to the side of your car so you can use it's
gas cap..it would be nice to know what I could jettison...)
Instant Client 10.1
Instant Client 10.2
native clients for 11.1 and 10.2
My problem is that UNLESS I build DBD::Oracle against the 8.1.7 client
I cannot query the RDB database through the database link using
DBD::Oracle, even though the query works JUST FINE in SQLPlus or
through a JDBC tool like DBVisualizer.
I don't get an error, just no data is returned.
I've used tcpdump to watch the transactions.
I can see the direct link to the RDB OCI server, the connection get
made, the query passed on, and the data come back.
When I look at a query through the database link, I can see the
connection made, the query passed on, and column names come back, but
no data.
I can watch the SAME QUERY being run through SQLPlus and it works.
Is this a DBD::Oracle bug? an OCI bug? Something I haven't thought of?
