RE: explain plan works when using vi, but fails with microsoft cl ient

From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
Date: Wed, 14 Jul 2004 08:21:56 -0500
Message-ID: <0186754BC82DD511B5C600B0D0AAC4D607B009E9@EXCHMN3>

Raj - Much as I think Microsoft doesn't get a fraction of the blame it richly deserves, in this case I think the fault lies entirely with Oracle. IIRC, they made a change to autotrace. When you log directly in to Unix, your "client" is 9.2.0.3, so there is no incompatibility. Theoretically, if you used an earlier SQL*Plus version on Unix to connect to your 9.2.0.3 or later database you would receive this error.

Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com
I said it "looked" clear - Riddick

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Raj Jamadagni Sent: Wednesday, July 14, 2004 8:18 AM
To: oracle-l_at_freelists.org
Subject: RE: explain plan works when using vi, but fails with microsoft cl ient

Or in other words ... there are some things that you just can't explain about (or with) Microsoft.

<g>
Raj
--- DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM> wrote:
> Ryan
> Yes, you need to upgrade the Windows client. Some change was made with
> 9.2.0.3 that makes it incompatible for autotrace with earlier versions of
> the client. Sounds weird, but that is the solution.
>

Best Regards
Raj

select mandatory_disclaimer from company_requirements;

Do you Yahoo!?
Yahoo! Mail Address AutoComplete - You start. We finish. http://promotions.yahoo.com/new_mail

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Wed Jul 14 2004 - 08:23:31 CDT