Skip to Main Content

Breadcrumb

Question and Answer

Tom Kyte

Thanks for the question, Justin.

Asked: December 09, 2014 - 7:19 pm UTC

Last updated: December 10, 2014 - 11:18 am UTC

Version: 11.2.0.3

Viewed 1000+ times

You Asked

Is it possible to force a procedure to execute against a particular service so that any time that procedure executes, it executes on the nodes the service is running on?

and Tom said...

No, a connection to the database specifies the service - once you are connected, the service is a forgone conclusion. You have to be connected to execute a product - so therefore... The service is already selected.

However, that said, if you use dbms_job/scheduler to run the procedure in the background, you may choose the instance you want it to run on. dbms_job.submit can use the instance parameter and in dbms_scheduler you can set the instance_id on the job.

Otherwise, your application must connect to the database via the desired service and then run the procedure.

Rating

  (1 rating)

Is this answer out of date? If it is, please let us know via a Comment

Comments

Thanks!

Justin, December 10, 2014 - 1:59 pm UTC

I was thinking that was the answer, but i was hoping there was some other way of doing it (other than the job scheduler). It looks like there's work to do..

Thanks again!
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's latest video and Chris's latest video from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.

More to Explore

PL/SQL demos

Check out more PL/SQL tutorials on our LiveSQL tool.

PL/SQL docs

PL/SQL reference manual from the Oracle documentation library