I have a procedure and i dont know why it doesnt work:
SET SERVEROUTPUT ON
CREATE OR REPLACE
PROCEDURE update_price(p_cutoff IN CHAR) AS
change CONSTANT Real := 0.9;
CURSOR c_upgrade_p IS
SELECT price FROM items
WHERE start_date = DATE(p_cutoff)
FOR UPDATE OF price;
BEGIN
FOR c_upgrade_rec IN c_upgrade_p LOOP
UPDATE items
SET price = price * 0.9;
WHERE CURRENT OF c_upgrade_p;
END LOOP;
COMMIT;
END;
/
any help wouldbe greatHello,
pls, post the error.
Best regards
Manfred Peter
Alligator Company Software GmbH
http://www.alligatorsql.com|||the error is simple that it doesnt compile- when i say show err it says the where statement does belong...
Monday, February 27, 2012
Help!
Labels:
char,
database,
microsoft,
mysql,
oncreate,
oracle,
p_cutoff,
procedure,
replaceprocedure,
server,
serveroutput,
sql,
update_price,
workset
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment