How to Capture error , if a SQL Procedure fails inside a Unix shell

How to Capture error , if a SQL Procedure fails inside a Unix shell

 

  

Hi All



I have called an SQL Proc inside my shell.Now I want to update a log file in
case the Process fails due to some reason..



Can anyone provide any input on that ??



Thanking in advance.



"Truth is incontrovertible. Panic may resent it; ignorance may deride it;
malice may distort it; but there it is."
-- Winston Churchill

_________________________________

Manish kalra

Systems Executive

KPIT Cummins Infosystems ltd

35&36 , Rajiv Gandhi Infotech park,

Phase -1 , MIDC,

Hinjewadi , Pune - 411057

INDIA

Phone - 020 - 56525000






Oracle LazyDBA home page