Execute shell script from plsql trigger Post: 302432369

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Shell script call from a DB trigger

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.

2. UNIX for Dummies Questions & Answers

Can we trigger an shell script on an event

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.

3. Programming

UNIX Shell Script to Create a Document of a PLSQL code.

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...

4. Shell Programming and Scripting

Shell Script to Parse PLSQL code?

5. Programming

running PLSQL scripts through shell script

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

6. Shell Programming and Scripting

How to trigger workflow manager through shell script?

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.

7. Programming

Executing shell script from PLSQL

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...

8. Shell Programming and Scripting

calling a plsql procedure through shell script

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...

9. Shell Programming and Scripting

Shell script trigger using http interface

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...

10. Shell Programming and Scripting

Creating IN list in PLSQL script dynamically by using shell script

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...

LEARN ABOUT DEBIAN

biomaj

biomaj(1)							   USER COMMANDS							 biomaj(1)

NAME

       biomaj - downloads and transform remote biological data banks

SYNOPSIS

       biomaj [-h]

DESCRIPTION

       BioMAJ (BIOlogie Mise A Jour) is a workflow engine dedicated
	to data synchronization and processing.The Software automates
	the update cycle and the supervision of the locally mirrored
	databank repository.  User must have roots rights to run biomaj.

OPTIONS

       -h     display the list of commands.

INSTALL

       At  installation, BioMAJ requires a database to run (MySQL), installer should first create a database (biomaj_log) and a database user (the
       one used at installation setup).
	The database configuration for biomaj can be set or modified in /etc/biomaj/db_properties/global.properties.

       In the install fails due to a SQL error, the install script must be manually run to create/upgrade the database:

       perl /usr/share/biomaj/sql/migration/update.pl

       The script will create/upgrade the database and update the configuration files.

ADMIN USER

       A default admin user (admin) is created by the scripts.	If using the biomaj-watcher, the default password (admin) MUST be changed  immedi-
       atly via the watcher interface.

       If only biomaj core is used, password is useless.
	.PP

UPGRADE

	In the case of a package upgrade, if properly configured, the migration scripts will be ran automatically at install.
	It is possible to run manually the script:
	.B See perl /usr/share/biomaj/sql/migration/update.pl -h
	for usage.

DATA BANKS

       By default, biomaj is configured (data.dir in global.properties) to write banks to /var/lib/biomaj.

EXAMPLES

       Update a bank:
	      biomaj --update genbank

       Show console
	      biomaj --update genbank --console

       Show status:
	      biomaj --status

EXIT STATUS

       biomaj returns a zero exist status if it succeeds, it does not represent the bank update status.

AUTHOR

       Olivier Sallou (olivier.sallou (at) irisa.fr) Romaric Sabas (romaric.sabas (at) irisa.fr)

version 1.2.0							September 14, 2011							 biomaj(1)