I am trying to run a report using SQL Developer. Everything from the Select down to Group By works but the when trying to set up headers and column names to do. Below script is what I am having an issue with.
SET ECHO OFF
Set TERMOUT OFF
break on report
SET LINESIZE 120
set PAGESIZE 60
set feedback off
--set trimspool on
column Source format a15 Heading 'Source'
column Images format 999,999 Heading 'Image Count'
column Into_Interface format a10 Heading 'Into Interface'
column To_CM format a8 Heading 'To CM'
column Verfied_CM format a8 Heading 'Verfied'
column Deleted format a8 Heading 'Deleted'
column Insert_Date format a12 Heading 'Insert Date'
column To_CM_Date format a12 Heading 'To CM Date'
column Verify_CM_Date format a12 Heading 'Verfied Date'
column Deleted_Date format a12 Heading 'Deleted Date'
TTITLE skip 1 LEFT 'Activity for Images from APAS and iExpense to Content Manager' RIGHT 'Page:' FORMAT 99 SQL.PNO -
skip LEFT 'Summary' -
skip LEFT '04-26-2015 Thru 05-29-2015' -
skip 1
--
set echo off
set feedback off
spool c:\CM_Activity.txt
After I run my script, the error I get is this. Is there a setting I need to update? What is causing this. My co-worker can run this same script in SQL Developer without any issues. It's just me. Thanks
line 4: SQLPLUS Command Skipped: set LINESIZE 120
line 5: SQLPLUS Command Skipped: set PAGESIZE 60
line 9: SQLPLUS Command Skipped: column Source format a15 Heading 'Source': only "column .. new_value .." supported
line 10: SQLPLUS Command Skipped: column Images format 999,999 Heading 'Image Count': only "column .. new_value .." supported
line 11: SQLPLUS Command Skipped: column Into_Interface format a10 Heading 'Into Interface': only "column .. new_value .." supported
line 12: SQLPLUS Command Skipped: column To_CM format a8 Heading 'To CM': only "column .. new_value .." supported
line 13: SQLPLUS Command Skipped: column Verfied_CM format a8 Heading 'Verfied': only "column .. new_value .." supported
line 14: SQLPLUS Command Skipped: column Deleted format a8 Heading 'Deleted': only "column .. new_value .." supported
line 15: SQLPLUS Command Skipped: column Insert_Date format a12 Heading 'Insert Date': only "column .. new_value .." supported
line 16: SQLPLUS Command Skipped: column To_CM_Date format a12 Heading 'To CM Date': only "column .. new_value .." supported
line 17: SQLPLUS Command Skipped: column Verify_CM_Date format a12 Heading 'Verfied Date': only "column .. new_value .." supported
line 18: SQLPLUS Command Skipped: column Deleted_Date format a12 Heading 'Deleted Date': only "column .. new_value .." supported
>>Query Run In:Query Result