Oracle Database Discussions

Hi all,

I need to pause a stored procedure half way through for 30 seconds.

I tried using dbms_lock.sleep but get error PLS-00201: identifier 'dbms_lock.sleep' must be declared.
What am i doing wrong or is there another method?

Thanks
James


create procedure pause_testing

is
begin

-- some statments here

dbms_lock.sleep(30);

-- some other statments here

-- exception statments

end;