create or replace procedure testproc IS cnav_lockId number; BEGIN delete from rodmess; commit; cnav_lockId :=28; cnav_unlock_table(cnav_lockId); insert into rodmess values (to_char(cnav_lockId)); commit; END; / show errors;