Re: exit in sql script

From: Jaap W. van Dijk <j.w.vandijk.removethis_at_hetnet.nl>
Date: Fri, 25 Apr 2003 21:10:32 +0200
Message-ID: <8h1javkn39epoem0naa0kin2ji8sa9jn4u@4ax.com>

On Fri, 25 Apr 2003 10:21:42 +0530, "Sunil" <sunil_franklin_at_hotmail.com> wrote:

>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,
>

I've seen the same erratic behaviour. But I don't like exit statements in sql-scripts (if you are modifying and testing the scripts manually, SQL*Plus annoyingly keep exiting on you), so I - never put an exit statement in a script - always start the script in a HERE-document with an exit statement put in after the execution of the script.

If a script slips by that has an exit at the end, that's no problem, apparently the statements in the HERE-document after execution of the scripts are flushed in that case.

Jaap. Received on Fri Apr 25 2003 - 14:10:32 CDT