|
|
Sponsored Content
Top Forums
Shell Programming and Scripting
Passing variable from file to Oracle
Post 302926145 by jhonnyrip on Friday 21st of November 2014 12:54:51 PM
11-21-2014
|
|
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
In normal shell scripting, how do you pass the output of a command to a variable, instead of a file and be able to use it later?
The code is:
#!/bin/bash
who | cut -d" " -f1 > onlineusers
Instead of passing the output of the above command to the file called 'onlineusers'... (1 Reply)
Discussion started by: Furqan_79
1 Replies
2. Shell Programming and Scripting
using the script below I want to pass a parameters thorugh my sql
call(@/unixsxxx/xxxx/helpenv.sql emptab ) as input into an oracle procedure xxxx_package.proc1(%1,emptab); . I tried %1 but it does not work. Any suggestions.
#!bin/ksh
set -x
#
export... (0 Replies)
Discussion started by: TimHortons
0 Replies
3. Shell Programming and Scripting
Please help me how to pass some unix vairable to oracle. I have used below , but not displaying passed (inval) value.
calling()
{
sqlplus -s $1/$2@$3 <<EOF
begin
exec call_sql($4);
end;
exit
EOF
}
calling user pwd inst value1... (17 Replies)
Discussion started by: Jairaj
17 Replies
4. Shell Programming and Scripting
Hi all,
I have a script in file1 which gets input from the user say variable "TYPE". This variable is present in the other file2. I want to replace the variable in the file2 with the value given by the user and print the file. How can I achieve this task?
file1
code
echo "Give... (3 Replies)
Discussion started by: Ananthdoss
3 Replies
5. Programming
Hi,
I am trying to get the oracle variables and pass the values in sql placed in procedure.
VARIABLE
vstat='ASDS,FGDS,VCGD,VCXC'
Query :
select distinct dept from College
where section in ('C','D')
AND CODES =''
AND NAMES IN ('RAJ','SAM');
I want CODES values to be taken from vstat... (1 Reply)
Discussion started by: Perlbaby
1 Replies
6. Shell Programming and Scripting
Hi Guys,
i have a file where data is in the below format::
data1 data2
data3 data4
data4 data6
my script written as::
#!/bin/ksh
cd $1
at now <<END
sh $2
END
Here i want to pass the values stored in the above file one by one till the end of line.
Here if i am doing it as:: (2 Replies)
Discussion started by: Atp3530
2 Replies
7. Shell Programming and Scripting
Hi Friend,
I have one file in which some number are mentioned and number of lines are vary every time
And i need to pass that number to my sql command from script.
Suppose i have file acc.txt
45456546456
45464564565
67854353454
67657612132
Number of records are vary every time.... (20 Replies)
Discussion started by: pallvi_mahajan
20 Replies
8. UNIX for Beginners Questions & Answers
Below is the command
mv AP_FLEXCUBE_INTERFACE10.txt FTPYMNTE_`date "+%Y%m%d%H%M%S" | tr '' ''`.TXT
it is changing the file name to a different name according to time stamp dynamically. I want to capture that dynamic file name present in the directory to a variable .
After that i want to... (6 Replies)
Discussion started by: sujit das
6 Replies
9. Shell Programming and Scripting
Apologies if this is the incorrect forum.There is an issue in the function call I am facing while calling the same from a unix shell scripts.
Basically, I want the ref cursor to return values to a variable in sqlpus. The function call is currently saved in a ".txt" file
in a unix location. I want... (7 Replies)
Discussion started by: amvip
7 Replies
10. UNIX for Beginners Questions & Answers
Hello,
I have researched and tried many way to pass OUT parameter to be stored in variable in KSH Script.Still not success, please help.
Here is my Store Procedure.
create procedure testout3(v_in varchar2,v_out OUT integer)
as
begin
v_out := 1;
end;
Here is my testvout.ksh
#!/bin/ksh... (1 Reply)
Discussion started by: palita2601
1 Replies
LEARN ABOUT MOJAVE
syscallbysysc.d
syscallbysysc.d(1m) USER COMMANDS syscallbysysc.d(1m) NAME
syscallbysysc.d - syscalls by syscall. Uses DTrace. SYNOPSIS
syscallbysysc.d DESCRIPTION
syscallbysysc.d is a DTrace OneLiner to a report of the number of each type of system call made. This is useful to identify which system call is the most common. Docs/oneliners.txt and Docs/Examples/oneliners_examples.txt in the DTraceToolkit contain this as a oneliner that can be cut-n-paste to run. Since this uses DTrace, only users with root privileges can run this command. EXAMPLES
This samples until Ctrl-C is hit. # syscallbysysc.d FIELDS
first field This is the system call type. Most have man pages in section 2. second field This is the count, the number of occurrances for this system call. DOCUMENTATION
See the DTraceToolkit for further documentation under the Docs directory. The DTraceToolkit docs may include full worked examples with ver- bose descriptions explaining the output. EXIT
syscallbysysc.d will sample until Ctrl-C is hit. AUTHOR
Brendan Gregg [Sydney, Australia] SEE ALSO
procsystime(1M), dtrace(1M), truss(1) version 1.00 May 15, 2005 syscallbysysc.d(1m)