Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Newbie UNIX shell script question

Status
Not open for further replies.

moepower

Programmer
Oct 5, 2000
93
US
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.

Any suggestions will be greatly appreciated.
 
Read about the Perl DBI and its functions. What ypou need is implemented in that API!
Use your search engine for a tutorial about DBI-programming!

hope it'll help you! regards
chenn
 
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.

 
Could I use straight forward Korn Shell to do the script without using Perl or Perl DBI?
 
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 :)
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top