Link to home
Start Free TrialLog in
Avatar of YZlat
YZlatFlag for United States of America

asked on

0403-057 Syntax error at line 8 : `<' is not matched.

I am getting this error in my ksh script. I am trying to read the data from a view in the database I specify via command line argument and write the output to a file:

#!/usr/bin/ksh

if [ $# -gt 0 ]
then
	export ORACLE_SID=$1
	ORAENV_ASK=NO
	. oraenv
	sqlplus -s /nolog <<EOF
	connect username/pwd
	set lines 4000
	set trimspool on
	set pages 0

	spool myfile.dat
	SELECT * from customer_view
	spool off
	EOF

fi 

Open in new window


I run my script as:

 ./myscript.ksh DBName
ASKER CERTIFIED SOLUTION
Avatar of flow01
flow01
Flag of Netherlands image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of YZlat

ASKER

Thanks!