iterating through file and calling oracle package in Unix

Question

0.00/5 (No votes)

See more:

I have a file ABC.txt which has some records like:
hello
ram
mohan

i have a xyz.ksh script which executes oracle packages. I want to call oracle package oracle_pkg('<lines from="" abc.txt="" file="">')using this script.

Now i want to read ABC.txt and iterate through the line calling xyz.ksh on every line and passing that name as parameter to package.
to make it more understandable i am writing it is pseudo English.

read ABC.txt
Loop through the content line by line
variable line which will have every line content
call xyz.ksh passing it oracle_pkg(line)
if EOF
end loop

While answering please bee little descriptive as i have very limited knowledge of UNix/Linux.

thanks in advance.
cheers

Posted 18-Jul-14 9:52am

Sky8807

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Vedat Ozan Oner · Accepted Answer · 2014-07-18T10:42:00

Solution 1

quite easy:

$ cat ABC.txt | while read a
do
 xyz.ksh $a # assuming it expects as parameter
 # or
 echo $a | xyz.ksh # reads from its standard input
done

there are good examples here: http://www.well.ox.ac.uk/~johnb/comp/unix/ksh.html[^]

Posted 18-Jul-14 10:42am

Vedat Ozan Oner

Updated 18-Jul-14 10:44am

v2

Comments

Sky8807 18-Jul-14 16:57pm

Thanks for the help.. but my problem is when i am calling xyz.ksh i will have to pass oracle package and parameter as well something like thing (adding your answer as well)
<pre>
$ cat ABC.txt |
do
xyz.ksh $a # i have to give package name as well something like xyz.ksh oracle_pkg($a)
done
</pre>

Now program is getting issue saying '(' is not accepted.

Vedat Ozan Oner 18-Jul-14 17:06pm

it depends on your xyz.ksh script implementation. send it here by using 'improve question' and let's see what happens in it.