Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> ORA-01843
Hp Unix 11
Oracle 8.1.7.4
I have created a procedure with no errors but when run it gives
ERROR at line 1:
ORA-01843: not a valid month ORA-06512: at "ORACLE.LONGTRANSPROC", line 3 ORA-06512: at line 1
Did not find much while searching metalink
Here is line 3 and related sql
(select t.start_time,s.sid,s.serial#,replace(substr(s.client_info,0,8),',')
Name from v$transaction t,v$session s
where s.taddr=t.addr and to_date(t.start_time,
'DD-MON-YY:HH24:MI:SS') <(SYSDATE-(1/(96)))is supposed to be the
invalid date at line 3
Select sysdate from dual is 30-MAR-04
Thanks for your time
TY Received on Tue Mar 30 2004 - 14:38:33 CST