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