Can someone direct me to some good resources that have examples of integrating sqlplus execution inside a Korn Shell script.
I need to:
- Pass sqlplus success/fail status back to the ksh.
- Trap sql errors in my ksh application and perform "ksh" conditional logic on these errors.
- Toggle back and forth between ksh execution and sqlplus.
- Run and capture stored procedure results (hopefully same as std SQL query).
I'm a Windows programmer by trade so much of this is "Greek" to me.
Operating system is (I believe...)HP-UX V.5.1 1885 alpha
DB is Oracle 8i
Thanks for your help.