Problems with LogMiner's DBMS_LOGMNR.MINE_VALUE function

From: Derek Reiger <dreiger_at_sybase.com>
Date: Fri, 15 Mar 2002 10:22:58 -0700
Message-ID: <3C922DF2.FA555527_at_sybase.com>

I'm trying to use the MINE_VALUE function, which is a part of the LogMiner package, but I'm running into problems and can't find an example anywhere. The documentation states the following:

http://download-west.oracle.com/otndoc/oracle9i/901_doc/appdev.901/a89852/dbms_l5b.htm#76816

MINE_VALUE syntax:
dbms_logmnr.mine_value(

     sql_redo_undo        IN  RAW,
     column_name        IN  VARCHAR2 default '') RETURN VARCHAR2;

The MINE_VALUE function returns the value contained in the first parameter corresponding to the column name indicated in the second parameter.

The doc also includes the following usage note: The MINE_VALUE function must be invoked in the context of a select operation from the V$LOGMNR_CONTENTS view:

I have successfully started a LogMiner session and can see the results in the V$LOGMNR_CONTENTS view, but I haven't been able to get this function (or the COLUMN_PRESENT function) to work.

The sql that I execute generates an error:

SQL> select scn, seg_name, SYS.DBMS_LOGMNR.MINE_VALUE(redo_value,'COL1') redo_value from v$logmnr_contents WHERE seg_name ='DGR_TEST';

select scn, seg_name, SYS.DBMS_LOGMNR.MINE_VALUE(redo_value,'COL1') redo_value from v$logmnr_contents WHERE seg_name ='DGR_TEST'

                                 *

ERROR at line 1:
ORA-00904: invalid column name

Is there some other way to execute this function in the context of a select statement?

Thanks in advance,
Derek Received on Fri Mar 15 2002 - 18:22:58 CET