Re: ALTER SESSION SET NLS_DATE_FORMAT = 'DD-MON-RR'

From: Doug C. <dcowles_at_i84.net>
Date: Wed, 05 Sep 2001 21:08:45 -0400
Message-ID: <vvidpto078d3k0d58g52ek5igolhn5j1l8@4ax.com>

I just ran into this myself ... could it be the DBAccess.java file? If you are using classes12.zip that comes with Oracle 8.1.7, this could be the case. Have no fear, the cursors are closed.

 Here is part of it decompiled:

    protected void setNlsParamsClient(OracleConnection oracleconnection)

        throws SQLException
    {

        if(OracleLog.TRACE)
            OracleLog.print(oracleconnection, 2, 16,


"DBAccess.setNlsParamsClient()");

        Statement statement = null;
        Object obj = null;
        String s = null;
        try
        {
            statement = oracleconnection.createStatement();
            NLSLocale nlslocale = NLSLocale.getInstance();
            String s1 = nlslocale.getNLSLanguage(Locale.getDefault());
            if(s1 != null)
                statement.execute("ALTER SESSION SET NLS_LANGUAGE = '" + s1
+ "'");
            String s2 = nlslocale.getNLSTerritory(Locale.getDefault());
            if(s2 != null)
                statement.execute("ALTER SESSION SET NLS_TERRITORY = '" + s2
+ "'");
            ((OracleStatement)statement).setRowPrefetch(1);
            ResultSet resultset = statement.executeQuery("SELECT VALUE FROM
NLS_INSTANCE_PARAMETERS WHERE PARAMETER ='NLS_DATE_FORMAT'");
            if(resultset.next())
            {
                s = resultset.getString(1);
                if(s != null)
                    statement.execute("ALTER SESSION SET NLS_DATE_FORMAT =
'" + s + "'");
            }
            if(OracleLog.TRACE)
                OracleLog.print(oracleconnection, 2, 1,

"DBAccess.setNlsParamsClient(): NLSLanguage=" + s1 + ", NLSTerritory=" + s2
+ ", DateFormat=" + s);

        }
        catch(SQLException _ex) { }
        finally
        {
            if(statement != null)
                statement.close();
            statement = null;
        }

    }

On Wed, 5 Sep 2001 16:56:31 +0200, "Yossi Galazan" <yossi.galazan_at_emblaze.com> wrote:

>
>I looked at v$session and v$sqlarea tables
>and find the text:
>"ALTER SESSION SET NLS_DATE_FORMAT = 'DD-MON-RR'"
>The text repeated  many times each time with different sid and with the
>status of inactive.
>Who is running this command? and why does it happand?
>Any help?
>Yossi Galazan
>yossi.galazan_at_embalze.com
>
>

Received on Wed Sep 05 2001 - 20:08:45 CDT