Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Run a oracle query asynchronously

DIVIJan 21 2013 — edited Jan 22 2013
in 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 ? ?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 19 2013
Added on Jan 21 2013
12 comments
2,866 views