create or replace procedure V8_UPD_INSERTWUSS is 
  wussid number(30,4):=0;  
begin   
  begin 
    select w.wuss_id into wussid from wuss w where w.wuss_name='ThisHotelIsMaster'; 
  exception 
    when no_data_found then null;   
  end; 
   
  if wussid=0 then 
    insert into wuss (wuss_id, wuss_xcms_id, wuss_name, wuss_value) values (seq_wuss.nextval, 0, 'ThisHotelIsMaster', 0); 
  end if; 
end V8_UPD_INSERTWUSS; 
/
