Loosing NLS_DATE_FORMAT while working...
Date: 20 Mar 1995 21:26:58 GMT
Message-ID: <3kkrv2$ps2_at_noc.tor.hookup.net>
I have a problem with the NLS_DATE_FORMAT. I use VB 3.0 and ORACLE GLUE to acces an ORACLE 7 database. In my VB program, I send an ALTER SESSION command to change my date format to YYYYMMDD. This works well.
After maybe 15 or 30 minutes of work, I get an ORACLE error 1843-invalid month. I handle this error by sending again the ALTER SESSION command, followed by the command that gives the error and, this time, everything's ok.
But I couldn't handle the problem when it occurs on a SELECT, because I don't get an error. I just get the data in a bad format.
So, I thing the Oracle database loose the NLS_DATE_FORMAT I set up, but I don't know why and ORACLE SUPPORT didn't find anything.
Can anyone help ?
Thanks in advance.
acottier_at_montreal.src.ca Received on Mon Mar 20 1995 - 22:26:58 CET