Re: No data returned from linked database
- From: johnson@xxxxxxxxxxxxxxxxxxxx (Bruce Johnson)
- Date: Wed, 10 Sep 2008 09:53:50 -0700
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
.
- Follow-Ups:
- Re: No data returned from linked database
- From: Douglas Wilson
- Re: No data returned from linked database
- References:
- No data returned from linked database
- From: Bruce Johnson
- Re: No data returned from linked database
- From: John Scoles
- No data returned from linked database
- Prev by Date: Re: No data returned from linked database
- Next by Date: Re: No data returned from linked database
- Previous by thread: Re: No data returned from linked database
- Next by thread: Re: No data returned from linked database
- Index(es):
Relevant Pages
|
