running PLSQL scripts through shell script Post: 302346629

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Running SQL Scripts from Shell script - Need insight!

I've a script that fetches various values from the database as below: #! /bin/ksh $conn="user/pwd@service_name" `sqlplus -s << $conn EOF1 @xyz.sql @pqr.sql @abc.sql EOF1` The output of the script should generate txt files containing the results from queries which are further...

2. UNIX for Dummies Questions & Answers

Problem running plsql & unix commands in 1 script

Hi, I need help again. When I run this shell script, it only runs the unld_date.sql piece and exits. How can I structure this to run all the way to the end? When I don't have the unld_date.sql piece in here, everything runs fine from the date compare piece all the way to the end. Thanks in...

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. Shell Programming and Scripting

Automatic running of Shell scripts

Hi, I have this problem of merging 2 shell scripts and run it one after the other. For eg: script A runs to give OutputA. This OutputA should become the input of script B which will run to give OuputB. Now this has to happen automatically i.e, script A and script B should run consecutively one...

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

7. Shell Programming and Scripting

Execute shell script from plsql trigger

Hi, I have been assigned a job which requires me to send mails from unix(Mailx) upon on certain actions triggered in the database. On insert/update of a certain field into one of the database tables the shell script present in Unix box responsible to send mail though mailx needs to be triggered...

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

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

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

mongo

MONGO(1)							  Mongo Database							  MONGO(1)

NAME

       mongo - the Mongo command-line tool

SYNOPSIS

       mongo [OPTIONS] [DB_ADDRESS] [FILE+]

DESCRIPTION

       mongo  is  a JavaScript shell (with GNU readline capabilities).	It supports interactive and non-interactive use.  When used interactively,
       JavaScript can be used to query the database or perform any other function normally available with SpiderMonkey.  Database output  is  dis-
       played in JSON format.

       If JavaScript files are specified on the command line, the shell will run non-interactively, running each one in sequence and then exiting.

EXAMPLES

       mongo  start the shell, connecting to the server at localhost:27017 and using the test database

       mongo foo
	      start the shell using the foo database at localhost:27017

       mongo 192.169.0.5/foo
	      start the shell using the foo database at 192.169.0.5:27017

       mongo 192.169.0.5:9999/foo
	      start the shell using the foo database at 192.169.0.5:9999

       mongo script1.js script2.js script3.js
	      run three scripts and exit

OPTIONS

       --shell
	      run the shell after executing files

       --help show usage information

       --host HOST
	      server to connect to (default HOST=localhost)

       --port PORT
	      port to connect to (default PORT=27017)

       --nodb do not connect to mongod

       --eval SCRIPT
	      evaluate JavaScript

       -u USERNAME
	      specify user to log in as

       -pPASSWORD
	      specify password of user (notice there is no space)

COPYRIGHT

       Copyright 2007-2009 10gen

SEE ALSO

       For more information, please refer to the MongoDB wiki, available at http://www.mongodb.org.

AUTHOR

       Kristina Chodorow

10gen								     June 2009								  MONGO(1)