Flashback query error

From: Robyn <robyn.sands_at_gmail.com>
Date: Thu, 12 Apr 2007 12:12:17 -0400
Message-ID: <ece8554c0704120912n2d94cb75yebdb2999d85fd000@mail.gmail.com>

Hello everyone,

I'm trying to use flashback query to recover some data, and the procedure I've used in the past is failing. Does anyone else see the error in this code? The column match the table and I've used this in the past.

declare cursor flash_recover is
select * from matl_doc_month;
  matl_doc_month_rec matl_doc_month%rowtype; begin
 dbms_flashback.enable_at_time(sysdate - 60/1440);   open flash_recover;
 dbms_flashback.disable;
 loop
 fetch flash_recover into matl_doc_month_rec;   exit when flash_recover%notfound;
insert into matl_doc_month values

  (matl_doc_month.ACCT_DOC_FYP,
   matl_doc_month.MATL_NUM,
   matl_doc_month.PLANT,
   matl_doc_month.MOVMNT_TYPE,
   matl_doc_month.STOR_LOC,
   matl_doc_month.RCVING_STOR_LOC,
   matl_doc_month.DEBIT_CREDIT_IND,
   matl_doc_month.PROFIT_CTR,
   matl_doc_month.GL_ACCT_NUM,
   matl_doc_month.BASE_UOM,
   matl_doc_month.BASE_QTY,
   matl_doc_month.TRANS_CNT,
   matl_doc_month.ACCT_DOC_FY,
   matl_doc_month.ACCT_DOC_FQ,
   matl_doc_month.ACCT_DOC_FP,
   matl_doc_month.ACCT_DOC_CY,
   matl_doc_month.ACCT_DOC_CQ,
   matl_doc_month.ACCT_DOC_CP ,
   matl_doc_month.ACCT_DOC_CYP,
   matl_doc_month.SL_INV_GRP,
   matl_doc_month.COST_CTR,
   matl_doc_month.LOCAL_CURRENCY_AMT,
   matl_doc_month.REASON_FOR_MOVMNT_IND,
   matl_doc_month.LOAD_DATE);

end loop;

   close flash_recover;
   commit;
   end;
/

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Apr 12 2007 - 11:12:17 CDT