Results 1 to 3 of 3

Thread: Help!!!

  1. #1
    Join Date
    Sep 2003
    Posts
    5

    Unanswered: Help!!!

    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 great

  2. #2
    Join Date
    Jul 2001
    Location
    Germany
    Posts
    189

    Error

    Hello,

    pls, post the error.

    Best regards
    Manfred Peter
    Alligator Company Software GmbH
    http://www.alligatorsql.com

  3. #3
    Join Date
    Sep 2003
    Posts
    5

    Re: Help!!!

    the error is simple that it doesnt compile- when i say show err it says the where statement does belong...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •