Re: exit in sql script

"Sunil" <sunil_franklin_at_hotmail.com> wrote in message news:<Wc3qa.26$B95.383_at_news.oracle.com>...
> Gurus,
> I have a sqlscript without an exit at the end which I call from a csh
> file. I expect the csh script to hang because of the missing exit, but this
> behaviour is erratic. i.e. sometimes it hangs while sometimes it goes
> through fine.
> Any ideas why I may be seeing this behaviour.

Probably because it is a csh script. Oracle is a bit, um, "different" when it comes to standard out vs. standard error behavior, and csh is a bit strange itself. For consistency, use Bourne or a derivative.

http://www.ooblick.com/text/CshProgrammingConsideredHarmful.html

jg

--
@home.com is bogus.
http://www.signonsandiego.com/news/uniontrib/fri/business/news_1b25verizon.html