Dear Sir/Madam,
I use the following way to call the oracle stored procedure in a perl script, but I do not know how to call a oracle function by the following way ?
# ARGV is the oracle stored procedure name with parameters
$str = "sqlplus -s <<-eof \n" .
"$db_login... (0 Replies)
Dear All,
I want to call an sql script within a unix shell script. I want to pass a parameter into the shell script which should be used as a parameter in teh sql script.
e.g
$ ./shell1.sh 5000129
here 5000129 is a prameter
inside shell script i am calling one sql script
e.g. ... (2 Replies)
Hi, for example I have this function:
function get_param ()
{
test=echo "some string"
test2=echo "someother string"
}
I want to call this function and get test or test2 result, how do I do that ?
Thank you (2 Replies)
This is my function which is creating three variables based on counter & writing these variable to database by calling another function writeRecord
but only one record is getting wrote in DB.... Please advise ASAP...:confused:
function InsertFtg
{
FTGSTR=""
echo "Saurabh is GREAT $#"
let... (2 Replies)
Hi,
I am calling a sql file script.sql from shell script and passing few parameters also as shown below:
sqlplus -S id/password @script.sql $param1 $param2
Now,In sql file I have to create a extract text file after querying oracle tables based on the parameters passed(param1,param2) as... (7 Replies)
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:
I must write a shell script that calls two external Perl functions--one of which sorts the data in a file, and... (6 Replies)
I have a function which does awk proceessing
sub mergeDescription {
system (q@awk -F'~' '
NR == FNR {
A = $1
B = $2
C = $0
next
}
{
n = split ( C, V, "~" )
if... (3 Replies)
I have a script which does gunzip, zip and untar.
Input to the script is file name and file directory (where file is located)
I am reading the input parameters as follows:
FILENAME=$1
FILEDIR=$2
I have created 3 functions that are as follows:
1) gunzip file
2) unzip file... (2 Replies)
Discussion started by: pinnacle
2 Replies
LEARN ABOUT NETBSD
prop_data_copy
PROP_DATA(3) BSD Library Functions Manual PROP_DATA(3)NAME
prop_data, prop_data_create_data, prop_data_create_data_nocopy, prop_data_copy, prop_data_size, prop_data_data, prop_data_data_nocopy,
prop_data_equals, prop_data_equals_data -- opaque data value property object
LIBRARY
Property Container Object Library (libprop, -lprop)
SYNOPSIS
#include <prop/proplib.h>
prop_data_t
prop_data_create_data(const void *blob, size_t len);
prop_data_t
prop_data_create_data_nocopy(const void *blob, size_t len);
prop_data_t
prop_data_copy(prop_data_t data);
size_t
prop_data_size(prop_data_t data);
void *
prop_data_data(prop_data_t data);
const void *
prop_data_data_nocopy(prop_data_t data);
bool
prop_data_equals(prop_data_t dat1, prop_data_t dat2);
bool
prop_data_equals_data(prop_data_t data, const void *blob, size_t len);
DESCRIPTION
The prop_data family of functions operate on an opaque data value property object type.
prop_data_create_data(const void *blob, size_t len)
Create a data object that contains a copy of blob with size len. Returns NULL on failure.
prop_data_create_data_nocopy(const void *blob, size_t len)
Create a data object that contains a reference to blob with size len. Returns NULL on failure.
prop_data_copy(prop_data_t data)
Copy a data object. If the data object being copied is an external data reference, then the copy also references the same external
data. Returns NULL on failure.
prop_data_size(prop_data_t data)
Returns the size of the data object. If the supplied object isn't a data object, zero is returned.
prop_data_data(prop_data_t data)
Returns a copy of the data object's contents. The caller is responsible for freeing the returned buffer. If the supplied object
isn't a data object or if the data container is empty, NULL is returned.
In user space, the buffer is allocated using malloc(3). In the kernel, the buffer is allocated using malloc(9) using the malloc type
M_TEMP.
prop_data_data_nocopy(prop_data_t data)
Returns an immutable reference to the contents of the data object. If the supplied object isn't a data object, NULL is returned.
prop_data_equals(prop_data_t dat1, prop_data_t dat2)
Returns true if the two data objects are equivalent. If at least one of the supplied objects isn't a data object, false is returned.
prop_data_equals_data(prop_data_t data, const void *blob, size_t len)
Returns true if the data object's value is equivalent to blob with size len. If the supplied object isn't a data object, false is
returned.
SEE ALSO prop_array(3), prop_bool(3), prop_dictionary(3), prop_number(3), prop_object(3), prop_string(3), proplib(3)HISTORY
The proplib property container object library first appeared in NetBSD 4.0.
BSD April 22, 2006 BSD