10-30-2007
Passing a unix variable value to a Plsql function
Suppose I have a unix variable called RGNM which is holding a value. Now I want to call a plsql function in my script. THis plsql function takes one IN parameter. I want to pass my UNIX VARIABLE Value to the plsql function. Can i just give it by giving $RGNM in the function after calling sqlplus and function name.
Please help me
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Is it possible to pass a variable name, as a parameter to a function, so it can be created within this function ?
Something like this:
func_uppercase abcdefgh var_name
where the 1st parameter is the string I want to convert and the 2nd is the desired variable name...
$2=`echo "$1" |... (2 Replies)
Discussion started by: 435 Gavea
2 Replies
2. UNIX for Dummies Questions & Answers
Hi,
I am trying to sum up numbered columns and in order to tidy up the program I have wrote a function to do the adding of some numbers. I have a problem though with passing a variable to the function in the UNIX bash shell. The function only gives the first number in the variable list and does... (4 Replies)
Discussion started by: Knotty
4 Replies
3. UNIX for Advanced & Expert Users
Could anyone please help me. I have a function in plsql that returns a number. But i am listing some records through that function using DBMS_OUTPUT.PUT_LINE. I want to catch those records by executing this function through a unix script. The following shows what i did
echo "Connected from... (2 Replies)
Discussion started by: cobroraj
2 Replies
4. UNIX for Dummies Questions & Answers
I would like to know how to pass a variable inside a variable to a function.
sample code below
--------------
for x in 1 9
do
check_null $C$x ##call function to check if the value is null
if
then
echo "line number:$var_cnt,... (2 Replies)
Discussion started by: KingVikram
2 Replies
5. Shell Programming and Scripting
Hi ,
I have three funcions f1, f2 and f3 .
f1 calls f2 and f2 calls f3 .
I have a global variable "period" which i want to pass to f3 .
Can i pass the variable directly in the definition of f3 ?
Pls help .
sars (4 Replies)
Discussion started by: sars
4 Replies
6. Shell Programming and Scripting
what is the maximum length of a unix shell variable which can be can passed to plsql variable:( (1 Reply)
Discussion started by: alokjyotibal
1 Replies
7. Shell Programming and Scripting
following on from below link
https://www.unix.com/shell-programming-scripting/171076-shell-scripting.html#post302573569
i will be using file reading in while loop say for example
while read line123
do
echo "line read is $line123"
insert_funct $line123
done< mysqldump.sql... (6 Replies)
Discussion started by: vivek d r
6 Replies
8. Shell Programming and Scripting
Hello All,
I would like to ask help from you on how to pass variable value from a function that has been called inside the function. I have created below and
put the variables in " ". Is there another way I can do this? Thank you in advance.
readtasklist() {
while read -r mod ver... (1 Reply)
Discussion started by: aderamos12
1 Replies
9. Homework & Coursework Questions
Use and complete the template provided. The entire template must be completed. If you don't, your post may be deleted!
1. The problem statement, all variables and given/known data:
2. Relevant commands, code, scripts, algorithms:
#! /bin/ksh
v="ORG_ID"
... (2 Replies)
Discussion started by: sujitdas2104
2 Replies
10. Shell Programming and Scripting
Hi All,
I'm trying to pass the comma separated values (string) returned from Plsql Procedure to UNIX variable.
getting the below log message
cat: -: Bad file descriptor
awk: cmd. line:1: fatal: error reading input file `-': Bad file descriptor
The output coming from plsql procedure is... (3 Replies)
Discussion started by: Mahesh3089
3 Replies
LEARN ABOUT DEBIAN
trampoline
TRAMPOLINE(3) Library Functions Manual TRAMPOLINE(3)
NAME
trampoline - closures as first-class C functions
SYNOPSIS
#include <trampoline.h>
function = alloc_trampoline(address, variable, data);
free_trampoline(function);
is_trampoline(function)
trampoline_address(function)
trampoline_variable(function)
trampoline_data(function)
DESCRIPTION
These functions implement closures as first-class C functions. A closure consists of a regular C function and a piece of data which gets
passed to the C function when the closure is called.
Closures as first-class C functions means that they fit into a function pointer and can be called exactly like any other C function. func-
tion = alloc_trampoline(address, variable, data) allocates a closure. When function gets called, it stores data in the variable variable
and calls the C function at address. The function at address is responsible for fetching data out of variable immediately, before execu-
tion of any other function call.
This is much like gcc's local functions, except that the GNU C local functions have dynamic extent (i.e. are deallocated when the creating
function returns), while trampoline provides functions with indefinite extent: function is only deallocated when free_trampoline(function)
is called.
is_trampoline(function) checks whether the C function function was produced by a call to alloc_trampoline. If this returns true, the argu-
ments given to alloc_trampoline can be retrieved:
trampoline_address(function) returns address,
trampoline_variable(function) returns variable,
trampoline_data(function) returns data.
SEE ALSO
gcc(1), varargs(3), callback(3)
BUGS
Passing the data through a global variable is not reentrant. Don't call trampoline functions from within signal handlers. This is fixed in
the callback(3) package.
PORTING
The way gcc builds local functions is described in the gcc source, file gcc-2.6.3/config/cpu/cpu.h.
AUTHOR
Bruno Haible <bruno@clisp.org>
ACKNOWLEDGEMENTS
Many ideas were cribbed from the gcc source.
25 October 1997 TRAMPOLINE(3)