Calling Oracle function from script Post: 303004816

Sponsored Content

Top Forums Shell Programming and Scripting Calling Oracle function from script Post 303004816 by bakunin on Monday 9th of October 2017 04:17:11 PM

10-09-2017

Registered User

Bear with me but i don't quite get what you want:

Quote:

Originally Posted by kev94

test.csv

Code:

1,2,3,,5,,,8,9,10
1,2,3,4,5,,,8,9,10
1,2,3,,,,,8,9,10

OK, what do you want to do with this file?

Quote:

Originally Posted by kev94

In the above file I want to replace column 2 with a value extracted from database
like (select student_id from stud_master)

ahem - yes? From a select statement like the above you likely get a list in return, say, this:

Code:

99
100
101
...

What exactly do you want to do to "column two" and what has has this to do with the list the select-statement returned? Could you show an example of the outcome you have in mind?

Quote:

Originally Posted by kev94

Normally I could able to connect to db and and get the value.

Code:

awk 'BEGIN -F, -v OFS=, {print $1,$2,$3}' test.csv

Now I want to know to call a oracle function and replace the output for $2 variable.

Now i am even more confused: if you replace "$2" (the second field) with the output i envisioned above you would get this:

Code:

1,99
100
101
...,3
1,99
100
101
...,3
1,99
100
101
...,3

I suppose this is not what you want, but i can't figure out what it actually is. Please enlighten us.

bakunin

bakunin

View Public Profile for bakunin

Find all posts by bakunin

10 More Discussions You Might Find Interesting

1. Programming

calling c++ function from script

hi, I just started to work on unix, I was wondering if it is possible to call a c++ function from a script. now, i don't mean starting a program, i mean dynamicaly calling a funtion (like working with a dll) thanks

2. Shell Programming and Scripting

$0 scope in function and calling script

Hi folks, I'm just running through an oreilly korn shell book but have witnessed an output difference on my own unix machine and the output provided in the book. Can anyone help? create a script called ascript as follows: function afunc { print in function $0: $1 $2 var1="in...

3. Shell Programming and Scripting

urgent calling function from a script

Hi, Can we define a function say func1 in a script 1.sh and call this function from another script say 2.sh by passing an argument :confused:

4. Shell Programming and Scripting

Help needed in function calling in a script

:confused:Hi , I have a script as shown below: rpttxt() { name="$*" awk '/'"${name}"'/ {print $2 $3"=" $4}' file.txt } xx = rpttxt "COL_HEAD_1" awk 'BEGIN {printf("%36s \n ","'"$xx"'")}' rpttxt() is a function..I want to store the final result of this function in...

5. UNIX for Dummies Questions & Answers

calling one function from another shell script

i have a function defined in one ksh (ksh 1) i want to use that function in another ksh (ksh 2) i am using . $<directoryname>/<ksh name> i am calling the function defined in ksh 1 in ksh 2 i want the returnstatus from the above operation but it is not executing the function what i...

6. Shell Programming and Scripting

Question for calling oracle function from perl

Dear Sir/Madam, I use the following way to call the oracle stored procedure in a perl script, but I do not know how to call a oracle function by the following way ? # ARGV is the oracle stored procedure name with parameters $str = "sqlplus -s <<-eof \n" . "$db_login...

7. Shell Programming and Scripting

c function calling from a pearl script

Hi, Is it possible to call a c function defined in a .c file from a pearl script? How is this possible? Thannks in advance, JS

8. Shell Programming and Scripting

Calling a C-function froma Perl script

Hi All, How can we call a c function from a perl script? Is it the same way as we do for shell script ? Thanks in advance JS

9. Shell Programming and Scripting

SHELL SCRIPT Function Calling Another Function Please Help...

This is my function which is creating three variables based on counter & writing these variable to database by calling another function writeRecord but only one record is getting wrote in DB.... Please advise ASAP...:confused: function InsertFtg { FTGSTR="" echo "Saurabh is GREAT $#" let...

10. Shell Programming and Scripting

Calling function from another bash script

I would like to call functions from another bash script. How can I do it? Some code More code

10 More Discussions You Might Find Interesting

1. Programming

calling c++ function from script

Discussion started by: Lebamb

2. Shell Programming and Scripting

$0 scope in function and calling script

Discussion started by: beckett

3. Shell Programming and Scripting

urgent calling function from a script

Discussion started by: jisha

4. Shell Programming and Scripting

Help needed in function calling in a script

Discussion started by: jisha

5. UNIX for Dummies Questions & Answers

calling one function from another shell script

Discussion started by: trichyselva

6. Shell Programming and Scripting

Question for calling oracle function from perl

Discussion started by: ili

7. Shell Programming and Scripting

c function calling from a pearl script

Discussion started by: jisha

8. Shell Programming and Scripting

Calling a C-function froma Perl script

Discussion started by: jisha

9. Shell Programming and Scripting

SHELL SCRIPT Function Calling Another Function Please Help...

Discussion started by: omkar.sonawane

10. Shell Programming and Scripting

Calling function from another bash script

Discussion started by: kristinu