Problem running plsql & unix commands in 1 script Post: 302091789

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

calling plsql function in a unix script

Could anyone please help me. I have a function in plsql that returns a number. But i am listing some records through that function using DBMS_OUTPUT.PUT_LINE. I want to catch those records by executing this function through a unix script. The following shows what i did echo "Connected from...

2. Programming

Running UNIX Commands from C

Hi, -How can I get number of files, cpu usage (percentage), memory usage, disk usage, ...etc, using C program ... I can use unix command ( system(command) )but I want the value to be returned back to my C program to use it in my code? How can I do that? Thanks in advance ...

3. UNIX for Advanced & Expert Users

Calling unix script from sql or plsql

Hi Can anyone please let me know how to call unix scripts from sql or plsql ASAP.

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

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

Running multiple unix commands in a single script

Hi, I would like to write a script with include more than 6 unix commands. my script like below: echo " script started" ls -ld bdf | grep "rama" tail -10 log.txt ... .. ... now, i want to run above unix commands one by one. example: first the ls -ld command will be...

7. Shell Programming and Scripting

Running unix commands in a perl script

Executing two unix commads via perl script one after another e.g: make clean bsub -i -q short make have tried using exec but the second command doesnt executes

8. Shell Programming and Scripting

How to pass value from plsql script to unix bash?

Hi This is my bash script.i am calling validation.sql and passing a value to it using ${flds}. i want the cnt variable in plsql script to be passed to unix. LOADREC=`sqlplus -s $ORACLE_USR <<-EOF spool $ORACLE_LOG_FILE; echo "barani" @validation.sql #calling the plsql script ${flds}...

9. Shell Programming and Scripting

Problem running db2 commands in awk

Hi , I am trying to use the below in awk but failed, any one assist please, awk '{ print $0; if ( $0 ~ /LOADTMP1/ ) { print $4; Table_name=system($( db2 -x "SELECT TRIM(TD.BSCHEMA) || '.' || TRIM(TD.BNAME) AS TABLE_NAME FROM SYSCAT.TABDEP TD WHERE TD.BTYPE='T' AND...

10. Shell Programming and Scripting

Problem running plsql using printf command on bash shell

I am running plsql using printf on a shell, but i am getting some strange error, can someone point what exactly am i missing, $ echo $SHELL /bin/bash $ printf " > SET serveroutput ON trimspool on feed off echo off > declare > p_val number; > d_val varchar2(10); > begin > SELECT...

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)

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

calling plsql function in a unix script

Discussion started by: cobroraj

2. Programming

Running UNIX Commands from C

Discussion started by: zainab

3. UNIX for Advanced & Expert Users

Calling unix script from sql or plsql

Discussion started by: ksailesh

4. Programming

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

Discussion started by: gauravsachan