Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2002
    Posts
    4

    Unhappy Unanswered: NLS_DATE_FORMAT problem on Oracle 8i

    Hi,

    I'm using an Oracle 8.1.7 version.

    I'm trying to modify, at the instance level, the value of NLS_DATE_FORMAT, in order to meet my needs (I need the modification to be definitive, not limited to a session).

    I've found some urls talking about modifying my DB specific init file "dbs/ora<SID_name>.init" by inserting the following line:
    NLS_DATE_FORMAT = 'DD/MM/YY HH:MI AM'

    but this was no help : after a shutdown and a restart the format stayed the same as the default one ; I verified it with the command:
    select * from nls_database_parameters;
    Though, the added line is indeed treated, since invalidating it by a modification causes the startup to fail.


    Did I forget something? Or isn't it the way to do it with 8i?

    Thanks in advance,

    Gabriel

  2. #2
    Join Date
    Jan 2002
    Location
    italy
    Posts
    39
    Yous steps seem to be correct...

    What do you see if you try from sqlplus

    show parameter nls_date_format

    Do you see the same as from the table nls_database_parameters?

    And if you select systdate from dual what do you see?

    Is it possible that you have a logon trigger that changes your session?


    astropp

  3. #3
    Join Date
    Jan 2002
    Posts
    4
    Hi,

    Thanks for your reply,

    I actually found out that I needed to execute the sql script 'catproc.sql' in order to do the 'dbms_session.set_nls' operation...

    Though, that didn't allow to set the NLS_DATE_FORMAT (for example) to MM/DD/YY (because of the '/'), although the ALTER_SESSION accepts it.

    Sounds like a bug, uh?

    Thanks again,

    Gabriel


    Originally posted by astropp
    Yous steps seem to be correct...

    What do you see if you try from sqlplus

    show parameter nls_date_format

    Do you see the same as from the table nls_database_parameters?

    And if you select systdate from dual what do you see?

    Is it possible that you have a logon trigger that changes your session?



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •