Skip to Main Content
  • Questions

  • Call shell script using stored procedure /function.

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, GIRISH.

Asked: May 09, 2024 - 5:04 am UTC

Last updated: May 13, 2024 - 1:42 am UTC

Version: 19C

Viewed 1000+ times

You Asked

Hi,

I want to create a stored procedure / function which will call shell script and shell script will have command to copy the file from particular location of DB server to another location of DB server.

I tried using the scheduler job same is working fine but i don't want to use scheduler job.

I want to use procedure/function to call shell script.

Request your help in how to call shell script in stored procedure/function.


Regards
GirishR

and Connor said...

An easy way to do this with an external table


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