Re: Flashback query error
- From: Robyn <robyn.sands@xxxxxxxxx>
- To: "Alberto Dell'Era" <alberto.dellera@xxxxxxxxx>
- Date: Thu, 12 Apr 2007 14:18:41 -0400
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@xxxxxxxxx> wrote:
You forgot to post the error code ... is it perhaps ORA-1466 ?
Alberto Dell'Era
"dulce bellum inexpertis"
--
//www.freelists.org/webpage/oracle-l
Other related posts:
