Re: Flashback query error

From: Robyn <robyn.sands_at_gmail.com>
Date: Thu, 12 Apr 2007 14:18:41 -0400
Message-ID: <ece8554c0704121118t2ede949ficfb414f79b6aef50@mail.gmail.com>

Thanks Alberto but the problem has been solved. The error was:

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

And the statement should have been:

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_rec.ACCT_DOC_FYP,
  matl_doc_month_rec.MATL_NUM,
  matl_doc_month_rec.PLANT,
  matl_doc_month_rec.MOVMNT_TYPE,
  matl_doc_month_rec.STOR_LOC,
  matl_doc_month_rec.RCVING_STOR_LOC,
  matl_doc_month_rec.DEBIT_CREDIT_IND,
  matl_doc_month_rec.PROFIT_CTR,
  matl_doc_month_rec.GL_ACCT_NUM,
  matl_doc_month_rec.BASE_UOM,
  matl_doc_month_rec.BASE_QTY,
  matl_doc_month_rec.TRANS_CNT,
  matl_doc_month_rec.ACCT_DOC_FY,
  matl_doc_month_rec.ACCT_DOC_FQ,
  matl_doc_month_rec.ACCT_DOC_FP,
  matl_doc_month_rec.ACCT_DOC_CY,
  matl_doc_month_rec.ACCT_DOC_CQ,
  matl_doc_month_rec.ACCT_DOC_CP,
  matl_doc_month_rec.ACCT_DOC_CYP,
  matl_doc_month_rec.SL_INV_GRP,
  matl_doc_month_rec.COST_CTR,
  matl_doc_month_rec.LOCAL_CURRENCY_AMT,
  matl_doc_month_rec.REASON_FOR_MOVMNT_IND,
  matl_doc_month_rec.LOAD_DATE);

end loop;
  close flash_recover;
  commit;
  end;
/

On 4/12/07, Alberto Dell'Era <alberto.dellera_at_gmail.com> wrote:
> You forgot to post the error code ... is it perhaps ORA-1466 ?
>
> Alberto Dell'Era
> "dulce bellum inexpertis"
>

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

Received on Thu Apr 12 2007 - 13:18:41 CDT