Linux process exit


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Linux process exit
# 1  
Old 05-05-2016
Linux process exit

friends when I call to a procedure where DBMS_OUTPUT.PUT_LINE bd are having the procedure?
# 2  
Old 05-05-2016
Rephrase, please? I don't think that translated.
This User Gave Thanks to Corona688 For This Post:
# 3  
Old 05-05-2016
Quote:
Originally Posted by Corona688
Rephrase, please? I don't think that translated.
I need to know where are the
DBMS_OUTPUT.PUT_LINE ('Open successful');

when I call a pkgs from a shell
# 4  
Old 05-05-2016
That depends on what's running it and whether any redirection was involved. It could end up in a terminal, get saved to a log file, or be discarded completely.
This User Gave Thanks to Corona688 For This Post:
# 5  
Old 05-05-2016
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:
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. 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. ... (2 Replies)
Discussion started by: bodisha
2 Replies

2. 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! (2 Replies)
Discussion started by: Xedrox
2 Replies

3. 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... (7 Replies)
Discussion started by: victorbrca
7 Replies

4. 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... (1 Reply)
Discussion started by: mihirvora16
1 Replies

5. 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.... (8 Replies)
Discussion started by: ashwini.engr07
8 Replies

6. 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... (1 Reply)
Discussion started by: dba_frog
1 Replies

7. 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,... (2 Replies)
Discussion started by: ak_saravanan
2 Replies

8. 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",... (2 Replies)
Discussion started by: p00ndawg
2 Replies

9. 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 Replies)
Discussion started by: villain41
3 Replies

10. 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... (1 Reply)
Discussion started by: edgarm
1 Replies
Login or Register to Ask a Question

Featured Tech Videos