Compilation unit analysis terminated?

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Willy

    Compilation unit analysis terminated?

    Hi guys,

    I am new to Oracle, and i have some strange problems here:

    CREATE OR REPLACE PACKAGE trends_data AS
    PROCEDURE dsp_remove_pric e(i_account in integer);
    END trends_data;
    /
    Package created.

    CREATE OR REPLACE PACKAGE BODY trends_data AS

    PROCEDURE dsp_remove_pric e(i_account in integer) IS
    CURSOR radacct_cur IS
    select radacctid,price ,rate,rateno,ac count from radacct
    where account=i_accou nt and TO_CHAR(acctsto ptime,'MM/DD/YYYY')
    >'05/01/2003'
    FOR update of price,rate,rate no;
    l_radacctid radacct.radacct id%TYPE;
    l_price radacct.price%T YPE;
    l_rate radacct.rate%TY PE;
    l_rateno radacct.rateno% TYPE;
    l_account radacct.account %TYPE;
    BEGIN
    OPEN radacct_cur;
    LOOP
    FETCH radacct_cur INTO l_radacctid, l_price, l_rate, l_rateno,
    l_account;
    EXIT WHEN radacct_cur%NOT FOUND;
    update radacct set price=null ,rate=null,rate no=0 where current of
    radacct_cur;
    END LOOP;
    CLOSE radacct_cur;
    update s_trends set price=0 where account=i_accou nt;
    COMMIT;
    END;

    END trends_data;
    /
    I get these messages:

    PROCEDURE dsp_remove_pric e(i_account in integer) IS
    *
    ERROR at line 3:
    ORA-06552: PL/SQL: Compilation unit analysis terminated
    ORA-06553: PLS-320: the declaration of the type of this expression is
    incomplete or malformed

    Can someone help me with this.

    Radovan


Working...