Sponsored Content
Top Forums UNIX for Beginners Questions & Answers Shell script to execute Oracle procedure and trigerring email on success and failure Post 303042402 by senmng on Monday 23rd of December 2019 04:01:44 PM
Old 12-23-2019
What's the other option to return the value to the shell script and use the same in the IF condition?

Can you please show some examples using UTL_SMTP and UTL_mail to send emails on the success?
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Execute an Oracle stored procedure from a shell scrip

Here is a snippet of my code: if then echo "\n Deleting all reports older than 24 hours. \n" >> $logfile ls -l $FileName >> $logfile ... (1 Reply)
Discussion started by: mh53j_fe
1 Replies

2. Shell Programming and Scripting

run shell script from oracle store procedure

hi, this is urgent..can i run a shell script from store procedure without using java. (8 Replies)
Discussion started by: arnabb4u
8 Replies

3. Shell Programming and Scripting

Calling an Oracle Stored Procedure from Unix shell script

hai, can anybody say how to call or to execute an oracle stored procedure in oracle from unix... thanks in advance.... for ur reply.... by, leo (2 Replies)
Discussion started by: Leojhose
2 Replies

4. Shell Programming and Scripting

How to execute an Oracle procedure using shell

Hi , i have created an .sh file that has the following code: #!/bin/ksh sqlplus -s p1istuat/p1istuat@CWS_IST6 @Procedure_Execute.sql & sqlplus -s p1istuat/p1istuat@CWS_IST6 << EOF exit EOF The mentioned Procedure_Execute.sql file inside has the following code: exec TEST; ... (5 Replies)
Discussion started by: vins_san
5 Replies

5. Shell Programming and Scripting

Invoking Oracle stored procedure in unix shell script

Here's a shell script snippet..... cd $ORACLE_HOME/bin Retval=`sqlplus -s <<eof $TPDB_USER/april@$TPD_DBCONN whenever SQLERROR exit 2 rollback whenever OSERROR exit 3 rollback set serveroutput on set pages 999 var status_desc char(200) var status_code... (1 Reply)
Discussion started by: hidnana
1 Replies

6. Shell Programming and Scripting

Shell Script for call a procedure in Oracle DB

Hi everyone! I'm new with Shell Scripting, and I have to do a shell script to call a procedure, which have 2 input parameters, the directory(from server) and the txt file (which have informations to update/insert in DB). I have to create a shell script to execute that procedure for each txt... (5 Replies)
Discussion started by: renatoal
5 Replies

7. Shell Programming and Scripting

How to execute the stored procedure from shell script

How to execute the stored procedure from shell script and is there any possibility to print the dbms output in a log file. (2 Replies)
Discussion started by: dineshmurs
2 Replies

8. Shell Programming and Scripting

Execute a shell script from Oracle procedure

Hi Gurus, Want to execute a shell script from a oracle procedure and get the status of the same, any assistance in this regard will be appreciated. proc_data.sh is script name which I want to execute from oracle procedure It should work something like below procedure test begin... (1 Reply)
Discussion started by: palanisvr
1 Replies

9. Shell Programming and Scripting

Why i can't execute the procedure in shell script?

i have the following code inside a shell script .prog in oracle server when i call the program DBMS_OUTPUT.PUT_LINE(x_return_status|| ln_rep_req_id); will return 0 , it is very strange , i try to submit the concurrent request in oracle , and it can successfully executed, what am i missing ? i... (1 Reply)
Discussion started by: feilhk
1 Replies

10. Shell Programming and Scripting

Execute Oracle gather stats via shell script

Hi , I am trying to automate a gather stats in shell script #!/usr/bin/ksh export ORACLE_HOME=/orcl/app/oracle/product/11.2.0.1/db_1 export PATH="$PATH:$ORACLE_HOME/bin" export LD_LIBRARY_PATH="$LD_LIBRARY_PATH:$ORACLE_HOME/lib32" export TNS_ADMIN=/opt/netprobe/config... (1 Reply)
Discussion started by: neil.k
1 Replies
MAILINSPECT(1)															    MAILINSPECT(1)

NAME
mailinspect - sort an mbox by category and pipe emails to a command. SYNOPSIS
mailinspect [-zjiI] -c category FILE [-gG regex]... [-s command] [-p style] [-o scoring] mailinspect -V DESCRIPTION
mailinspect reads the single mbox folder named FILE and sorts it in order of similarity to the category, which must have been created by dbacl(1). It can be used as a command line tool or interactively, when given the -I switch. When used as a command line tool, mailinspect prints the sorted list of emails on STDOUT. Each line consists of a seek position for the given email within FILE, followed by the score and a description string in one of several styles chosen via the -p option. When supplying a command string in conjunction with the -s option, mailinspect spawns a shell and executes command for every email in FILE (possibly selected via the -g or-G options), in the sorted order. This is similar to the formail(1) functionality, except the latter doesn't order the emails. In interactive mode, all the command line functionality is available via keypresses. The sorted list of emails is displayed in a scrollable format, and can be viewed, searched, tagged, resorted and sent to shell commands. Predefined shell commands can be associated with function keys. See the usage section below. The sorting heuristics are currently (and may always be) experimental, so there is no guarantee that the orderings are particularly well suited for anything. EXIT STATUS
mailinspect returns 1 on success, 0 if some error occurred. OPTIONS
-c Use category to compute the scores and sort the emails, which should be the file name of a dbacl(1) category. -g Only emails matching the regular expression regex are sorted. All other emails are ignored. When several -g and -G options are present on the command line, earlier regular expressions are overridden by later ones where applicable. -i Force internationalized mode. -j Force regular expression searches to be case sensitive. -o Determines the scoring formula to be used. The parameter scoring must be an integer greater than or equal to zero. By default, scor- ing equals zero. -p Prints the email index in the given style. The parameter style must be an integer greater than or equal to zero. By default, style equals zero. -s For each email in the list, execute the shell command, with the email body on STDIN. Emails are processed in sorted order. -z Reverse sort order. Normally, emails are sorted in order of closest to furthest relative to category, but in this case, the opposite is true. -I Interactive mode. Instead of printing the sorted list of emails on STDOUT, emails are displayed and can be scrolled, viewed, searched and piped interactively at the terminal. -G Only emails not matching the regular expression regex are sorted. Opposite of -g switch. -V Print the program version number and exit. USAGE
mailinspect needs to read a prelearned category before it can sort the emails in FILE. See dbacl(1). Suppose you have two mail folders named good.mbox and bad.mbox respectively. You can create appropriate categories by typing the commands % dbacl -l good good.mbox -T email % dbacl -l bad bad.mbox -T email Next, you can type the following command to view interactively the bad.mbox file with the emails whose score is closest to the category good listed first: % mailinspect -I -c good bad.mbox Alternatively, you might be interested only in the five emails in the folder bad.mbox whose score marks them as the furthest away from the category bad, completely independently from any other category such as good (ie you want outliers in the scoring sense). % mailinspect -z -c bad bad.mbox | head -5 In interactive mode, the following keys are defined: o toggles another scoring formula. p toggles another display style. q exits mailinspect. s sends the currently highlighted email to a shell command. S sends all currently tagged emails to a shell command, in sorted order. Every email executes the shell command independently. t tags the currently highlighted email. T tags all listed emails. v sends the currently highlighted email to $PAGER for viewing. If the environment variable PAGER is not defined, sends the email to less(1). u untags the highlighted email. U untags all listed emails. z reverses the sort order of displayed emails. / searches for a regular expression (see regex(7)) anywhere within the contents of all listed emails. Hides all emails which don't match. ? like /, but hides all emails which match, keeping all those which don't match. As a convenience, the function keys F1-F10 can each be associated with a shell command string. In this case, typing a function key has the same effect as the S key, but the command is already typed and ready to be edited/accepted. The function key associations are read from the configuration file .mailinspectrc if it exits. FILES
$HOME/.mailinspectrc mailinspect reads the file .mailinspectrc in the $HOME directory, if it exists. This is a plain text file which contains entries of the form # this is a comment F2 cat >> interesting.mbox F5 mail zarniwoop@megadodo.com ENVIRONMENT
DBACL_PATH When this variable is set, its value is prepended to every category filename which doesn't start with a '/'. SOURCE
The source code for the latest version of this program is available at the following locations: http://www.lbreyer.com/gpl.html http://dbacl.sourceforge.net AUTHOR
Laird A. Breyer <laird@lbreyer.com> SEE ALSO
bayesol(1), dbacl(1), less(1), mailcross(1), regex(7) Version 1.12 Bayesian Text Classification Tools MAILINSPECT(1)
All times are GMT -4. The time now is 11:34 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy