Home » SQL & PL/SQL » Client Tools » SP2-0158: unknown SET option "up"
SP2-0158: unknown SET option "up" [message #317968] Mon, 05 May 2008 02:39 Go to next message
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.
Re: SP2-0158: unknown SET option "up" [message #317970 is a reply to message #317968] Mon, 05 May 2008 02:46 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
How can we help you if you don't show us your script?
Re: SP2-0158: unknown SET option "up" [message #317978 is a reply to message #317970] Mon, 05 May 2008 03:19 Go to previous messageGo to next message
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;
Re: SP2-0158: unknown SET option "up" [message #317985 is a reply to message #317978] Mon, 05 May 2008 03:55 Go to previous messageGo to next message
ThomasG
Messages: 3189
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
*points at second-last line*
Re: SP2-0158: unknown SET option "up" [message #317987 is a reply to message #317985] Mon, 05 May 2008 04:03 Go to previous message
sdhanuka
Messages: 173
Registered: March 2008
Senior Member
oh..opps...silly mistake
Previous Topic: With clause gives strange error
Next Topic: Same query, same server, different clients and different results
Goto Forum:
  


Current Time: Mon Dec 05 09:16:52 CST 2016

Total time taken to generate the page: 0.07854 seconds