Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

Pause between execution line

user-94vwtSep 27 2023

How do I pause between one line and another in PL/SQL?

BEGIN 
admtt.pck_processamento.setOrgao('262910'); 
admtt.pck_processamento.setTipo('T'); 

sp_incluir_processamento_job('262910', 'T', 1251, 43, 'DSVMLT629120171220.TXT'); -- 4611 
DBMS_LOCK.SLEEP(15); 

sp_incluir_processamento_job('262910', 'T', 1251, 43, 'DSVMLT629120180919.TXT'); -- 1 
DBMS_LOCK.SLEEP(15); 

END;

I did this, but these weren't the commands I wanted, is there another way?

Comments
Post Details
Added on Sep 27 2023
3 comments
102 views