Hi
i'm calling a pl/sql procedure which is returning one variable.
i'm trying to assing this value to variable in shell script
the code i wrote is
** in shell script**
var= 'sqlplus user/pass @ret.sql'
echo $var
**
and
variable dum_var number
exec rt_test(:DUM_VAR);
exit;
in... (4 Replies)
Hello,
I need some help from the experts on PL/SQL and Shell scripting. I need a shell script that runs a PL/SQL procedure and gets the values returned from the PL/SQL procedure into the shell variables. The PL/SQL procedure returns multiple values.
I was able to assign a single return value... (1 Reply)
Hi guys,
I am quite new in shell scripting.
I am tring to promote some oracle jobs into control-M. In control-M, I am calling a script which establishes a connection with database and execute some procedures. Now I want if that PL/sql Block got failed script should return failure to... (2 Replies)
Hello, I wanted to delete all files which are placed 14 days back. Here is my below script. My script works very well and it deletes all files 14 days back.
I wanted to display message incase if the delete script is not successful. The below script returns always successful. But the directory... (6 Replies)
I tried searching the forum for similar posts but its closed now.
Would appreciate any help on this.
I am trying to capture return value from a select query into a variable.
DB is Oracle
I am able to spool it to a file but I donot intend to use it.
Here is my script that does not work ;)
I... (27 Replies)
How could I call an Oracle PL/SQL procedure from any shell (bash) and catch returning value from that procedure (out param) or get a returning value if it's a function.
also, I got into trouble when I tried to send a number as a param
#!/bin/bash -e
username=$1
pwd=$2
baza=$3... (0 Replies)
I've a script of the following form calling a simple sql that counts the no of rows as based on some conditions. I want the count returned by the sql to get assigned to the variable sql_ret_val1. However I'm finding that this var is always getting assigned a value of 0. I have verified by executing... (1 Reply)
there is something wrong with my system. when I do this:
diff file1 file1 && echo 1
the output is 1.
but
diff file1 file2 >/dev/null && echo 1
output nothing
while
diff file1 file2 >/dev/null || echo 1
shows 1.
the same with "grep" return status. they are both GNU utilities.... (5 Replies)
Hi Experts:
I have a shell script that's kicked off by cron. Inside this shell script, I need to kick off two or more oracle sql scripts to process different groups of tables. And when both sql scripts are done, I will continue in the shell script to do other things like checking processing... (3 Replies)
Hi,
I am trying to capture logs of the script in the file as well as on the screen. I have used exec and tee command for this. While using exec command I am getting the correct output in the file but, script output is not getting displayed on the screen as it get executed.
Below is my sample... (14 Replies)
Discussion started by: Prathmesh
14 Replies
LEARN ABOUT HPUX
nlist_ia
nlist_ia(3C)nlist_ia(3C)NAME
nlist_ia: nlist(), nlist64() - get entries from name list on Integrity systems
SYNOPSIS
Command: [flag]... [library]...
Remarks
The use of symbol table type and value information is inherently nonportable. The use of or should reduce the effort required to port a
program that uses such information, but complete portability across all HP-UX implementations cannot be expected.
This manpage describes and for Itanium-based systems. For and on PA-RISC systems, see nlist_pa(3C).
DESCRIPTION
and have basically the same functionality and they can process SOM or ELF files. The structure is the same as and is used for source code
compatibility.
The or function examines the name list in the executable file whose name is pointed to by file_name, and selectively extracts a list of
values and puts them in the array of structures pointed to by nl. The array of structures initially contains only the names of variables.
Once the or function has been called, the variable names are augmented with symbol information. The list is terminated by a null name,
which consists of a null string in the variable-name position of the structure. The name list of the file is searched for each variable
name. If the name is found, the symbol's type, scope, and value in the file is inserted into the name list structure. If the file
searched is an ELF file, the section index is also inserted. For SOM files, the subspace index is inserted. The symbol value is 64-bit.
If the file searched is a SOM file, then the value field is zero padded. If the name is not found, the fields in the name list structure
are set to 0. The structures and are defined in the include file See a.out(4) and nlist(4) for further description of the symbol table
structure.
The file must have the organization and symbol table described for an file in a.out(4). The information is extracted from the symbol table
used by the linker, ld(1).
On machines that have such a file, this subroutine is useful for examining the system name list kept in file In this way programs can
obtain system addresses that are up to date.
RETURN VALUE
All structure fields are set to 0 if the file cannot be found or if it is not a valid object file containing a linker symbol table.
and return:
An error occurred.
Success.
WARNINGS
The header file is automatically included by for compatibility. However, including is discouraged if the only information needed from is
for use by or If is included, the line may need to follow it.
SEE ALSO ld(1), elf(3E), a.out(4), nlist(4).
STANDARDS CONFORMANCE Integrity Systems Onlynlist_ia(3C)