Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / System Packages

 

Submit a job and run

SQL> SQL> set echo on SQL> SQL> create table t ( msg varchar2(20), cnt int ); Table created. SQL> SQL> insert into t select 'from SQL*PLUS', count(*) from session_roles; 1 row created. SQL> SQL> variable n number SQL> SQL> exec dbms_job.submit(:n,'insert into t select ''from job'', count(*) from session_roles;'); PL/SQL procedure successfully completed. SQL> SQL> print n          N ----------        181 SQL> SQL> exec dbms_job.run(:n); PL/SQL procedure successfully completed. SQL> SQL> select * from t; MSG                         CNT -------------------- ---------- from SQL*PLUS                12 from job                      0 SQL> drop table t; Table dropped. SQL>