Run a oracle query asynchronously
DIVIJan 21 2013 — edited Jan 22 2013in my stored procedure code is like
execute immediate 'update table_1 set col1='some new value'';
execute immediate 'update table_2 set col1='some new value'';
execute immediate 'update table_3 set col1='some new value'';
.
.
.
now these tables are very huge in size, and i don't want to wait until those queries are completed, i want to move to the next steps in procedure.
is there any simple way to do this rather creating a job and scheduling it and dropping ? ?