Linux process exit Post: 302972477

Sponsored Content

Top Forums Shell Programming and Scripting Linux process exit Post 302972477 by jim mcnamara on Thursday 5th of May 2016 09:06:28 PM

05-05-2016

Registered User

Oracle DBMS_OUTPUT checks to see if stdout (if it exists) is a tty (or a redirected file) on the controlling process. If there is none, nothing is written, anywhere.

This is because of the operational model of oracle processes in UNIX. One process executes the code, another process is forked from the starting one to connect() to oracle. That second process talks via sockets to a third unique process on the DBMS phyiscal server. There is no way for the server when and if it executes to know what is going on on the other side - the original process that made the connection.

This model holds with minor changes no matter where the original process runs.
Answer:

Code:

1. make sure you understand the location of writable directories on the DBMS server box
that  the DBA has created.  These directory objects can be seen to exist in the view ALL_DIRECTORIES
2. call UTL_FILE - open method for a file in the allowed directory, then: printf method, close method, etc. to write your file.
3. copy it back from the oracle special I/O directory to someplace  useful for your app.

This User Gave Thanks to jim mcnamara For This Post:

jim mcnamara

View Public Profile for jim mcnamara

Find all posts by jim mcnamara

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

exit from telnet kills orbix process

Hi, I'm using a bourne shell to kick off a 3rd Pty app. This app uses Orbix. When I exit from the telnet session which started the app or hit CTRL-C at the command line, the orbix process dies, yet all other process remain. I've tried starting the app as a background process, but it still...

2. Shell Programming and Scripting

way to exit a infinite process

There is a sh file called "agg.sh", this is a kind of negative scenario, this script would fail as expected, but the problem is that after executing the script the following o/p is displayed continuosly without returning the control.We have to press "crtrl+c" to exit the script. ...

3. Programming

Why does my child process not exit?

Im sure it has something to do with the wait() call, but everything ive tried either leaves me with a zombie or with the exec executing indefinitely. switch(pid = fork()) { case -1:perror("fork failed"); exit(1); case 0: if(key == "cd") { execl("/bin/cd", "cd",...

4. Shell Programming and Scripting

Track Child process exit

hi, I have a job that spawns multiple child processes in background.. Catch is i want to wait for some jobs to finish before i spawn more background processes. (each job creates a file and deletes at the end of it . so i don't want start new jobs after x amount of disk size is used up) now,...

5. Shell Programming and Scripting

process and exit to new page

File1 --> into shell file for processing --> file2 I have finished the work on my shell processing script, but I need to call this from a form -->cgi-bin, have the form wait/process bar while processing occurs (5-10 seconds) and then have the shell exit gracefully while transferring to the new...

6. Shell Programming and Scripting

how to exit status of a piped process ???

Hi, I've searched the related threads both in this forum and others in google and found the solution to be working too in most of the places. But somehow it's not working for me. $cmd | tee -a $LOGFILE & pid=$! wait ${pid} ret=$? echo "$ret" I want the exit status of the $cmd....

7. Shell Programming and Scripting

SSH Process monitoring and Exit Status evaluation

Hi All, I have a peculiar requirement as follows, I have a some hosts on which i have to run a script, so i am using the following code piece for i in $HOSTLIST do ssh ${i} "~/task.sh" done Now i want to run this same thing in parallel on all the hosts and then monitor the ssh process...

8. Shell Programming and Scripting

JBOSS process quits on shell exit

I decided to add this here as it's related to bash (IMHO) and not necessarily to JBOSS. The problem started happening a few weeks ago on some of the test systems that I have. When I exit my shell (putty) it hangs forcing me to close the window, which then also stops the JBOSS server. I did not...

9. Shell Programming and Scripting

Catch exit code of specific background process

Hi all, i hava a specific backgroud process. I have de PID of this process. At some time, the process finish his job, is there any way to catch the exit code? I use "echo $?" normally for commands. Thanks!

10. UNIX for Beginners Questions & Answers

Exit() system call verses process signals

Hello and thanks in advance for any help anyone can offer me I've been reading up on process signal calls (sighup, sigint, sigkill & sigterm) and I understand they all have different methods of terminating a running process. From what I've also read is a exit() actually terminates a process. ...

LEARN ABOUT OSF1

false

true(1) 						      General Commands Manual							   true(1)

NAME

       true, false - Returns a standard exit value

SYNOPSIS

       true

       false

STANDARDS

       Interfaces documented on this reference page conform to industry standards as follows:

       true:  XCU5.0

       false:  XCU5.0

       Refer to the standards(5) reference page for more information about industry standards and associated tags.

DESCRIPTION

       The true command returns a 0 (zero) exit value. The false command returns a nonzero exit value. These commands are usually used in input to
       shell commands.

NOTES

       The special built-in utility : (colon) is sometimes more efficient than the true command.

EXIT STATUS

       [Tru64 UNIX]  The nonzero value returned by the false command may vary from system to system.

EXAMPLES

       To construct a loop in a shell procedure, enter: while true do	   date      sleep 60 done

       This procedure displays the date and time once a minute.  To stop it, press the Interrupt key sequence.

SEE ALSO

       Commands:  csh(1), ksh(1), Bourne Shell sh(1b), POSIX shell sh(1p)

       Standards:  standards(5)

																	   true(1)

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

exit from telnet kills orbix process

Discussion started by: edgarm

2. Shell Programming and Scripting

way to exit a infinite process

Discussion started by: villain41

3. Programming

Why does my child process not exit?

Discussion started by: p00ndawg

4. Shell Programming and Scripting

Track Child process exit

Discussion started by: ak_saravanan