This is how I executed multiple sql files in a folder that had 100 sql files in it:
for filename in *.sql
do
echo "Executing file $filename..."
sqlplus -s ods/passwd@dODS <<EOF
@$filename;
quit;
EOF
done

enjoy