Asynchronous Stored Procedure Calls

Is it possible to call a stored prodcedure from another stored procedure asynchronously?

Edit: Specifically I'm working with a DB2 database.

Answers


Executive summary: Yes, if your database has a message queue service.

You can push a message onto a queue and the queue processor will consume it asynchronously.

  • Oracle: queues
  • Sql Server: service broker
  • DB2: event broker

For "pure" stored procedure languages (PL/Sql or T-Sql) the answer is no, since it works against the fundamental transaction model most databases have.

However, if your database has a queuing mechanism, you can use that to get the same result.


Need Your Help

Why is openvpn responding with “could not read Auth username from stdin?”

vpn openvpn gentoo

Just did an update on my system and for some reason I can no longer log into my VPN service. I'm running gentoo.

How can I use my custom types (C++) in an objective-c project with xcode?

c++ objective-c xcode linker objective-c++

I have a few classes I wrote to deal with numbers having units transparently as if they were just ints or floats. In a nutshell: