Re: Pro*C and Y2K

Hi David,
The NLS settings for any client program are taken from the respective environment variables. If these variables don't exist the defaults are used. The default NLS_DATE_FORMAT is DD-MON-YY. Start of a sqlplus session and you will see precisely the same alter session statement. If these settings make it into the executables that's bad. It will mean you need to set the env vars in your .profile and ... recompile everything.
Try this with one program and let us know the outcome.

Hth,

Sybrand Bakker, Oracle DBA

David Chemla wrote in message <3756D092.73AD49CA_at_club-internet.fr>...
>
>Hi,
>
>I'm running Oracle 7.3.4 on Unix NCR.
>
>I had a look today at the V$SQLAREA of my database on which
>people were working.
>
>I saw many times executed the
>"alter session ... NLS_DATE_FORMAT='DD-MON-YY'" statement,
>the default value being DD-MON-RR in the initSID.ora.
>
>I think this comes from the Pro*C compilation. In fact, if I
>grep the statement, I can find it in all my Pro*C BINARIES but
>never in my source files.
>
>I don't know much about the Pro*C precompiler. Would anyone
>have an idea on how to correct this problem ?
>
>Thanks a lot by advance for any suggestions.
>
>David.
Received on Thu Jun 03 1999 - 14:22:31 CDT