1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

i have got a warning : procedure created with compilation errors . may i knw what is

Discussion in 'SQL PL/SQL' started by sushmitha, Jul 20, 2014.

  1. sushmitha

    sushmitha Active Member

    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    55
    create or replace procedure items (orders varchar) is
    qtyhand number;
    releve1 number;
    max1eve1 number;
    begin
    select qty_lev, re_lev, max_lev into qtyhand, relevel,
    maxlevel from itemfile where itemcode = orders;
    if qtyhand < relevel then
    update itemfile set qty_lev = relevel + qtyhand where
    itemcode = orders;
    else
    dbms_output.put_line (‘itemlevel ok’);
    End if;
    end;
     
  2. rajenb

    rajenb Forum Expert

    Messages:
    361
    Likes Received:
    114
    Trophy Points:
    655
    Location:
    Mauritius
    Re: i have got a warning : procedure created with compilation errors . may i knw what

    Duplicate post ... see reply in other post.