Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2002
    Posts
    227

    Unanswered: PLS-00103 error in stored procedure!!

    Hi,
    I created this procedure

    CREATE OR REPLACE procedure upd_coeff as
    BEGIN
    UPDATE BL
    SET COEFF=(case when area_oc=0 or area_gr=0
    then 0
    else (area_gr/area_oc)
    end);
    commit;
    END;

    but when I compile I get error PLS-00103 on CASE clause.
    my oracle version is 8.1.7.0

    Thanks!!

  2. #2
    Join Date
    Jan 2004
    Posts
    492
    Oracle OCPI (Certified Practicing Idiot)

Posting Permissions

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