Compilation unit analysis terminated?

From: Willy <willy_at_mail.sc.eu>
Date: Tue, 19 Aug 2003 10:12:28 +0200
Message-ID: <bhsmfq$ufh$1_at_neptun.beotel.net>

Hi guys,

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

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

CREATE OR REPLACE PACKAGE BODY trends_data AS

PROCEDURE dsp_remove_price(i_account in integer) IS   CURSOR radacct_cur IS
    select radacctid,price,rate,rateno,account from radacct     where account=i_account and TO_CHAR(acctstoptime,'MM/DD/YYYY')
>'05/01/2003'

     FOR update of price,rate,rateno;

  l_radacctid radacct.radacctid%TYPE;
  l_price radacct.price%TYPE;
  l_rate radacct.rate%TYPE;
  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%NOTFOUND;
    update radacct set price=null ,rate=null,rateno=0 where current of radacct_cur;
  END LOOP;
  CLOSE radacct_cur;
  update s_trends set price=0 where account=i_account;   COMMIT;
END; END trends_data;
/
I get these messages:

PROCEDURE dsp_remove_price(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 Received on Tue Aug 19 2003 - 10:12:28 CEST