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...
Showing posts with label workset. Show all posts
Showing posts with label workset. Show all posts
Monday, February 27, 2012
Help!
Labels:
char,
database,
microsoft,
mysql,
oncreate,
oracle,
p_cutoff,
procedure,
replaceprocedure,
server,
serveroutput,
sql,
update_price,
workset
Subscribe to:
Posts (Atom)