Re: Need another set of eyes

Originally posted by Ed Stevens
> Platform: Oracle 8.1.7.4 on Win2k.
>
> Playing around with LogMiner and taking a page from Tom Kyte's book.
> First, I try Tom's procedure to add the latest archive log to
> Logminer:
>
> SQL> declare
> 2 l_name v$archived_log.name%type;
> 3 begin
> 4 select name into l_name
> 5 from v$archived_log
> 6 where completion_time = ( select max(completion_time)
> 7 from v$archived_log);
> 8 sys.dbms_logmnr.add_logfile(l_name, sys.dbms_logmnr.NEW);
> 9 end;
> 10 /
> declare
> *
> ERROR at line 1:
> ORA-01284: file F:\ORAARCH\EDST\ARCH_1691.ARC cannot be opened
> ORA-00308: cannot open archived log 'F:\ORAARCH\EDST\ARCH_1691.ARCsql'
> ORA-27041: unable to open file
> OSD-04002: unable to open file
> O/S-Error: (OS 2) The system cannot find the file specified.
>
> Notice on the ORA-00308 line, the 'sql' that was appended to the end
> of the file name.
>
> So I try it manually:
>
> SQL> begin
> 2 sys.dbms_logmnr.add_logfile('F:\ORAARCH\EDST\ARCH_1691.ARC',
> sys.dbms_logmnr.NEW);
> 3 end;
> 4 /
>
> PL/SQL procedure successfully completed.
>
>
> So, a pair of sharp eyes is needed to see what I'm missing in the
> prodedure. Anyone?

Looks OK. Put a debug line, dbms_output.put_line(l_name), before and after select into and check the value of l_name.

Regards
/Rauf Sarwar

--
Posted via http://dbforums.com