Skip to Main Content
  • Questions
  • Call shell script using stored procedure /function.


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


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.


and Connor said...

An easy way to do this with an external table

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