Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Why SQL*Plus stops for some users at the end of first command file?
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 Thu Sep 17 1998 - 09:35:05 CDT