SQL & PL/SQL

Hello,

I am facing problem while running the report from SQL Plus:

set lines 32767

set feedback off

set emb on pages 0 newp 0

set trimspool on

set tab off

set trimout on

set echo off

set underline off

set verify off

set show off

set head off

set colsep |

PROMPT  PARTY_NAME|PARTY_SITE_NAME|PARTY_SITE_UPDATED_BY|PARTY_SITE_UPT_DATE|ADDRESS1|ADDRESS2|ADDRESS3|ADDRESS4|CITY|STATE|POSTAL_CODE|COUNTRY|ADDRESS_UPDATED_BY|ADDRESS_UPDATE_DATE|SDF_STATUS|FG_STATUS|A_NUM|SELLER_NUM|SHIP_ACCOUNT_NUM|A_IDENTIFIER|TO_SD|AS_DATE|SDN|CLIENT_NAME|CLIENT_TYPE|EXCLDUDE_SALES|CUSTOMER_SITE_UPDATED_BY|CUSTOMER_SITE_UPDT_DT

Then the SQL Part is there below:

When I executed there is error:

PARTY_NAME|PARTY_SITE_NAME|PARTY_SITE_UPDATED_BY|PARTY_SITE_UPT_DATE|ADDRESS1|ADDRESS2|ADDRESS3|ADDRESS4|CITY|STATE|POSTAL_CODE|COUNTRY|ADDRESS_UPDATED_BY|ADDRESS_UPDATE_DATE|SDF_STATUS|FG_STATUS|A_NUM|SELLER_NUM|SHIP_ACCOUNT_NUM|A_IDENTIFIER|TO_SD|AS_DATE|SDN|CLIENT_NAME|CLIENT_TYPE|EXCLDUDE_SALES|CUSTOMER_SITE_UPDATED_BY|

SP2-0734: unknown command beginning "CUSTOMER_S..." - rest of line ignored.