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?
--
Bruce Johnson
University of Arizona
College of Pharmacy
Information Technology Group
Institutions do not have opinions, merely customs
