SQL> show user
USER is "IHELP"
SQL> select banner from v$version
  2  /

BANNER
----------------------------------------------------------------
Oracle8 Enterprise Edition Release 8.0.5.0.0 - Production
PL/SQL Release 8.0.5.0.0 - Production
CORE Version 4.0.5.0.0 - Production
TNS for 32-bit Windows: Version 8.0.5.0.0 - Production
NLSRTL Version 3.3.2.0.0 - Production

SQL> desc tbl_category_detail
 Name                            Null?    Type
 ------------------------------- -------- ----
 DONATION_CODE                            NUMBER(5)
 CATEGORY_CODE                            NUMBER(5)
 CATEGORY_AMOUNT                          NUMBER(12,2)

SQL> desc tbl_donation
 Name                            Null?    Type
 ------------------------------- -------- ----
 DONATION_CODE                   NOT NULL NUMBER(8)
 DONATION_DATE                            DATE
 DONATION_RECEIPT_NO                      NUMBER(6)
 CONTACT_CODE                             NUMBER(5)
 PURPOSE_CODE                             NUMBER(5)
 COUNTRY_CODE                             NUMBER(5)
 DONATION_AMOUNT                          NUMBER(10,2)
 CATEGORY_CODE                            NUMBER(5)
 DONATION_PAYMENT_MODE                    CHAR(2)
 APPEAL_CODE                              NUMBER(5)
 DONATION_SR_NO                           NUMBER(5)
 QURBANI_TYPE                             CHAR(1)
 CURRENCY_CODE                            NUMBER(5)
 CARD_NO                                  VARCHAR2(25)
 ISSUE_DATE                               DATE
 EXPIRY_DATE                              DATE
 ISSUE_NO                                 NUMBER(2)
 CARD_TYPE                                CHAR(2)
 DONATION_BOOK_NO                         NUMBER(3)
 DONATION_MACHINE_NO                      NUMBER(3)
 DONATION_TYPE                            CHAR(2)
 DONATION_DESCRIPTION                     VARCHAR2(200)
 DONATION_CLAIM                           CHAR(1)
 CAMPAIGN_CODE                            NUMBER(5)
 CREATION_DATE                            DATE
 PROGRAM_CODE                             NUMBER(5)
 CANVASSER_NAME                           VARCHAR2(45)
 STUDENT_CODE                             NUMBER(5)
 LAST_UPDATE_DATE                         DATE
 UPDATED_FOR                              VARCHAR2(50)
 LAST_UPDATED_BY                          VARCHAR2(45)
 PLEDGE_CODE                              NUMBER(3)
 GA_CLAIM_BATCH                           VARCHAR2(20)
 CANVASSER_CODE                           NUMBER(5)
 INCOME_SOURCE                            CHAR(2)

DECLARE 
    CURSOR c1 IS 
      SELECT donation_code, 
             SUM(category_amount) 
      FROM   tbl_category_detail 
      GROUP  BY donation_code; 
BEGIN 
    FOR rec IN c1 LOOP 
        UPDATE tbl_donation 
        SET    donation_amount = rec.category_amount 
        WHERE  donation_code = rec.donation_code; 
    END LOOP; 
EXCEPTION 
    WHEN OTHERS THEN 
      dbms_output.Put_line(SQLCODE 
                           ||' ' 
                           ||SQLERRM); 
END; 

 DECLARE
*
ERROR at line 1:
ORA-06550: line 12, column 28:
PLS-00302: component 'CATEGORY_AMOUNT' must be declared
ORA-06550: line 11, column 2:
PL/SQL: SQL Statement ignored

DECLARE 
    CURSOR c1 IS 
      SELECT donation_code, 
             SUM(category_amount) category_amount 
      FROM   tbl_category_detail 
      GROUP  BY donation_code; 
BEGIN 
    FOR rec IN c1 LOOP 
        UPDATE tbl_donation 
        SET    donation_amount = rec.category_amount 
        WHERE  donation_code = rec.donation_code; 

        COMMIT; 
    END LOOP; 

    dbms_output.Put_line('Rows Updated ' 
                         || SQL%rowcount); 
/* 
EXCEPTION 
WHEN OTHERS THEN 
DBMS_OUTPUT.PUT_LINE(SQLCODE||' ' ||SQLERRM); 
*/ 
END; 

UPDATE tbl_donation TD 
SET    TD.donation_amount = (SELECT SUM(category_amount) 
                             FROM   tbl_category_detail TCD 
                             WHERE  TD.donation_code = TCD.donation_code);