01-16-2007
passing oracle parameters from the shell
HI MATE
yes what i was getting at was tryin to pass 2 out parameters so that thay can be individually accessed in back in the shell script.
o in the the example I gave, the oracle packaged procedure is executed returning somthing in its OUT parameters :vi_err and :val_err.
The value of :vi_err can be accessed as it is returned in the EXIT command
but Im not sure how to access the value of :val_err.
I could have used a function as suggested but that would only return the 1 variable not both as i would like.. does that make sense?
Kind Regards
Satnam
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi ,
I want to pass parameters from a shell script to a sql script and use the parameter in the sql query ..and then I want to spool a particular select query on to my unix box... for 4 different locations by writing only one sql script
Right now no file is generated on the unix box...it is a... (2 Replies)
Discussion started by: phani
2 Replies
2. Programming
I am having a shell script which has to be called from a C program. I have to pass two parameters to this script. HOw can I do that?
eg:
int main()
{
char st1;
char str2;
// call a shell script
call_sh(str1,str2) where call_sh is the name of the shell script.
then i need to get the return... (5 Replies)
Discussion started by: Rajeshsu
5 Replies
3. Shell Programming and Scripting
Hi,
I have screen which was desined in PL/SQL Catridges in apps. In that screen some enterable fields these values r the passing parameters to create value sets, functions, menus etc in apps by using front end screens. Now in that screen i have a button. when i click that button it have to... (0 Replies)
Discussion started by: rajasekharamy
0 Replies
4. Shell Programming and Scripting
I am using grep to capture date from a file .
Since i need to use the shell script for different dates ,is it possible to pass the date parameter to the shell script
the Script is as below
grep -E "08 Aug 2008|2008-08-08"* somefile.txt>test.txt
The above script file greps the... (1 Reply)
Discussion started by: sud.tech
1 Replies
5. Shell Programming and Scripting
i have this basic piece of code that i am trying to debug to accept input parameter to be able to display a directory listing of files.
cd /u02/app/eatv/dev/out
CURDIR=`pwd`
echo directory listing of $CURDIR
echo
if ; then
ls -latr
else
ls -latr $1
fi
basically if the script... (9 Replies)
Discussion started by: wtolentino
9 Replies
6. 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
7. Shell Programming and Scripting
Hello,
I have this shell script that runs awk code by passing in parameters however now it doesn't work anymore with the parameters and I don't know why.
It removes duplicates from an input file based on a part of the last field and a key column. It removes the record with the older datetime... (0 Replies)
Discussion started by: script_op2a
0 Replies
8. Shell Programming and Scripting
I am trying to execute a copy command via shell script. However, on occassion, 2 or more files need to copied. How do I code for the multiple arguments? Does it matter how the files are delimited?
Example: I have a script to copy files from 1 dir to another called duplicate.csh
In most... (1 Reply)
Discussion started by: CKT_newbie88
1 Replies
9. Shell Programming and Scripting
Hello All,
I am interested in finding out a way to pass parameters that are entered at the prompt from HP unix and passed to SQLPlus code with a Shell Script. Is this possible?
Thanks (4 Replies)
Discussion started by: compprog11
4 Replies
10. Shell Programming and Scripting
Hi All,
I have a shell script(test_abc.sh) with the following shell commands, which are invoking the same shell script with different parameters.
test_abc.sh
. ./test.sh abc >> test.log
. ./test.sh xyz >> test.log
. ./test.sh pys >> test.log
. ./test.sh abc >> test.log
.
.
... (4 Replies)
Discussion started by: dev.devil.1983
4 Replies
LEARN ABOUT OPENDARWIN
proc
proc(n) Tcl Built-In Commands proc(n)
__________________________________________________________________________________________________________________________________________________
NAME
proc - Create a Tcl procedure
SYNOPSIS
proc name args body
_________________________________________________________________
DESCRIPTION
The proc command creates a new Tcl procedure named name, replacing any existing command or procedure there may have been by that name.
Whenever the new command is invoked, the contents of body will be executed by the Tcl interpreter. Normally, name is unqualified (does not
include the names of any containing namespaces), and the new procedure is created in the current namespace. If name includes any namespace
qualifiers, the procedure is created in the specified namespace. Args specifies the formal arguments to the procedure. It consists of a
list, possibly empty, each of whose elements specifies one argument. Each argument specifier is also a list with either one or two fields.
If there is only a single field in the specifier then it is the name of the argument; if there are two fields, then the first is the argu-
ment name and the second is its default value.
When name is invoked a local variable will be created for each of the formal arguments to the procedure; its value will be the value of
corresponding argument in the invoking command or the argument's default value. Arguments with default values need not be specified in a
procedure invocation. However, there must be enough actual arguments for all the formal arguments that don't have defaults, and there must
not be any extra actual arguments. There is one special case to permit procedures with variable numbers of arguments. If the last formal
argument has the name args, then a call to the procedure may contain more actual arguments than the procedure has formals. In this case,
all of the actual arguments starting at the one that would be assigned to args are combined into a list (as if the list command had been
used); this combined value is assigned to the local variable args.
When body is being executed, variable names normally refer to local variables, which are created automatically when referenced and deleted
when the procedure returns. One local variable is automatically created for each of the procedure's arguments. Global variables can only
be accessed by invoking the global command or the upvar command. Namespace variables can only be accessed by invoking the variable command
or the upvar command.
The proc command returns an empty string. When a procedure is invoked, the procedure's return value is the value specified in a return
command. If the procedure doesn't execute an explicit return, then its return value is the value of the last command executed in the pro-
cedure's body. If an error occurs while executing the procedure body, then the procedure-as-a-whole will return that same error.
SEE ALSO
info(n), unknown(n)
KEYWORDS
argument, procedure
Tcl proc(n)