Re: Why SQL*Plus stops for some users at the end of first command file?

Hi

In my experience ---  

placing an exit statement in those sub-scripts would take you out of the SQL*Plus session right after that script is run.

For example, if you put it in b_sql.sql, then

a_sql and b_sql will run and SQL*plus session will be exited before running c_sql.sql

I have not tried @@ but that is what I have found out with using @ to run several script in SQL*Plus long time ago.

Regards !!!

Oracleguru
www.oracleguru.net
oracleguru_at_mailcity.com

Terry Dykstra [TeamPS] <no_spam_tdykstra_at_cfol.ab.ca> wrote in article <36011d91.0_at_news.cadvision.com>...
> Place an EXIT statement in your scripts (a_sql, b_sqll, c_sql). I had a
> similar situation where the script would 'never end'.
>
> --
> Terry Dykstra [TeamPS]
> Canadian Forest Oil Ltd.
>
> Adam Tadjkarimi wrote in message <6tpe8e$ekr$1_at_newsin-1.starnet.net>...
> >I've a command file, "sql_runner.sql", which executes a group of other
SQL
> >command files, it looks like something like this:
> >C:> TYPE sql_runner.sql
> >@@a_sql.sql;
> >@@b_sql.sql;
> >@@c_sql.sql;
> >...
> >....
> >For some users the "sql_runner" executes all the files successfully and
> >exits but for certain users
> >it stops at the end of "a_sql" file prints a PL/SQL line number. The
user
> >has to CTRL^C to get
> >out and that exits him from "sql_runner" back to the SQL> prompts.
> >
> >I've compared all the envirnment variables for the users and they all
> >identical. Any idea why this is
> >happening? We are on NT4.0 and Oracle8.04 and the problem occures for
both
> >SQL*Plus 8 and
> >SQL*Plus 3.3.
> >
> >Tanx in ad!
> >Adam Tadj
> >adamt_at_hsltd.com
> >
> >Opinions expressed or questions asked are mine not of my employer.
> >
> >
> >
>
>
>
Received on Fri Sep 18 1998 - 10:13:58 CDT