06-28-2006
Try this
If you are using an oracle Database then you can use this. Or else you have to use the executable that could execute the peice where this peice of code uses "sqlplus".
The following code should be in your Unix shell script.
PARAMETERS=`sqlplus -s USERNAME/PASSWORD@db_instance << EOF
set space 0;
set pagesize 0;
set heading off;
set tab off;
set echo on;
set feedback off;
whenever sqlerror exit failure;
declare
l_disable <Datatype>;
l_org_file <Datatype>;
l_fallout_file <Datatype>;
l_outpath <Datatype>;
begin
xxat_safety_stock_main_p(retcode => l_retcode
,errbuf => l_errbuf
,p_overwrite => l_overwrite
,p_disable => l_disable
,p_org_file => l_org_file
,p_fallout_file => l_fall_out_file
,p_path => l_outpath );
DBMS_OUTPUT.PUT_LINE('DISABLE=' || l_disable || '-' || 'ORG_FILE=' || l_org_file || '-' || 'FALLOUT_FILE=' || l_fall_out_file || '-' || 'PATH=' || l_outpath);
end;
EOF`
if [ $? -ne 0 ]
then
echo "Error while getting parameters"
exit 1
else
# These are the parameters returned by the call to your database procedure
DISABLE=`echo $PARAMETER | cut -d "-" -f1 | cut -d "=" -f2`
ORG_FILE=`echo $PARAMETER | cut -d "-" -f2 | cut -d "=" -f2`
FALLOUT_FILE=`echo $PARAMETER | cut -d "-" -f3 | cut -d "=" -f2`
PATH=`echo $PARAMETER | cut -d "-" -f4 | cut -d "=" -f2`
fi
10 More Discussions You Might Find Interesting
1. SCO
I am installing the my package in SCO unix 5.0 .so it will create some temporary directories and files and same will delete.So , 'rm -R ' is not working in system .in the package only it has given this command,so now without this command working we can not go forward.
so kindly help in this... (1 Reply)
Discussion started by: mokri_1980
1 Replies
2. Shell Programming and Scripting
Dear all,
One of our jobs retrieves data from tables and writes it to files. This job was running for around 15 minutes for the past 8 months. Now, this job is runnig for 45-50 minutes. I checked with the DBA's and found no issues with database. The time taken by to job to write to the file is... (5 Replies)
Discussion started by: ranj@chn
5 Replies
3. UNIX for Dummies Questions & Answers
I need help with this:
Can any one tell me what does these below mean:
1. "\(.\).*") != '/'
2. sed 's+^\./++;s+/.*++'
3. sed "s+${f}/+ +
Thanks in advance (7 Replies)
Discussion started by: moe2266
7 Replies
4. Shell Programming and Scripting
hi,
I am using this to get previous month
`date -d"1 month ago" "+%m"`
But will it work for january?..will it return 12?
Please advice. (2 Replies)
Discussion started by: vanathi
2 Replies
5. Shell Programming and Scripting
HI
system.sysUpTime.0 : Timeticks: (1519411311) 175 days, 20:35:13.11
From the above output i need only 175days in a perl script..
Please Help (2 Replies)
Discussion started by: Harikrishna
2 Replies
6. UNIX for Dummies Questions & Answers
Hi all,
I am trying to send a mail by using MAILX option to my YAHOO-Id.
It is giving the following error. Can any one help me to find what is the problem? Do i need to get any kind of settings in my UNIX box for using MAILX?
The bounce mail is as below:
Message 1:
From MAILER-DAEMON Tue... (2 Replies)
Discussion started by: Raamc
2 Replies
7. Solaris
HI Friends,
What is the min. Requirement to install Solaris ZONEs, i am using INTEL PC at home and i allready installed Solaris 10 can i configure ZONES in it, and i want to know the basic information of ZONES. Thanks in Advance. (3 Replies)
Discussion started by: kurva
3 Replies
8. Shell Programming and Scripting
Hi masters,
I have one doubt,
lets's say file1 has the following contents,
1
2.0
3.1
5.5
7
5.10
5.9
How to sort these contents to get the o/p like
1
2.0
3.1
5.5
5.9
5.10
7 (8 Replies)
Discussion started by: ecearund
8 Replies
9. Shell Programming and Scripting
Hi,
I would like to grep for a string within a tag, can someone provide some assistance in how to do it? So I would like to use the grep command to find a string like:
<tag>sometext<tag>
because the sometext can be any number of characters or an type of number or lettering, what expression... (1 Reply)
Discussion started by: cyberfrog
1 Replies
10. Shell Programming and Scripting
Need your help in creating regular expression for particular set. let say I have given two dates 20130623 to 20140625.
I need to create regular for the dates which fall in between above two dates. (4 Replies)
Discussion started by: gvkumar25
4 Replies
LEARN ABOUT SUSE
variable
variable(n) Tcl Built-In Commands variable(n)
__________________________________________________________________________________________________________________________________________________
NAME
variable - create and initialize a namespace variable
SYNOPSIS
variable ?name value...? name ?value?
_________________________________________________________________
DESCRIPTION
This command is normally used within a namespace eval command to create one or more variables within a namespace. Each variable name is
initialized with value. The value for the last variable is optional.
If a variable name does not exist, it is created. In this case, if value is specified, it is assigned to the newly created variable. If
no value is specified, the new variable is left undefined. If the variable already exists, it is set to value if value is specified or
left unchanged if no value is given. Normally, name is unqualified (does not include the names of any containing namespaces), and the
variable is created in the current namespace. If name includes any namespace qualifiers, the variable is created in the specified names-
pace. If the variable is not defined, it will be visible to the namespace which command, but not to the info exists command.
If the variable command is executed inside a Tcl procedure, it creates local variables linked to the corresponding namespace variables (and
therefore these variables are listed by info vars.) In this way the variable command resembles the global command, although the global
command only links to variables in the global namespace. If any values are given, they are used to modify the values of the associated
namespace variables. If a namespace variable does not exist, it is created and optionally initialized.
A name argument cannot reference an element within an array. Instead, name should reference the entire array, and the initialization value
should be left off. After the variable has been declared, elements within the array can be set using ordinary set or array commands.
EXAMPLES
Create a variable in a namespace:
namespace eval foo {
variable bar 12345
}
Create an array in a namespace:
namespace eval someNS {
variable someAry
array set someAry {
someName someValue
otherName otherValue
}
}
Access variables in namespaces from a procedure:
namespace eval foo {
proc spong {} {
# Variable in this namespace
variable bar
puts "bar is $bar"
# Variable in another namespace
variable ::someNS::someAry
parray someAry
}
}
SEE ALSO
global(n), namespace(n), upvar(n)
KEYWORDS
global, namespace, procedure, variable
Tcl 8.0 variable(n)