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