sql prompt message

[KashifDBA]

Originally posted by ocp2b

set termout off
spool set_prompt.sql
select 'set sqlprompt'||' "' || a.username ||'-'|| b.terminal ||'> "'
from v$session a, v$process b
where a.paddr = b.addr
and a.sid = (select sid from v$session_connect_info);
spool off
start set_prompt.sql
set termout on

I have Just Joined this forum today and find for the GLOGIN.SQL
and find this thread
and when i issue these statments then it gives me error

and a.sid = (select sid from v$session_connect_info)
*
ERROR at line 4:
ORA-01427: single-row subquery returns more than one row


Will be thank full for Helping