On Sep 10, 2008, at 4:14 AM, John Scoles wrote:
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
How do I do this?
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??
RDB is Oracle's Data Warehouse RDBMS that runs on VMS...it used to be
a DEC product. RDB OCI Server is the component that lets the RDB
database look like an Oracle database to the outside world, so I can
query it using the normal OCI calls, use it via Database Links, etc.
I and our RDB DBA checked out the compatibility issue first, the
latest version of the OCI pServer emulates a Oracle 10.2 database.
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?
--
Bruce Johnson
University of Arizona
College of Pharmacy
Information Technology Group
Institutions do not have opinions, merely customs
