03-17-2010
While executing the stored procedure in oracle sql developer it gives me the output parameter value. in this case it gives me the out put as
BATCHRANGE = 16251-16256(BATCHRANGE is the output parameter value given in the stored procedure)
the stored procedure gets executed when i call it from the unix shell script but doesn't output me the outparameter value (i.e BATCHRANGE = 16251-16256)
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
How do you display the script command for a particular output result? Is there an editor that will allow for an echo or sysout of the script that causes an output result? We have hundreds of lines in the script, which we would like to see along with the output, and don't want to have to put in... (5 Replies)
Discussion started by: JeDi
5 Replies
2. Shell Programming and Scripting
Hello,
I've just finished my first script (about displaying open ports on the computer and who opened them) and everything is fine with it but I want to style it a little bit just for the sake of learning how to do this.
What I want to do is make the display like the one of ps, for example,... (6 Replies)
Discussion started by: sanchopansa
6 Replies
3. Shell Programming and Scripting
Hello all,
Code below:
echo "Oracle Filesystems"
echo "------------------"
echo
for j in `df -l -k |grep total|grep ora|grep -v storage|grep -v vg00|awk '{print $1}'`
do
echo $j is `df -l -k $j |grep total|grep ora|grep -v storage|grep -v vg00|awk -F":" '{print $2}'|awk '{print $1}'` KB... (6 Replies)
Discussion started by: LinuxRacr
6 Replies
4. Shell Programming and Scripting
I'm writing a script to analyze the logs of an smtp relay machine and I'd like the final output to be displayed in columns showing results from the previous day, week, month, and 45 days. The problem I'm running into is that I can't figure out how to display the columns neatly so there is no... (1 Reply)
Discussion started by: jjamd64
1 Replies
5. Shell Programming and Scripting
Hi,
I am having an issue with my script, ofcourse...
I am trying to run commands against a remote server, I am pulling the hostnames or IPs from a file list, then looping thru and running the date cmd. I will be running different cmds just trying to get it working first.
The ouput isn't... (2 Replies)
Discussion started by: dfezz1
2 Replies
6. Shell Programming and Scripting
Hi All,
Its extremely urgent regarding the following requirement.
I have created few files in a directory. I have write a program in shell scripting such that it prompts for the filename . once the filename is entered,it should print the contents of the file.
Can anyone help with... (7 Replies)
Discussion started by: radhi2424
7 Replies
7. Shell Programming and Scripting
Hi,
I have a file which contains the data in the below format and need to develop a script which will give the output in the tabular format.
Could you please advice me.
Folder:
Workflow: version .
Workflow run status:
Workflow run error code:
Schedule time:
Workflow run type: ... (2 Replies)
Discussion started by: kandi.reddy
2 Replies
8. Shell Programming and Scripting
Hi
I want to display the following input data into the tabular format as shown in the output.
Input.txt:
Following jobs are in pending state for more than 10 minutes:
JOB_ID JOB_SUBMIT_ID
MAHAR 784308
PUNJA 109367
Following jobs are running for longer time:
JOB_ID... (1 Reply)
Discussion started by: dats
1 Replies
9. Shell Programming and Scripting
Hi All,
I have result log file which looks like this (below): from the content need to consolidate the result and put it in tabular form
1). Intercomponents Checking
Passed: All Server are passed.
======================================================================
2). OS version Checking... (9 Replies)
Discussion started by: Optimus81
9 Replies
10. Solaris
Hello,
I have Solaris 10 running on one of rack server with dual port FC card. Each port of FC card is connected to two switches respectively. I have been trying to test multipathing functionality with one of FC Storage.
While I have two storage controllers , each connected to the two switches... (0 Replies)
Discussion started by: linuxfreaker
0 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)