Results 1 to 2 of 2

Thread: pls-00103 error

  1. #1
    Join Date
    Oct 2009
    Posts
    4

    Unanswered: pls-00103 error

    hi why is this giving me an error, please help


    DECLARE
    lv_total_num NUMBER(6,2);
    lv_rating_txt VARCHAR2(4);
    lv_eg_txt VARCHAR2(10) ;

    BEGIN
    SELECT SUM(total)
    INTO lv_total_num
    FROM bb_basket
    WHERE idShopper = :g_shopper
    AND orderplaced = 1
    GROUP BY idshopper;
    Case lv_total_num
    WHEN lv_total_num > 200 THEN lv_eg_txt := 'HIGH';
    WHEN lv_total_num > 100 THEN lv_eg_txt := 'MID';
    WHEN lv_total_num < 100 THEN lv_eg_txt := 'LOW';
    ELSE
    END CASE;
    DBMS_OUTPUT.PUT_LINE( 'Shopper '||:g_shopper||' is rated '||lv_rating_txt);
    END;
    /
    Last edited by amitabh1987; 10-03-09 at 19:20.

  2. #2
    Join Date
    Nov 2003
    Posts
    2,935
    Provided Answers: 12
    That is obviously an Oracle stored procedure, so why do you post in the MySQL forum?

Posting Permissions

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