06-25-2010
Hi,
Firstly, Thank you for the input.
Below are my requirements:
> I have to send mail in html format having dynamic fields like (name,address etc..) which may change from person to person the mail is sent for.
> The template for the mail has to be configrable i.e, it is constant as of now but may be changed in future.
I have also been able to gather a few information about the utl_mail package in 10g which may solve the purpose of sending mail through database, but I am not able to find out if that supports sending email in html format and also support of dynamic data and configurable template.
I see most of this possible in unix, hence lokking at a job from database.
Please do let me know if i can expedite one of these approaches subject to my time lines
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
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)
Discussion started by: rahulrathod
1 Replies
2. UNIX for Dummies Questions & Answers
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)
Discussion started by: cv_pan
8 Replies
3. Programming
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)
Discussion started by: gauravsachan
1 Replies
4. Shell Programming and Scripting
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)
Discussion started by: gauravsachan
2 Replies
5. Programming
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)
Discussion started by: asalman.qazi
4 Replies
6. Shell Programming and Scripting
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)
Discussion started by: siri_886
2 Replies
7. Programming
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)
Discussion started by: aryan_styles
1 Replies
8. Shell Programming and Scripting
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)
Discussion started by: rspnf
4 Replies
9. Shell Programming and Scripting
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)
Discussion started by: rakeshkumar
1 Replies
10. Shell Programming and Scripting
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
update-default-ispell
UPDATE-DEFAULT-ISPELL(8) UPDATE-DEFAULT-ISPELL(8)
NAME
update-default-ispell - update default ispell dictionary
SYNOPSIS
update-default-ispell [--dico-postinst] [--triggered]
DESCRIPTION
WARNING: Not to be used from the command line unless you know very well what you are doing.
This program is intended to be called from ispell dictionary package postinst, from select-default-ispell or from dictionaries-common
postinst (with --dico-postinst).
When called under dpkg control without the --dico-postinst option, a dictionaries-common trigger is enabled to be run later. In the
triggered run (or when is called from the command line or with --trigger option), reads the system default from the debconf database and
set default links in /etc/dictionaries-common pointing to the appropriate files in /usr/lib/ispell/. Also updates the system-wide setting
/etc/dictionaries-common/ispell-default. and rebuilds the /var/cache/dictionaries-common/ispell.db and the emacsen, jed, and SquirrelMail
support (to be put in /var/cache/dictionaries-common/) from the files in /var/lib/dictionaries-common/ispell
When called from from dictionaries-common postinst with --dico-postinst symlinks creation step will be skipped and trigger not enabled.
OPTIONS
--dico-postinst Do not enable trigger nor try to set default symlinks. --triggered Run all the code instead of trying to enable
update-default-ispell trigger
SEE ALSO
The dictionaries-common policy document
AUTHORS
Rafael Laboissiere Agustin Martin Domingo
1.12.11 2013-1-22 UPDATE-DEFAULT-ISPELL(8)