Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Error starting AT line : 1 IN command -
- CURSOR c1 IS SELECT * FROM ca_account_t
- Error report -
- Unknown Command
- Error starting AT line : 2 IN command -
- exist NUMBER
- Error report -
- Unknown Command
- Error starting AT line : 3 IN command -
- BEGIN
- FOR irec IN c1 LOOP
- exist := 0;
- SELECT COUNT(*) INTO exist FROM CA_ACCT_GDLNPRPS_T b
- WHERE irec.fin_coa_cd = b.fin_coa_cd
- AND irec.account_nbr = b.account_nbr;
- IF exist = 0 THEN
- INSERT INTO CA_ACCT_GDLNPRPS_T (FIN_COA_CD,ACCOUNT_NBR,OBJ_ID,VER_NBR,ACCT_EXP_GDLN_TXT,ACCT_INC_GDLN_TXT,ACCT_PURPOSE_TXT)
- VALUES (irec.fin_coa_cd , irec.account_nbr,SYS_GUID(),1,'MIGRATED FROM ORACLE','MIGRATED FROM ORACLE','MIGRATED FROM ORACLE');
- END IF;
- END LOOP;
- END;
- Error report -
- ORA-06550: line 3, column 13:
- PLS-00201: identifier 'C1' must be declared
- ORA-06550: line 3, column 1:
- PL/SQL: Statement ignored
- 06550. 00000 - "line %s, column %s:\n%s"
- *Cause: Usually a PL/SQL compilation error.
- *Action:
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement