Re: ORA-01843

Tyler Smith Watu wrote:

> 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

Try this:

SELECT to_date(t.start_time, 'DD-MON-YY:HH24:MI:SS') FROM v$transaction;

What do you get?

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)