update oracle table using shell script

[ann124]

Hi,
I would like to know how to update a table in Oracle database, if a command in one shell script either successfully completes or it fails.(like Y if its success or N if its a failure)

While the command is running,I am able to view the log file created in the Unix machine.After the command is exexcuted,it has to update a column in Oracle database . How can I do this?

any ideas or solutions are welcome.

 

[PHV]

Perhaps posting in an oracle forum ?
Or reading the FAQs ?

http://www.tek-tips.com/faqs.cfm?fid=2218

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244