How To Add Error Handling from Shell Script call for Concurrent Process
We are using Oracle EBS 12.1.3 and we use a shell script call to move files to the server to then upload into the interface tables. So the shell script calls a .sql script that drives the rest of the processing. How can we include error handling so that based on a condition the concurrent process returns an yellow warning or not? I've tried the SQLERRM function and I've tried the RetCode as well without any change. I'm either doing it wrong or there is a different method. Any suggestions?