Received the error "ORA-01843: not a valid month" when a Cursor is opened while stepping through the following procedure.
CREATE OR REPLACE PROCEDURE Temp IS
CURSOR c1 IS SELECT membno,penlog FROM LOGTAB WHERE penlog =
'24-07-2006 14:49:19';
TYPE logtab_rec IS RECORD (
MEMBNO LOGTAB.MEMBNO%TYPE,
PENLOG LOGTAB.PENLOG%TYPE);
c1_rec LOGTAB_rec;
BEGIN
OPEN c1;
LOOP
FETCH c1 INTO c1_rec;
EXIT WHEN c1%NOTFOUND;
DBMS_OUTPUT.PUT_LINE ('Cursor Opened');
END LOOP;
CLOSE c1;
END;
The Procedure works fine in SQL*Plus. When the individual select statement of the format: SELECT membno,penlog FROM LOGTAB WHERE penlog = '24-07-2006 14:49:19' is executed in the SQL Editor Window it works fine.
WORKAROUND:
None
STATUS:
An Enhancement has been submitted for the future release of Toad for Oracle.
NLS_SESSION_PARAMETERS
NLS_DATE_FORMAT DD-MM-YYYY HH24:MI:SS
NLS_DATABASE_PARAMETERS
NLS_DATE_FORMAT DD-MON-RR
© 2021 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy