O'Reilly logo

Managing Multimedia and Unstructured Data in the Oracle Database by Marcelle Kratochvil

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Challenges when shelling out

Shelling out and running an operating script can be harder than it looks. There are numerous considerations that have to be made, and there can be issues with security, the environment, and monitoring the job. In most cases, the shelling out process is one of just submitting blindly, and hoping it works.

Synchronous or asynchronous?

The first decision is to determine whether the script should:

  • Run, and the database should wait for it to finish (synchronous)
  • Submit it, immediately return, and then forget about it (asynchronous)
  • Submit it, monitor its progress, and if need be, terminate the process

Synchronous is the default behavior. A script might be run to convert an audio WAV file into an MP3 file. This might take 5 minutes ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required