OraFAQ Forum: Client Tools » SP2-0158: unknown SET option "up"

Home » Other » Client Tools » SP2-0158: unknown SET option "up"

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

SP2-0158: unknown SET option "up" [message #317968]

Mon, 05 May 2008 02:39

sdhanuka
Messages: 173
Registered: March 2008

Senior Member

Hi Everybody,

My sql*plus script works fine. At the end of the spooled output page i get the following error :

SP2-0158: unknown SET option "up"

This does not affect my output.

How to resolve this issue??

Thanks and Regards.

Report message to a moderator

Re: SP2-0158: unknown SET option "up" [message #317970 is a reply to message #317968]

Mon, 05 May 2008 02:46

Frank
Messages: 7901
Registered: March 2000

Senior Member

How can we help you if you don't show us your script?

Report message to a moderator

Re: SP2-0158: unknown SET option "up" [message #317978 is a reply to message #317970]

Mon, 05 May 2008 03:19

sdhanuka
Messages: 173
Registered: March 2008

Senior Member

Oh, sorry.

set arraysize 1 
set heading on
set feedback off 
set verify off
set linesize 150
set pages 9999
set term off
set echo off 
spool c:\scripts\final1.html
set markup html on spool on entmap off preformat off 
prompt <HTML>
prompt <HEAD>
prompt <TITLE>Test HTML Output </TITLE>
prompt <script type="text/javascript" src="calendar.js"></script>
prompt <script type="text/javascript" src="calendar-en.js"/></script>
prompt <script type="text/javascript" src="calendar-setup.js"/></script>
prompt <link rel="stylesheet" type="text/css" media="all" href="calendar-blue.css" />
prompt </HEAD>
prompt <BODY>
prompt <table cellspacing="0" cellpadding="0" border="0" id="myform">
	prompt <tbody>
		prompt <tr>
			prompt <td>From Date:</td>
			prompt <td><input type="text" id="fromDate" /></td>
		prompt </tr>
		prompt <tr>
			prompt <td>To Date:</td>
			prompt <td><input type="text" id="toDate" /></td>
		prompt </tr>
		prompt <tr>
		prompt <td></td>
		prompt <td><input type="submit" value="submit" onclick="shikhs()"></td>
		prompt </tr>
		
	prompt </tbody>
prompt </table>

select to_char(sysdate,'DD-MM-YYY HH24:MI:SS') "Connect Time" from dual;
select * from emp;
prompt <script type="text/javascript" src="foo.js"/></script>
prompt </BODY>
prompt </HTML>
set mark up html off
spool off;

Report message to a moderator