I have written the basic shell script "myscript.sh", which prints Hello World.
I want to call this script using PL/SQL.
Please let me know the procedure(steps) for the same.

Thank you.

Recommended Answers

I'm not sure it is possible to call shell scripts from PL/SQL. You can call embedded java code which in turn can call a shell script. I had to do that in the past to solve this problem. Here is a link that may help:

Jump to Post

All 3 Replies

Thank you for quick reply. I will checkout the given solution.

I am trying to create the pl/sql procedure in sql developer, but i am getting this error:
Error(5,5): PLS-00201: identifier 'DBMS_PIPE' must be declared

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.19 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.