Re: NLS parameters

From: Jonathan Knight <knightjck_work_at_yahoo.com>
Date: Thu, 27 Apr 2006 12:46:46 -0700 (PDT)
Message-ID: <20060427194646.10259.qmail@web60624.mail.yahoo.com>

I found it! The problem (feature?) is with SQL*Navigator. I should have mentioned that I was using it. It executes alter session on connect to change the NLS_DATE_FORMAT to whatever is configured in the user options (which I changed recently).

Testing from SQL*Plus yields the correct format.

Many thanks for the help, and sorry to start a wild goose chase. He's been caught!

Jon Knight

---

Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Apr 27 2006 - 14:46:46 CDT