I have oracle stored procedure which in turns calls 3 procedures. After the end of the third procedure, I want to kick start a shell script to be invoked. How do I do that?
At present in the third procedure i am planning to wirte a file a in a particular unix location. The shell script will keep looking for this file in that location. IF the file is found, it executes.
I am not satisfied with the way this is being done. Kindly suggest me a better way to handle this.