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.
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center