SQLPLUS error

Shell Programming and Scripting
1

I am running a script that invokes SQLPLUS. During the execution I get the following:

SQL*Plus: Release 9.2.0.8.0 - Production on Mon Jun 11 16:12:50 2007

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.


Connected to:
Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.8.0 - Production

SQL>   2    3    4    5    6    7    8

Does anyone know where the 2..8 is coming from?

if [ $retcode -eq "0" ]; then
	print
	print "*******************************************************" 
  print "2) Updating records in SKU table"
  print "*******************************************************" 
	sqlplus $db_usr_stsc<<EOF
UPDATE stsc.sku s
SET (s.p_abc, s.p_manualparameters, s.p_commenttext, s.p_workinglistname) =
(SELECT x.p_abc, x.p_manualparameters, x.p_commenttext, x.p_workinglistname
      	       FROM pac.SKUUPDATE x
        	    WHERE s.loc = x.loc AND s.item = x.item)
 	WHERE EXISTS (SELECT 1
  	              FROM pac.SKUUPDATE x
    	           WHERE s.loc = x.loc AND s.item = x.item);
COMMIT;
exit
EOF
echo "Update Complete"
fi
2

From the various end of lines in your update statement.

In SQLPLUS the prompt is "SQL>" then when you don't finish the statement with a ";" it assumes this is a continuation of the previous line and prompts with a number.

3

sqlplus -s

4

Hi , try with '/' at the end of script.