Shell Programming and Scripting

Hi,

Below is my script:

#!/bin/sh

sqlplus uname/pwd@instance <<EOF

set wrap off
set feedback off
set pagesize 0
set verify off
set trimspool on
set linesize 5000

spool /arboru02/FX/scripts/customer_profile_def.txt

select gpv.profile_id||'|'||c.account_no||'|'||c.hierarchy_id||'|'||c.parent_id||'|'||s.subscr_no||'|'||s.s ubscr_no_resets||'|'||p.element_id||'|'||c.bill_period||'|'||c.billing_frequency||'|'||c.currency_co de
from cmf c, general_profile_values gpv, service s, product p
where c.account_no=s.parent_account_no
and c.account_no=p.parent_account_no
and c.account_no=s.PARENT_ACCOUNT_NO
and p.parent_subscr_no=s.SUBSCR_NO
and c.BILL_PERIOD='G08'
and gpv.profile_id=200;

spool off;
quit
EOF

And when i am executing it getting sqlplus: not found.

Plz tell me what is wrong in the script?

Thanks

sqlplus is not in your PATH, add it to your PATH or specify its location in the script.