Instalace programových jednotek Vzorová ustanovení

Instalace programových jednotek standard library - get property create or replace function spget( ) p_id xx.xx%type return sp.vs%type is begin select vs into vs from sp where id=p_id; return vs; vs sp.vs%type; exception when no_data_found then return null; end; -- standard library - set property create or replace procedure spset( , p_id xx.xx%type ) p_vs sp.vs%type Begin is update sp set vs=p_vs where id=p_id; if sql%rowcount=0 then insert into sp values (p_id, p_vs); end if; end; -- standard library - logger create or replace procedure slwr(