471,083 Members | 1,017 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,083 software developers and data experts.

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_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
Jul 19 '05 #1
0 4715

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

11 posts views Thread by Steven T. Hatton | last post: by
11 posts views Thread by Michael Gaab | last post: by
reply views Thread by fabrice | last post: by
176 posts views Thread by nw | last post: by
reply views Thread by Willy | last post: by
2 posts views Thread by =?Utf-8?B?c2lwcHl1Y29ubg==?= | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.