Hi,
While executing below pl/sql block getting below error..
Please advice me where i am doing mistake
DECLARE
v_date date := sysdate -813;
v_last_closing_book_bal_amt NUMBER(19, 4) := NULL;
v_txn_amt NUMBER(19, 4) := NULL;
v_max NUMBER(5) := 100;
v_count NUMBER(5):=1;
BEGIN
FOR I IN 1..30
LOOP
WHILE (v_count <= v_max )
LOOP
Insert into AI_ODS_TXN (BANK_BRANCH_ID,ACCT_NO,ISO_CCY_CD,CR_DR_IND,BOOK_DT,VALUE_DT,TXN_KEY,TXN_TYP_DE,TXN_CAT_DE,TXN_CD,TXN_AMT,FUNDS_TYP_CD,RPT_REF_TXT,INSERTED_TS,UPDATED_TS,BANK_ABA_NO,BENE_PARTY_BANK_ID,BENE_PARTY_BANK_NM,BENE_PARTY_BANK_ADDR_LINE1_TXT,BENE_PARTY_BANK_ADDR_LINE2_TXT,BENE_PARTY_BANK_ADDR_LINE3_TXT,BENE_BANK_ID,BENE_BANK_NM,BENE_BANK_ADDR_LINE1_TXT,BENE_BANK_ADDR_LINE2_TXT,BENE_BANK_ADDR_LINE3_TXT,DETAIL_LINE1_TXT,DETAIL_LINE2_TXT,DETAIL_LINE3_TXT,DETAIL_LINE4_TXT,DETAIL_LINE5_TXT,FED_CLEAR_TS_TXT,CR_DR_PARTY_NM,CR_DR_PARTY_ADDR_LINE1_TXT,CONTROL_NO,INTERMED_BANK_ID,INTERMED_BANK_NM,INTERMED_BANK_ADDR_LINE1_TXT,INTERMED_BANK_ADDR_LINE2_TXT,INTERMED_BANK_ADDR_LINE3_TXT,ORG_BANK_NM,ORG_BANK_ADDR_LINE1_TXT,ORG_BANK_ADDR_LINE2_TXT,ORG_BANK_ADDR_LINE3_TXT,OGB_BANK_NM,OGB_BANK_ADDR_LINE1_TXT,OGB_BANK_ADDR_LINE2_TXT,OGB_BANK_ADDR_LINE3_TXT,INSTRUCT_BANK_NM,INSTRUCT_BANK_ADDR_LINE1_TXT,UNCLEAR_DT,UNCLEAR_ITEM_IND,INSTRUCT_AMT,INSTRUCT_CCY_CD,SENDER_CHARGE_LINE1_TXT,SENDER_CHARGE_LINE2_TXT,SENDER_CHARGE_LINE3_TXT,SENDER_CHARGE_LINE4_TXT,REGULATORY_TXT,BANK_REF_TXT,EXT_REF_TXT,YOUR_REF_TXT,FED_DR_ACCT_NO,SWIFT_STMT_NO,NDC_CD,BAI_CD,SWIFT_CD,CNS_SEQ_NO,LOAD_NO,UPDATED_WORKFLOW_NM,EXCHANGE_RT,ORG_BANK_ID,OGB_BANK_ID,INSTRUCT_BANK_ID,SRC_MSG_TYP,CLEAR_DT,JOURNAL_NO,SERIAL_NO,SWIFT_STMT_DT,CR_DR_TXT,SUPP_DETAIL_TXT,GVC_CD,BOOKING_TXT,ITEM_TYP_DE,ORG_BANK_ACCT_NO,RETURNED_DDT_TXT,DETAIL_LINE6_TXT,DETAIL_LINE7_TXT,DETAIL_LINE8_TXT,DETAIL_LINE9_TXT,DETAIL_LINE10_TXT,DETAIL_LINE11_TXT,DETAIL_LINE12_TXT,DETAIL_LINE13_TXT,DETAIL_LINE14_TXT,EXTRA_BCS_DETAIL_IND,OGB_BANK_ACCT_NO,INTERMED_BANK_ACCT_NO,CR_FLOOR_LIMIT_AMT,DR_FLOOR_LIMIT_AMT,MT942_TOTAL_CR_AMT,MT942_TOTAL_CR_NO,MT942_TOTAL_DR_AMT,MT942_TOTAL_DR_NO,INTERIM_FINAL_TXN_IND) values ('DBBRUSSELS','825-0004665-47','EUR','C',to_timestamp(v_date,'DD-MON-RR HH.MI.SSXFF AM'),to_timestamp(v_date,'DD-MON-RR HH.MI.SSXFF AM'),'2009102201521911232172'+v_count,'TRANSFER','FUNDS TRANSFER','SWF',100,'VT','I000424906808216',to_timestamp(v_date,'DD-MON-RR HH.MI.SSXFF AM'),to_timestamp(v_date,'DD-MON-RR HH.MI.SSXFF AM'),null,null,'AAAAA35AAHNLEITEN GMBH',null,null,null,null,null,null,null,null,'IHR KT 0000002056/200000044','4 NR.5100000835 /09.03.09/N','ETTOBTR. 6.627,01 NR.510000','0872 /10.03.09/NETTOBTR. 4.','559,21 NR.5100000891 /11.03',null,null,null,null,null,null,null,null,null,'DUROPACK AG 1235 WIEN','XXN33XXXXROHNLEITEN GMBH',null,null,null,null,null,null,null,null,null,'N',null,null,null,null,null,null,null,'PET326000108PAGE AND','I000424906808216','I000424906808216',null,'102/1',null,195,'TRF',null,0,'w_MT940_PROC - Type:First STMT',0,'15150',null,null,'940',null,null,null,to_timestamp(v_date,'DD-MON-RR HH.MI.SSXFF AM'),'C',null,'051','GUTSCHRIFT ELEKTRON.','76VB','501057590','QQQ34DQQQROHNLEITEN GMBH','.09/NETTOBTR. 5.093,33 NR.5','100000899 /12.03.09/NETTOBT','R. 2.302,58 NR.5100000917 /','13.03.09/NETTOBTR. 831,37 N','R.5100001006 /2',null,null,null,null,'N',null,null,null,null,null,null,null,null,'F');
COMMIT;
v_count := v_count +1;
END LOOP;
select nvl(last_closing_book_bal_amt,0) into v_last_closing_book_bal_amt from ai_ods_acct_tbl
WHERE ACCT_NO ='825-0004665-47' AND BANK_BRANCH_ID ='DBBRUSSELS' AND ISO_CCY_CD ='EUR' ;
select nvl(sum(txn_amt),0) into v_txn_amt from ai_ods_txn
WHERE ACCT_NO ='825-0004665-47' AND BANK_BRANCH_ID ='DBBRUSSELS' AND ISO_CCY_CD ='EUR' and book_dt= to_timestamp(v_date,'DD-MON-RR HH.MI.SSXFF AM');
Insert into ai_ods_BOOK_dt_agg (BANK_BRANCH_ID,ACCT_NO,ISO_CCY_CD,BOOK_DT,TOTAL_DR_ITEM_NO,TOTAL_DR_AMT,TOTAL_CR_ITEM_NO,TOTAL_CR_AMT,INSERTED_TS,UPDATED_TS) values ('DBBRUSSELS','825-0004665-47','EUR',to_timestamp(v_date,'DD-MON-RR HH.MI.SSXFF AM'),0,0,4,v_txn_amt,to_timestamp(v_date,'DD-MON-RR HH.MI.SSXFF AM'),to_timestamp(v_date,'DD-MON-RR HH.MI.SSXFF AM'));
Insert into ai_ods_value_dt_agg (BANK_BRANCH_ID,ACCT_NO,ISO_CCY_CD,VALUE_DT,TOTAL_DR_ITEM_NO,TOTAL_DR_AMT,TOTAL_CR_ITEM_NO,TOTAL_CR_AMT,INSERTED_TS,UPDATED_TS) values ('DBBRUSSELS','825-0004665-47','EUR',to_timestamp(v_date,'DD-MON-RR HH.MI.SSXFF AM'),0,0,4,v_txn_amt,to_timestamp(v_date,'DD-MON-RR HH.MI.SSXFF AM'),to_timestamp(v_date,'DD-MON-RR HH.MI.SSXFF AM'));
Insert into ai_ods_CATEGORY_agg (TXN_CAT_DE,BANK_BRANCH_ID,ACCT_NO,ISO_CCY_CD,BOOK_DT,TOTAL_DR_ITEM_NO,TOTAL_DR_AMT,TOTAL_CR_ITEM_NO,TOTAL_CR_AMT,INSERTED_TS,UPDATED_TS) values ('FUNDS TRANSFER','DBBRUSSELS','825-0004665-47','EUR',to_timestamp(v_date,'DD-MON-RR HH.MI.SSXFF AM'),0,0,4,v_txn_amt,to_timestamp(v_date,'DD-MON-RR HH.MI.SSXFF AM'),to_timestamp(v_date,'DD-MON-RR HH.MI.SSXFF AM'));
Insert into ai_ods_acct_bal (BANK_BRANCH_ID,ACCT_NO,ISO_CCY_CD,BOOK_DT,INTERIM_FINAL_BAL_IND,LOAD_NO,BOOK_BAL_AMT,VALUE_BAL_AMT,COLLECTED_BAL_AMT,TOTAL_DR_AMT,TOTAL_CR_AMT,TOTAL_CHECK_CR_AMT,TOTAL_LBX_AMT,TOTAL_IMPREST_DR_AMT,TOTAL_IMPREST_CR_AMT,ONE_DAY_FLOAT_AMT,TWO_DAY_FLOAT_AMT,THREE_DAY_FLOAT_AMT,FOUR_DAY_FLOAT_AMT,MTD_AVG_COLLECTED_BAL_AMT,YTD_AVG_COLLECTED_BAL_AMT,INSERTED_TS,UPDATED_TS,UPDATED_WORKFLOW_NM,OPEN_BOOK_BAL_AMT,SWIFT_STMT_DT,SWIFT_STMT_NO,MISSING_STMT_IND,SRC_MSG_TYP,TAG_60F_DT,TAG_60F_AMT,STMT_TYPE_IND) values ('DBBRUSSELS','825-0004665-47','EUR',to_timestamp(v_date,'DD-MON-RR HH.MI.SSXFF AM'),'F',0,v_last_closing_book_bal_amt + v_txn_amt ,
v_last_closing_book_bal_amt + v_txn_amt,0,0,v_txn_amt,0,0,0,0,0,0,0,0,0,0,to_timestamp(v_date,'DD-MON-RR HH.MI.SSXFF AM'),to_timestamp(v_date,'DD-MON-RR HH.MI.SSXFF AM'),'w_MT940_PROC - Type:First STMT',v_last_closing_book_bal_amt,to_timestamp(v_date,'DD-MON-RR HH.MI.SSXFF AM'),'102/1','N','940',to_timestamp('17-APR-09','DD-MON-RR HH.MI.SSXFF AM'),v_last_closing_book_bal_amt,'=');
COMMIT;
v_date := sysdate -809;
v_date := v_date + I;
v_count := 1;
END LOOP;
END;
/
ERROR
*=====*
v_date date := sysdate -813;
***
ERROR at line 2:
ORA-06550: line 2, column 7:
PLS-00103: Encountered the symbol "" when expecting one of the following:
constant exception <an identifier>
*<a double-quoted delimited-identifier> table LONG_ double ref*
char time timestamp interval date binary national character
nchar