I need help writing a UNIX shell script to execute an PL/SQL procedure in Oracle. This shell script needs to capture any exception error messages coming from the Oracle procedure and e-mail it to me.
Thanks Chenn, I'll check it out. If you have one available that I can use as a template so I don't have to write from scratch, I would appreciate you passing it along to me.
not easily ... pl/sql (oracle version at least) doesn't exit with an error status of any note, that i've found ... so you'd have to parse the output from the oracle yourself ... if there is a package to do it, then use that
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.