create or replace procedure SP_H02_09 is v_som number default 0; v_aantal pls_integer default 0; v_procent number default 0; v_bedrag number default 0; BEGIN select count(*) into v_aantal from user_tables WHERE table_name = 'LOG_TABLE'; if v_aantal = 0 then execute immediate 'create table LOG_TABLE(' || ' getal number' || ', tekst varchar2(200)' || ', datum date)'; end if; END;