10-04-2006
Am I missing something?
If this is really how your script reads, the "exit 0" is going to terminate your script every single time once "unld_date.sql" has been executed.
If it is working with "unld_date.sql" removed then you must also be removing "exit 0". The "exit 0" statement is not tied to the sqlplus command.
So the simple answer to your question is to remove "exit 0".
10 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
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 Replies)
Discussion started by: cobroraj
2 Replies
2. Programming
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 ... (2 Replies)
Discussion started by: zainab
2 Replies
3. UNIX for Advanced & Expert Users
Hi
Can anyone please let me know how to call unix scripts from sql or plsql ASAP. (2 Replies)
Discussion started by: ksailesh
2 Replies
4. 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
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
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... (3 Replies)
Discussion started by: koti_rama
3 Replies
7. Shell Programming and Scripting
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 (1 Reply)
Discussion started by: rajroshan
1 Replies
8. Shell Programming and Scripting
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}... (6 Replies)
Discussion started by: barani75
6 Replies
9. Shell Programming and Scripting
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... (2 Replies)
Discussion started by: Nandy
2 Replies
10. Shell Programming and Scripting
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... (1 Reply)
Discussion started by: kamauv234
1 Replies
rc3(8) System Manager's Manual rc3(8)
NAME
rc3 - Run command script executed when entering a multiuser run level
SYNOPSIS
rc3
DESCRIPTION
The rc3 script contains run commands that enable initialization of the system to a multiuser state; run level 3. In addition to commands
listed within the script itself, rc3 contains instructions to run certain commands found in the /sbin/rc3.d directory. The script defines
the conditions under which the commands execute; some commands run if the system is booting, other commands execute if the system is chang-
ing run levels.
By convention, files in the rc3.d directory begin with either the letter "S" or the letter "K" and are followed by a two-digit number and a
filename; for example: S00inet S55inetd S70mount S65lpd
In general, the system starts commands that begin with the letter "S" and stops commands that begin with the letter "K." Commands that
begin with the letter "K" run only when the system is changing run levels from a higher to a lower level. Commands that begin with the
letter "S" run in all cases. The numbering of commands in the /sbin/rc3.d directory is important since the numbers are sorted and the com-
mands are run in ascending order. Files in the /sbin/rc3.d directory are normally links to files in the /etc/init.d directory.
An entry in the inittab file causes the system to execute the rc3 run commands, for example: s3:3:wait:/sbin/rc3 < /dev/console > /dev/con-
sole 2>&1
The following operations are typical of those that result from executing the rc3 script and the commands located in the /sbin/rc3.d direc-
tory. The operation depends on which state the system is entering or exiting. Setting the time zone Checking the current run level Start-
ing network services and daemons Starting (or stopping) system services and daemons Mounting file systems
Setting the TIMEZONE variable is one of the first operations completed by the rc3 script. This action provides the default time zone for
subsequent commands.
FILES
Specifies the command path Specifies the directory of commands that correspond to the run level
RELATED INFORMATION
Commands: init(8), rc0(8), rc2(8) delim off
rc3(8)