UNIX for Dummies Questions & Answers

Relatively new poster but long time reader. I tried searching all threads for similar situations with mine but I've had no luck with some of the solutions.

I have a script (script.ksh) that is getting information from an Oracle DB and spooling it into a text file (log.txt). I would then like to assign the information from log.txt to variables in the script.ksh

Example...

script.ksh

Code:

#!/bin/ksh

#
#  CONNECTING TO ORACLE DATABASE
#*************************************

sqlplus -s user/pass@somedatabase << eof
set pagesize 0;
set heading off;

spool somepath/log.txt;

select WORKFLOW, FOLDER, SERVER, USER_NAME, PASS from JOB_TABLE where JOB_NAME = 'test';

spool off;

EXIT
eof

This is creating log.txt - which contains the following...

Code:

test_name
test_folder
test_server
test_user
test_password

Now this is where I'm getting lost. When I want to save the info from log.txt to variables in script.ksh - I'm getting empty fields

This is how I'm doing it in script.ksh...

Code:

WF_NAME= `tail -1 /somepath/log.txt| awk '{print $1}'`
FDR_NAME= `tail -1 /somepath/log.txt| awk '{print $2}'`
SRV_NAME= `tail -1 /somepath/log.txt| awk '{print $3}'`
USR_NAME= `tail -1 /somepath/log.txt| awk '{print $4}'`
PASS= `tail -1 /somepath/log.txt| awk '{print $5}'`

When I echo out each variable - I get blanks. Any Ideas? I'm assuming I'm doing something wrong with the "tail" - I don't think I even need it... just the way someone suggested for me to do it but I believe it isn't the correct method.

The goal is to get WF_NAME = test_name, FDR_NAME = test_folder, etc. so I can pass these as parameters to a different script.

Probably something dumb but I can't seem to figure it out. Thanks in advance for the help.

Quick Update:

I think I narrowed down the error. I didn't realize that the tail flag was actually the number 1 .... "tail -1" - doh!

The actual content of the log.txt contains 2 empty lines at the end.

So each variable was getting filled with blank info, due to the "-1" part. I need to either:

1 - put everything in one line in log.txt
2 - fix the tail commands to read the correct lines

Any recommendations as to which would be more efficient ?