Hello,
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.
Azii
0
Newbie Poster
Recommended Answers
Jump to PostI'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:
All 3 Replies
rubberman
1,355
Nearly a Posting Virtuoso
Featured Poster
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: http://stackoverflow.com/questions/4068816/how-to-call-a-shell-script-from-plsql-program
Azii
0
Newbie Poster
Thank you for quick reply. I will checkout the given solution.
Azii
0
Newbie Poster
Hi,
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 developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.