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.subscr_no_resets||'|'||p.element_id||'|'||c.bill_period||'|'||c.billing_frequency||'|'||c.currency_code
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