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')
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
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'
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