09-18-2012
Help in Database Procedure returns value
We have a database procedure that returns a value by reference.
This is how it is used in ABF:
h_status = pr_get_passphrase
(h_passphrase = BYREF(:gv_passphrase));
Is it possible to do the same in PHP?
9 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
Hey guys,
I have this problem : I can run on an sqlprompt
!ftp_file2.ksh test.xml 172.16.204.81 Anonymous Anonymous
which will ftp the file from Unix to an NT machine, but if I do
exec shell('sh ftp_file2.ksh test.xml 172.16.204.81 Anonymous Anonymous') it does NOTHING.
I have no... (4 Replies)
Discussion started by: vidireporting
4 Replies
2. Shell Programming and Scripting
HI,
i want to write a script (Linux) that:
1) connect to a database oracle
2) execute some store procedure.
Can anybody help me, please?
Thanks a lot
Andrew (3 Replies)
Discussion started by: manichino74
3 Replies
3. Shell Programming and Scripting
Hi,
I have a sybase stored procedure which takes two input parameters (start_date and end_date) and when it get executed, it gives few records as an output.
I want to write a unix script (ksh) which login to the sybase database, then execute this stored procedure (takes the input parameter as... (8 Replies)
Discussion started by: amit.mathur08
8 Replies
4. Solaris
hi..
i have a need .. my php runs on my linux redhat box with mysql.. i want my php code to refer another mysql database
which is in solaris 10 x86... can u tell me the procedure ..
how it can be done through php .. sorry am new to php...
is it possible to redirect from linux mysql to... (7 Replies)
Discussion started by: senkerth
7 Replies
5. Solaris
I installed Oracle 10 software on Solaris 11 Express, everything was fine execpt I can't create database using dbca.rsp file. I populated file with following options.
OPERATION_TYPE = "createDatabase"
GDBNAME = "solaris_user.domain.com"
SID = "solaris_user"
TEMPLATENAME = "General... (0 Replies)
Discussion started by: solaris_user
0 Replies
6. Solaris
Hello,
I am supposed to check the RAID health of a system but when I type metastat it says "there are no existing databases"
Does this mean that there is no RAID configured at all? Is there any other utility I should try?
I know the system has two disks.
Tanks! (8 Replies)
Discussion started by: cevspencer
8 Replies
7. Shell Programming and Scripting
I have a reseller account with hostgator, which means i have WHM and Cpanel. I have set up a staging environment for one of my wordpress installations (client website), which is essentially sitting at staging.domain.com (live site is at domain.com). The staging website is a complete copy of the... (1 Reply)
Discussion started by: nzrobert
1 Replies
8. UNIX for Dummies Questions & Answers
mon_yy=${1}
date_found=`find_end_day $mon_yy`
export_dealer_changes ${date_found}
Hello
I am trying to pull a formatted date back from the function find_end_day and pass it into the function export_dealer_changes. When I try the above the variable date_found is empty. I have tried various... (3 Replies)
Discussion started by: treemyf
3 Replies
9. Shell Programming and Scripting
Hi,
I need to return a value from the function. the value will be the output from cat command which uses random fucntion.
#!/bin/ksh
hello()
{
var1=$(`cat /dev/urandom| tr -dc 'a-zA-Z0-9-!%&()*+,-/:;<=>?_'|fold -w 10 | head -n 1`)
echo "value is" var1
return var1
}
hello
var=$?... (2 Replies)
Discussion started by: Nandy
2 Replies
LEARN ABOUT OSF1
xrmenumeratedatabase
XrmEnumerateDatabase(3X11) XrmEnumerateDatabase(3X11)
NAME
XrmEnumerateDatabase - enumerate resource database entries
SYNOPSIS
#define XrmEnumAllLevels 0
#define XrmEnumOneLevel 1
Bool XrmEnumerateDatabase(database, name_prefix, class_prefix, mode, proc, arg)
XrmDatabase database;
XrmNameList name_prefix;
XrmClassList class_prefix;
int mode;
Bool (*proc)();
XPointer arg;
ARGUMENTS
Specifies the resource database. Specifies the resource name prefix. Specifies the resource class prefix. Specifies the number of levels
to enumerate. Specifies the procedure that is to be called for each matching entry. Specifies the user-supplied argument that will be
passed to the procedure.
DESCRIPTION
The XrmEnumerateDatabase function calls the specified procedure for each resource in the database that would match some completion of the
given name/class resource prefix. The order in which resources are found is implementation dependent. If mode is XrmEnumOneLevel, a
resource must match the given name/class prefix with just a single name and class appended. If mode is XrmEnumAllLevels, the resource must
match the given name/class prefix with one or more names and classes appended. If the procedure returns True, the enumeration terminates
and the function returns True. If the procedure always returns False, all matching resources are enumerated and the function returns False.
The procedure is called with the following arguments:
(*proc)(database, bindings, quarks, type, value, arg)
XrmDatabase *database;
XrmBindingList bindings;
XrmQuarkList quarks;
XrmRepresentation *type;
XrmValue *value;
XPointer arg;
The bindings and quarks lists are terminated by NULLQUARK. Note that pointers to the database and type are passed, but these values should
not be modified.
The procedure must not modify the database. If Xlib has been initialized for threads, the procedure is called with the database locked and
the result of a call by the procedure to any Xlib function using the same database is not defined.
SEE ALSO
XrmGetResource(3X11), XrmInitialize(3X11), XrmPutResource(3X11)
Xlib -- C Language X Interface
XrmEnumerateDatabase(3X11)