9 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi Forum.
I have the following test.txt file and need to extract certain rows based on "starting position", "length of string" and "string to search for":
1a2b3d
2a3c4d
.....
My script accepts 3 parameters: (starting col pos, length to search for, string to search for) and would like to... (4 Replies)
Discussion started by: pchang
4 Replies
2. UNIX for Dummies Questions & Answers
Version: Oracle Linux 6.6
I am trying to set up DNS for forward and reverse lookups. I am new to BIND package.
I have installed the following packages. bind (includes DNS server, named)
bind-utils (utilities for querying DNS servers about host information)
bind-libs (libraries... (0 Replies)
Discussion started by: kraljic
0 Replies
3. Shell Programming and Scripting
How to call oracle package in shell file
in my shell file, I have
Export SQL FILE =$Home_dir select.sql
if I want to add call two function in package
how can I do it :( (2 Replies)
Discussion started by: Hscript
2 Replies
4. Red Hat
Hey i have a package in oracle to validate file mask. can i call it in through
shell script . if yes , how
Thanks (1 Reply)
Discussion started by: ramsavi
1 Replies
5. Programming
Hi,
I need help selecting rows from a table when a certain column value (City) changes.
In this example of table rows:
ID City Updated_By Updated_Date
99999 PARIS JOHN 04/05/2010 11:28:09.813
99999 PARIS JOHN 04/05/2010 11:32:05.240
99999 PARIS JOHN 04/05/2010 11:32:20.750
99999 PARIS... (1 Reply)
Discussion started by: Renato2011
1 Replies
6. Shell Programming and Scripting
Hi,
Can anyone tell me how to call a oracle package from a Unix shell script? I want to pass some input parameters to package and it will return me the output which I want to use further in my shell script. I want to know the way to capture the output values in my shell script. Please send some... (1 Reply)
Discussion started by: anil029
1 Replies
7. Shell Programming and Scripting
So, in Oracle (11gR2) on aix I have a function like:
CREATE OR REPLACE function COMMON.t2(var1 in varchar2, vari in number,var2 in out number) return number as
begin
insert into korisnik_temp(kor_inicia, kor_opisno) values(1, var1);
var2:=0;
return var2;
exception
when... (12 Replies)
Discussion started by: bongo
12 Replies
8. Shell Programming and Scripting
My sh scripts is :
sqlplus -S "user/pwd@server" <<!!
SET SQLPROMPT
exec IN_PROC_TEST;
!!
It prompt 'PL/SQL procedure successfully completed.' but not execute actually :mad:
I run this procedure in sqlplus, no problem
and I also could execute simple DDL in this sh script, but why... (2 Replies)
Discussion started by: andrewknight
2 Replies
9. Shell Programming and Scripting
Hi all, i am doing a perl script to read from a db. I am able to retrieve the rows, but i am unable to return the number of rows selected. i tried
$selectedrows = $sth->numrows; i got the error msg:
Can't locate object method "numrows" via package "DBI::st"
i changed it to $selectedrows =... (7 Replies)
Discussion started by: new2ss
7 Replies