Toad World® Forums

Bug-SQL script do not execute glogin.sql

Toad last prod version in this moment.


set echo on;

select 1 from dual;

Time Start: 23.11.2017 10:16:08
Session altered.
Elapsed: 00:00:00.07

LOGIN_TIME USER INSTANCE SID SERIAL# HOST


23.11.2017 10:16:08 MOBAPPC PMOBCST1 1 3693 36611 AUSTRIA\ATCMW736649
Elapsed: 00:00:00.02
_USER’@’_CONNECT_IDENTIFIER> select 1 from dual

     1

     1

Elapsed: 00:00:00.02
Time End: 23.11.2017 10:16:08
Elapsed Time for Script Execution: 658 msecs

With no echo on, same command:


Time Start: 23.11.2017 10:16:33
Session altered.
Elapsed: 00:00:00.07

LOGIN_TIME USER INSTANCE SID SERIAL# HOST


23.11.2017 10:16:33 MOBAPPC PMOBCST1 1 3693 36611 AUSTRIA\ATCMW736649
Elapsed: 00:00:00.02

     1

     1

Elapsed: 00:00:00.01
Time End: 23.11.2017 10:16:33
Elapsed Time for Script Execution: 661 msecs

Mine glogin.sql looks like:
set termout off pause off arraysize 1
SET pagesize 2000
SET LONG 10000
SET linesize 180
COLUMN last_name format a20
COLUMN value for a20
SET feedback ON
rem
rem Store username
rem
col user_id new_value user_id
col user_name new_value user_name
col adate new_value adate
select user_id, lower(username) user_name from user_users where username = user;
rem
rem Store database name
rem
rem set sqlprompt “_USER’@’_CONNECT_IDENTIFIER _PRIVILEGE>”
set sqlprompt “_USER’@’_CONNECT_IDENTIFIER>”
rem
@sqlplus_default;
rem
set time on
set timi on
rem
col a_user for a20
col a_db for a20
col a_instance for a20
alter session set nls_numeric_characters=’,.’;
@my_sid;

So glogin.sql seems not be execute in sql script (F5)
Brg
Damir