can you see the DB_LINK in Oracle select * from user_db_links? Martin "I write the songs" - Bruce Johnston ______________________________________________ Disclaimer and confidentiality note This message is confidential and may be privileged. If you are not the intended recipient, we kindly ask you to please inform the sender. Any unauthorised dissemination or copying hereof is prohibited. This message serves for information purposes only and shall not have any legally binding effect. Given that e-mails can easily be subject to manipulation, we can not accept any liability for the content provided.
> From: john...@pharmacy.arizona.edu > To: dbi-users@perl.org > Subject: Re: Problem with Oracle ODBC connection > Date: Tue, 31 Mar 2009 11:56:37 -0700 > > > On Mar 31, 2009, at 10:25 AM, Peter J. Holzer wrote: > > > I assume that the RDB OCI server emulates an Oracle 8i server (or > > something even older). > > The current version of the software emulates a Oracle 10.2 server. > This isn't the issue; it's something internal to the way that oracle > handles a database link, because if you connect directly to the RDB > OCI interface using the modern client libs, (or directly to RDB itself > through the RDB ODBC or JDBC client software) it works, the only way > the problem emerges is through the database link in Oracle 11 to the > OCI interface. > > As I said it's a weird thing....it's that the 'thwe query is > successful but doesn't return rows' of the OP in this thread is the > same symptom that I have. > > -- > Bruce Johnson > University of Arizona > College of Pharmacy > Information Technology Group > > Institutions do not have opinions, merely customs > > _________________________________________________________________ Quick access to Windows Live and your favorite MSN content with Internet Explorer 8. http://ie8.msn.com/microsoft/internet-explorer-8/en-us/ie8.aspx?ocid=B037MSN55C0701A
