Re: SQLPLUS - Unwanted Pause

jstrange_at_imtn.dsccc.com (John Strange) wrote:

>Remove the set pause off
> set pause on
>code
>
>
>Ron Strouss (rstrouss_at_ix.netcom.com) wrote:
>: Malakhov Nikolay <mal_at_kpbank.ru> wrote:
 

>: >Ron Strouss wrote:
>: >>
>: >> We have a select statement on the v$database table to get the
>: >> database name which will be used as part of the user's SQLPLUS Prompt.
>: >
>: >Hi! may be this will help - part of my login.sql:
>: >col sqlprompt new_value ppp noprint
>: >set pause off
>: >set termout off
>: >select global_name||'>_' sqlprompt from global_name;
>: >set sqlp &ppp
>: >set pause on
>: >set term on
>
>
>: Malakhov Nikolay
 

>: We can set pause off ... and we can run your version of the glogin
>: script and it still pauses if you do any kind of 'select' statement
>: ... ???
 

>: Ron
>
>
>--
>This posting represents the personal opinions of the author. It is not the
>official opinion or policy of the author's employer. Warranty expired when you
>opened this article and I will not be responsible for its contents or use.

>>

To ALL:

We have 4 databases on the same box ... they all use the same glogin.sql script ... there is no login.sql that runs

We can set 'pause off' and when we login to Database X it pauses after the select statement in glogin.sql

It only happens with one database on this system....

One more hint here ...

If this instance had Oracle Financials we would go thru a series of steps to see that the database was in order and after going thru these steps this pause problem would go away. Since this database does not have Oracle Financials on it I can't run the utility that does cleanup ...

Anyone got any other ideas ... ???

Ron Received on Mon Jun 02 1997 - 00:00:00 CEST