SP2-0310: unable to open file [message #435358] |
Tue, 15 December 2009 14:43 |
californiagirl
Messages: 79 Registered: May 2007
|
Member |
|
|
I keep getting the sp2-0310 error message when running my shell script, which is calling a .sql file. Not sure what is going on I checked to make sure the directory was right and permissions. See shell script below:
#
EXT=rp_`date +%d%m%y` # extension used for timestamping of files
OS_user=`whoami` # os username; used in directory references
LOG=/home/silitst/LIST/Logs
# Create the log file
LOG_FILE=$LOG/edi_`date +%m%d%y`.log; export LOG_FILE
#
#!/bin/sh
# must pass id passwd db
# set var for date
# Test for correct number of args
echo "checking args" >> $LOG_FILE
if test $# -ne 1
then # verify user has entered correct
echo "wrong number of args" # number of parameters
exit #
fi #
#
#
#ID=$1 # oracle user to run processes
#PASS=$2 # password
#DB=$3
T_CODE=$1 # application term code parameter
#
# run sql script
sqlplus siscvz@list/ban550chg @/home/silitst/LIST/testfile.sql $T_CODE
Error message:
SP2-0310: unable to open file "/home/silitst/LIST/testfile.sql"
new: showmode BOTH
14:15:51 SQL> prompt end of LOGIN.SQL
end of LOGIN.SQL
Permissions are set properly chmod 755
/home/silitst/LIST, [linv]>pwd
/home/silitst/LIST
-rwxr-xr-x 1 silitst ludevelopers 6265 Dec 15 13:17 testfile.sql
-rwxr-xr-x 1 silitst ludevelopers 1239 Dec 15 13:10 testfile_script.shl
Also the log file was created in the logs directory, so it's not clear as to why I am getting that error message???
Any advice? of something I am not looking at.
|
|
|
|
|
|
|
|
|