Re: Flashback query error

From: Robyn <robyn.sands_at_gmail.com>
Date: Thu, 12 Apr 2007 13:06:30 -0400
Message-ID: <ece8554c0704121006p18f52342k49c1cd0e42512da8@mail.gmail.com>

Crisis averted ... got the data back from our replication site which just happened to be up for BCP testing ... the fates are smiling on us today :)

However ... I'd still like to figure out what happened with the flashback procedure. I've used this successfully in the past so I'm puzzled. The error is:

   matl_doc_month.LOAD_DATE);

                  *

ERROR at line 62:
ORA-06550: line 62, column 19:
PL/SQL: ORA-00984: column not allowed here ORA-06550: line 37, column 1:
PL/SQL: SQL Statement ignored

Sorry for the incomplete post earlier ... I was watching the clock run down on my retention window and stressing :)

Robyn

On 4/12/07, Robyn <robyn.sands_at_gmail.com> wrote:
> 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 - 12:06:30 CDT