"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.
>
> Thanks,
It should exit in the end. The only case I saw when sqlplus is hanging up is
when you call a non-existing script (or permissions are wrong). It's always
a good idea to check for existence of the script before running sqlplus for
that script. Another trick is to pipe the script into sqlplus, but it's not
always a good idea. For example, you can't run script with parameters this
way.
Received on Fri Apr 25 2003 - 12:44:20 CDT
