Has anybody been able to execute a shell script call from a database trigger?
If so what are the steps to execute it? Do we have any specific packages in Oracle?
Reards,
Rahul. (1 Reply)
Hi,
My program A updates a log called logA.
I have a shell script S that is responsible to send emails reading from the log.
I want to trigger execution of the script whenever there is an update to the log.
Thanks in advance. (8 Replies)
Hi All,
I am supposed to present the documentation for the PLSQL code (PACKAGES, PROCEDURE, FUNCTIONS) of my application. There are sufficient comments in my code. Has anyone written any Shell Script Utility which can parse the PLSQL code and generate some kind of document ( preferrably HTML not... (1 Reply)
Hi All,
I am supposed to present the documentation for the PLSQL code (PACKAGES, PROCEDURE, FUNCTIONS) of my application. There are sufficient comments in my code. Has anyone written any Shell Script Utility which can parse the PLSQL code and generate some kind of document ( preferrably HTML not... (2 Replies)
I am running the following ealth checks on my server
there are two databases in my server . MODEL1 and MODEL2
i connect with the first database as
sqlplus model1/password
Then i exceute a query
select x from table (4 Replies)
I am new to siebel workflow manager.
Can anyone help me regarding the shell script which will trigger siebel workflow manager.
I want a sample shell script to trigger workflow manager.
Thanks in advance. (2 Replies)
Hi All,
I have a requirement to mv a file in unix from plsql procedure.
for that i have created a java host procedure, a host_command, given all grants as per ORACLE-BASE - Oracle8i Shell Commands From PL/SQL
but i am getting an error ""Process err :/bin/sh: mv Not Found""
kindly let me... (1 Reply)
I have a plsql procedure inside a package which is having one IN parameter .I want to call that procedure through a shell script and that IN parameter is a column of a table in the database. So my requirement is that i need to loop all the entries of that IN parameter from the table through shell... (4 Replies)
Hi
I have created a shell program, which takes a series of parameters as shown in the below code. Its working good from terminal.
My program
restorejob.sh -g <NAME> -p <Path-to-search> -r <Path-to-restore>
Its working fine from bash shell.
I want to extend this functionality like... (1 Reply)
Hi all,
I have a PLSQL script which has a IN list where it takes some ids as input. For example
SELECT * FROM EMPLOYEE WHERE EMPLOYEE_ID IN (comma separated list )
I want to run this quest inside a shell script but I would like to prepare the IN list dynamically where the employee ids... (1 Reply)
Discussion started by: LoneRanger
1 Replies
LEARN ABOUT DEBIAN
vboxmail
vboxmail(8) Linux System Administration vboxmail(8)NAME
vboxmail - script to send notification of new voice message
SYNOPSIS
vboxmail messagename callername callerid mail-to-address
DESCRIPTION
vboxmail is used by vboxgetty to send notification of a new voice message via email. It is not meant to be called directly by any user.
You can make local modifications to this script by copying it from /usr/sbin/vboxmail to /etc/isdn/vboxmail, and editing the copy there.
Note that there is an enhanced version of this script available as /usr/share/doc/isdnvboxserver/vboxmail.enhanced . To use it, copy it to
/etc/isdn/vboxmail . This enhanced version will send the recorded message as a MIME attachment in the email notification. If lame or
xingmp3enc are installed in /usr/local/bin, then the message will be converted to MP3 format; otherwise, it will be sent as a WAV file.
For this to work, you also need the following packages installed:
mime-construct sox
and of course an MP3 encoder if you want MP3 format. Note that the MP3 format will only be 50% smaller (instead of the 90% you might other-
wise expect), because of the relatively bad sound quality to begin with (8kHz sampling, mono). If you want to use another MP3 encoder than
lame or xingmp3enc, you'll have to make patches to the script. I'll be happy to implement your changes. Send them as a wishlist bug report
on isdnvboxserver.
SEE ALSO vboxgetty(8), vboxgetty.conf(5)AUTHOR
This manual page was written by Paul Slootman <paul@debian.org>, for Debian GNU/Linux and isdn4linux.
ISDN 4 Linux 3.25 1998/11/17 vboxmail(8)