Re: ORA-01843

From: Anurag Varma <avdbi_at_hotmail.com>
Date: Tue, 30 Mar 2004 22:10:16 GMT
Message-ID: <cfmac.22183$u_2.18834@nwrddc01.gnilink.net>

"Tyler Smith Watu" <watuni2000_at_yahoo.co.nz> wrote in message news:2f3438a4.0403301238.70aad38a_at_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

ughhh

Can you look at the format of the start_time in v$transaction. Isn't it like this: 03/30/04 16:05:48

its not like this: 30-MAR-04 16:05:48 ... is it?

Anurag Received on Tue Mar 30 2004 - 16:10:16 CST