Invalid entry created by 'store set' due to linefeed?

Oracle8i Enterprise Edition Release 8.1.7.2.0 - Production on SunOS UNIX, sqlplus 8.1.7 on nt 4.0

USING THE FOLLOWING LOGIN.SQL ON NT 4.0:

	select '('
	|| 'SID='
	|| session_location.sid
	|| ')-'
	|| session_location.username
	|| '/'
	|| d.name
	|| '@'
	|| i.host_name
	as cmd_line_prompt1


	, session_location.sid      as sid_nbr

	, session_location.serial#  as serial_nbr

	from v$database  d


	, v$instance  i

	, v$session   session_location

	WHERE session_location.SID = (SELECT DISTINCT SID FROM SYS.V_$MYSTAT)
	;

	set termout off
	column  cmd_line_prompt2  new_value  cmd_line_prompt2
	select chr(10)					--linefeed character
	|| 'SQL->'  as cmd_line_prompt2
	from global_name
	;
	set termout on

	set sqlprompt '&&cmd_line_prompt1&&cmd_line_prompt2'

SETS MY SQL PROMPT TO:

	15:22:15 (SID=12)-userid/databasename_at_connect_string
	SQL->

When I execute 'store set sqlplus_session_variables.sql replace' it stores the following invalid entry (due to the linefeed character?):

	set sqlprompt "(SID=12)-userid/databasename_at_connect_string >
	SQL->"

SQL->@sqlplus_session_variables.sql generates the following errors:

	string beginning ""(SID=12)-..." missing terminating quote (").
	SP2-0042: unknown command "SQL->"" - rest of line ignored.

Can anyone recommend a way to resolve this problem?

TIA Received on Mon Mar 10 2003 - 18:41:10 CST