create or replace procedure delete_citytime (c_ctcode in number ) as begin delete from citytime where ct_code = c_ctcode ; if sql%notfound then raise_application_error(-20101,'Record does not exist'); null; else commit; end if; end; /