Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> ORA-01843

ORA-01843

From: Tyler Smith Watu <watuni2000_at_yahoo.co.nz>
Date: 30 Mar 2004 12:38:33 -0800
Message-ID: <2f3438a4.0403301238.70aad38a@posting.google.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US