04-25-2011
Rename the table, placing a view under that name that calls a stored procedure that calls a UDF that calls the script. Do you care which rows are selected when it is triggered? Where is this passed code coming from?
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
i want to call a oracle function in my shell script (4 Replies)
Discussion started by: dineshr85
4 Replies
2. Shell Programming and Scripting
i have a function written in one shell script and i want to call that function in another shell script and use the value returned by that script.
can any one suggest me how can i do that?
regards,
Rajesh.P (4 Replies)
Discussion started by: rajesh.P
4 Replies
3. UNIX for Dummies Questions & Answers
I have the following code for installing a BSD application stack:
#!/bin/sh
# install dos2unix and unix2dos utilities
echo `date "+%Y-%m-%d %H:%M:%S"` "unix2dos and dos2unix: installing..." >> ~/post_install.log
pkg_add -r unix2dos
# install xfce4 desktop environment
echo `date "+%Y-%m-%d... (3 Replies)
Discussion started by: figaro
3 Replies
4. Shell Programming and Scripting
Here is the following code :
1.
# gcc -c test firstprog.c
the above command will generate a executable file called "test " in which ever directory it is run.
Assuming It will also return a value.
2. In the below SCRIPT . test is a file generated by compiling a c program... (3 Replies)
Discussion started by: Vabiosis
3 Replies
5. Red Hat
please help me in this script
shell script :1
***********
>cat file1.sh
#!/bin/bash
echo "this is first file"
function var()
{
a=10
b=11
}
function var_1()
{
c=12
d=13 (2 Replies)
Discussion started by: ponmuthu
2 Replies
6. Shell Programming and Scripting
#!/bin/bash
FUN_ECHO(){
echo $1
}
FUN_ECHO "hi how are you ?"
This code will work fine.
BUT is it possible to make the following to work ?
FUN_ECHO "hi how are you ?"
FUN_ECHO(){
echo $1
}
I know that the code will be executed line by line. But i have a number of... (5 Replies)
Discussion started by: linuxadmin
5 Replies
7. Shell Programming and Scripting
Hi I have a function :
Make_Report()
{
trx_report=`sqlplus -s $conn_str << @@
set echo off;
set pages 0;
set feedback off;
set verify off;
select srv_trx_s_no,... (1 Reply)
Discussion started by: neeraj617
1 Replies
8. Shell Programming and Scripting
I am getting Segmentation fault at below function call in my script:
get_x() {
sqlplus -s / <<end | grep KEEP | sed 's/KEEP//;s///g'
select 'KEEP' ,table_name from all_synonyms where upper(synonym_name)= '$1';
exit
end
x=$(get_x $1)
echo " SQL OUTPUT IS :: $x"
}
I am getting output of... (1 Reply)
Discussion started by: IB_88
1 Replies
9. Shell Programming and Scripting
Dear All,
I want to know how can i call oracle function from shell script code . My oracle function have around 5 input parameters and one return value.
for name in *.csv;
do
echo "connecting to DB and start processing '$name' file at "
echo "csv file name=$x"
sqlplus -s scoot/tiger <!... (2 Replies)
Discussion started by: Balraj
2 Replies
10. Shell Programming and Scripting
I am converting shell script to Perl. In shell I have a code
parse_prog_args()
{
if
then
while
do
case $1 in
-P* | -p* )
export PROCESS_DATE=$2
export MM=`echo $2 | cut -c5-6`
export DD=`echo $2 | cut -c7-8`
export YY=`echo $2 | cut -c3-4`
export... (4 Replies)
Discussion started by: digioleg54
4 Replies
LEARN ABOUT HPUX
xmtextfieldcut
XmTextFieldCut(library call) XmTextFieldCut(library call)
NAME
XmTextFieldCut -- A TextField function that copies the primary selection to the clipboard and deletes the selected text
SYNOPSIS
#include <Xm/TextF.h>
Boolean XmTextFieldCut(
Widget widget,
Time time);
DESCRIPTION
XmTextFieldCut copies the primary selected text to the clipboard and then deletes the primary selected text. This routine calls the wid-
get's XmNvalueChangedCallback and verification callbacks, either XmNmodifyVerifyCallback or XmNmodifyVerifyCallbackWcs, or both. If both
verification callback lists are registered, the procedures of the XmNmodifyVerifyCallback list are executed first and the resulting data is
passed to the XmNmodifyVerifyCallbackWcs callbacks.
This routine calls the XmNconvertCallback procedures, possibly multiple times, with the selection member of the XmConvertCallbackStruct set
to CLIPBOARD and with the parm member set to XmMOVE. If the transfer is successful, this routine then calls the XmNconvertCallback proce-
dures for the CLIPBOARD selection and the DELETE target.
widget Specifies the TextField widget ID.
time Specifies the time at which the selection value is to be modified. This should be the time of the event that triggered this
request.
For a complete definition of TextField and its associated resources, see XmTextField(3).
RETURN
This function returns False if the primary selection is NULL, if the widget does not own the primary selection, if the function is unable
to gain ownership of the clipboard selection, or if no data is placed on the clipboard. Otherwise, it returns True.
RELATED
XmTextField(3).
XmTextFieldCut(library call)