[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
Tools upgrade SQR 3 to SQR 4 problems
- Subject: Tools upgrade SQR 3 to SQR 4 problems
- From: "Wendel, Robbi" <rwendel@NESPOWER.COM>
- Date: Mon, 13 Sep 1999 09:28:48 -0500
We are starting our Tools conversion from 7.01 to 7.05 which
includes the SQR upgrade(3.0.18.1. to 4.3.4). Our database is Oracle 7.3.4
In our initial testing of our custom SQR's we are running into this warning
Warning on line 250:
(SQR 7501) Using YY edit mask from (DD-MON-YY) against (1999)
Where at the same time we seem to be having successful execution of ALTER
SESSION
showing the four digit year being set to YYYY(see below)
Cursor #1:
SQL = ALTER SESSION SET NLS_DATE_FORMAT='DD-MON-YYYY'
Compiles = 1
Executes = 1
Rows = 0
These same SQR's run fine in the old version. What else do we need to
change?
Any thoughts would be appreciated!
TIA,
Robbi Anne Wendel
SCT Corporation
rwendel@nespower.com
(615) 747-3078