Column Headings using sqlplus script not working

From: Roger <>
Date: Wed, 11 Jan 2012 08:59:43 -0800 (PST)
Message-ID: <>

Stupid question here. I'm having brain freeze. I have a real simple script that I run in sqlplus

set colsep ','
set pagesize 0
set trimspool on
set linesize 1000
set feedback off
spool paymastr3.csv
select * from paymastr
  where check_date='30-Dec-11';
spool off

I can execute the sql script and the csv file is created, but NO column headings are appearing. I have tried everything, but still no headings. I've tried set HEADINGS ON but that doesn't work

This is Oracle 9i

Any ideas?

-R Received on Wed Jan 11 2012 - 10:59:43 CST

Original text of this message