RE: Flashback query error

You are fetching into mal_doc_month_rec, but using matl_doc_month.

--
Ron Reidy
Lead DBA
Array BioPharma, Inc. 

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Robyn
Sent: Thursday, April 12, 2007 11:07 AM
To: oracle-l
Subject: Re: Flashback query error

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



This electronic message transmission is a PRIVATE communication which contains
information which may be confidential or privileged. The information is intended 
to be for the use of the individual or entity named above. If you are not the 
intended recipient, please be aware that any disclosure, copying, distribution 
or use of the contents of this information is prohibited. Please notify the
sender  of the delivery error by replying to this message, or notify us by
telephone (877-633-2436, ext. 0), and then delete it from your system.

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