Search Results

Hi karthik,


if i use a function then how to call the function from bash.

the fuction is a parametised.

and how can get return value of the function in bash.

Thanks.

Hi
This is my bash script.i am calling validation.sql and passing a value to it using ${flds[1]}.
i want the cnt variable in plsql script to be passed to unix.



LOADREC=`sqlplus -s...

Hi nila

exec procedure();
is not working.
but i tried call procedure(); it was working.

but my concern is

the stored procedure has a OUT parameter and i want to use the out parameter...

Hi

its differrent from my previous post.

Thanks.

---------- Post updated at 10:44 PM ---------- Previous update was at 09:25 PM ----------

Hi

can provide the script.

thanks.

Hi

i want to call a oracle stored procedure from unix (using bash shell).

consider this is my oracle stored procedure with parameter

create procedure testproc(name IN varchar, age IN...

line='hi#111#are#you'
Tval=`echo ${line} | cut -d "#" -f 2`


if [ $Tval = $counter ] then
echo "No of rows matched with T Value"
else
echo "Not matched"
fi

i cut the field and...

Hi

i read a file row by row and cut into fields.
and store the content of fields to a variable.

when i use the variable in if condition it giving me error.
the error is : integer...

Hi

the error when i execute the script.


: integer expression expected[: 111

thanks.

consider this my stored procedure

create procedure proc(name IN varchar, age IN varchar)
as
var varchar;

begin

select * into var from table where colname='name'

if sqlorwcount =0
...

Hi Nila

in am working in bash shell script.
the cut command is not working.


Tval=`echo ${line} | cut -d "," -f 2`

the csv file we using delimeter # so replaced the delimeter in the...

consider this as a csv file.


H,0002,0002,20100218,17.25,P,barani
D,1,2,3,4,5,6,7,8,9,10,11
D,1,2,3,4,5,6,7,8,9,10,11
D,1,2,3,4,5,6,7,8,9,10,11
D,1,2,3,4,5,6,7,8,9,10,11...

hi its not working.

hi

i am calling a oracle stored procedure(in the database) from unix shell scripting (a.sh).
the called stored procedure returns some values through OUT variables

i want to assign the...

Hi

i am calling a stored procedure from unix shell like this call

test_proc('0002','20100218');

the stored procedure was giving output

like this dbms_output.put_line(' processed...

its oracle database.
yes i want to check the table field contains the cahracter or may be a value.

thanks.

Hi

have an array like this

colarray[0]="a"
colarray[1]="b"
colarray[2]="c"
colarray[3]="d"
colarray[4]="e"
colarray[5]="f"

the arrayvariable is in unix sh file

i want to check...

consider this is a line A#B#C#D#E#F#G#H
note the delimeter is #

i want to cut or spilt in to fields using the delimeter # and to store in an array.
like this

array[0]=A
array[1]=B...

a simple tabel with numbers of columns.
we are going to store the data from the csv file.
there are number of lines in the csv file we have spilt the line using delimeter # in to fields and these...

Hi,

the csv file with the delimeter #.

A#B#C#D#E#F#G#H
1#2#3#4#5#6#7#8
Z#x#c#V
7#2#8#9
N.

I want to read the file line by line and store in rowarray.
then the rowarray content should...

Hi,

the csv file with the delimeter #.

A#B#C#D#E#F#G#H
1#2#3#4#5#6#7#8
Z#x#c#V
7#2#8#9
N.

I want to read the file line by line and store in rowarray.
then the rowarray content should...

this is the csv file.
i want to check the last line contains the character N.


Record Type#Batch Job ID#Batch Number#FileCreation Date#FileCreation Time#Production/Test Fileindicator#File...

#!/bin/bash
i=0
cat 1.csv | while read fileline
do
echo "$fileline"
IFS="#" flds=( $fileline )
nrofflds=${#flds[@]}
echo "noof fields$nrofflds"
fld=0
while [ "$fld" -lt "$nrofflds" ]
do
...