ORA-01843: not a valid month
759148Mar 11 2010 — edited Mar 11 2010declare
V_CREATED_DATE DATE;
begin
SELECT TO_CHAR(SYSDATE, 'MM/DD/YYYY HH24:MI:SS') INTO V_CREATED_DATE FROM DUAL;
end;
when i execute my pl/sql show error: ORA-01843: not a valid month.
i try use ALTER SESSION SET NLS_DATE_FORMAT ='MM/DD/YYYY HH24:MI:SS'; but it's not working.. please help me. Thanks