Shell Programming and Scripting

#!/bin/ksh
echo "------------------------------"
echo "Scripting ls command..."
echo "------------------------------"
 
SQLPLUS_CMD=$ORACLE_HOME/bin/sqlplus
login="userid/pwd@dev"
 
in_loc=`$SQLPLUS_CMD -s $login <<EOF 
set pagesize 0 feedback off verify off heading off echo off
select file_location from ps_is_ftp_rc where prcsname = 'HR1062' and seqnum = 1;
exit;
EOF`
 
filepath="cd "$in_loc
 
echo "filepath = $filepath"
echo "in_loc value: $in_loc"
 
cd $in_loc
 
echo `pwd`
 
my_file="testfile"
 
fname=`ls -t $my_file | head -1`
 
echo " "
echo "last edited filename: $fname"

+ echo ------------------------------
------------------------------
+ echo 'Scripting ls command...'
Scripting ls command...
+ echo ------------------------------
------------------------------
+ SQLPLUS_CMD=<oracle_home>/bin/sqlplus
+ login=<userid>/<pwd>@<db>
++ <oracle_home>/bin/sqlplus -s <userid>/<pwd>@db
+ in_loc='$PS_HOME/int/VSP'
+ filepath='cd $PS_HOME/int/VSP'
+ echo 'filepath = cd $PS_HOME/int/VSP'
filepath = cd $PS_HOME/int/VSP
+ echo 'in_loc value: $PS_HOME/int/VSP'
in_loc value: $PS_HOME/int/VSP
+ cd '$PS_HOME/int/VSP'
getfile.sh: line 25: cd: $PS_HOME/int/VSP: No such file or directory
++ pwd
+ echo <pwd> 
++ cd '$PS_HOME/int/VSP'
getfile.sh: line 29: cd: $PS_HOME/int/VSP: No such file or directory
+ echo
++ pwd
+ echo <pwd>

+ my_file=testfile
++ ls -t testfile
++ head -1
testfile: No such file or directory
+ fname=
+ echo ' '
+ echo 'last edited filename: '
last edited filename:
+ echo ' '
+ echo 'Found string at position:  '
Found string at position:

actual_dir=$( eval echo $in_loc )
cd $actual_dir