Advertisement
mugs

Unknown Command

Oct 16th, 2015
181
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PL/SQL 0.96 KB | None | 0 0
  1. Error starting AT line : 1 IN command -
  2. CURSOR c1  IS SELECT * FROM ca_account_t
  3. Error report -
  4. Unknown Command
  5.  
  6. Error starting AT line : 2 IN command -
  7. exist NUMBER
  8. Error report -
  9. Unknown Command
  10.  
  11. Error starting AT line : 3 IN command -
  12. BEGIN
  13.  
  14. FOR irec IN c1 LOOP
  15. exist := 0;
  16. SELECT COUNT(*) INTO exist FROM CA_ACCT_GDLNPRPS_T b
  17. WHERE irec.fin_coa_cd = b.fin_coa_cd
  18. AND  irec.account_nbr = b.account_nbr;
  19.  
  20. IF exist = 0 THEN
  21.  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)
  22.  VALUES (irec.fin_coa_cd , irec.account_nbr,SYS_GUID(),1,'MIGRATED FROM ORACLE','MIGRATED FROM ORACLE','MIGRATED FROM ORACLE');
  23. END IF;
  24.  
  25. END LOOP;
  26.  
  27.  
  28. END;
  29. Error report -
  30. ORA-06550: line 3, column 13:
  31. PLS-00201: identifier 'C1' must be declared
  32. ORA-06550: line 3, column 1:
  33. PL/SQL: Statement ignored
  34. 06550. 00000 -  "line %s, column %s:\n%s"
  35. *Cause:    Usually a PL/SQL compilation error.
  36. *Action:
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement