async vs sync shells

Thread Tools Search this Thread
Top Forums Shell Programming and Scripting async vs sync shells
# 1  
Old 03-11-2002
Question async vs sync shells

I am calling a shell script using PL/SQL stored procedures. This works great but I need the calls to be run synchronously and not asynchronously. I need the shell script to finish before returning control back to the procedure. Any ideas?
# 2  
Old 03-11-2002
Not sure I understand but if you are calling one script from another, check out the wait command. This may be what you need.
# 3  
Old 03-11-2002
Let me try to be more clear.

I am using pl/sql to call external scripts using the dbms_pipe utility in oracle. This utility is async by default. The scripts are fired and could run from 20 minutes to three hours depending on the size of the files. I need the script to complete the one run before allowing the user to start another one. Hope this helps.
# 4  
Old 03-12-2002
This sounds more like an issue with the database utility.
You could, however, write it in such a way that when the script begins, it places a "flag" file somewhere, say named something like "dont_run_again". Now, if someone tries to run this twice, it should check for the existance of this file, and quit without running if it finds it. Then, at the end of the original script, remove the file...
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. AIX

Disable async IO at OS level

Hi , User claims that report refresh is taking longer time than usual time and asking us to disable async IO at OS level. 1 DB is running in this server This is prod server OS -- AIX My question is would there be an impact to database and server if we disable async IO in OS? is this... (4 Replies)
Discussion started by: Maddy123
4 Replies

2. Programming

Async webpage read

hi i need to asynchronous connect to webpage which has only text file. need to read its content, line by line using linux socket. any samples? (1 Reply)
Discussion started by: leo2008
1 Replies

3. UNIX for Dummies Questions & Answers


Lets say my default shell is bash and then i load up csh and then ksh. How would i exit csh without exiting ksh? so basically i gone from bash > csh > ksh and i wish to close csh (2 Replies)
Discussion started by: Bill Thompson
2 Replies

4. Solaris

see if async i/o is enabled in Solaris 9

Hi guys. This may be a stupid question but I am trying to see if my Solaris 9 server has async i/o enabled... Is there a quick way to determine this? Thanks in advance. (1 Reply)
Discussion started by: jamie_collins
1 Replies

5. Red Hat

Difference between sync & async in nfs

Hi All.... This is related to exporting a file system through nfs. Just wanted to understand the significance of sync/async in nfs. We give this entry in /etc/export file. What is the difference between these two. Any hep is appreciated. Regards, Amol. (2 Replies)
Discussion started by: Amol21
2 Replies

6. Solaris

Async-Signal-Safe versus MT-Safe

Hi, I am Solaris 9 developer and notice that the documentation does not provide a clear notion of the inherent concurrency in routines defined as "Async-Signal-Safe". Routines defined as "MT-Safe" obviously have the best level of concurrency, compared to normal "Safe" interfaces. I have... (1 Reply)
Discussion started by: tristan12
1 Replies

7. Solaris

Sync to Green vs. Separate Sync

Hi all....I have a Sun Ultra2 that I want to use with my PC monitor. I have purchased an adapter that does not work and I was told I need to change my video card setting (if I can) to Separate Monitor product number ends in 1343......I am running SunOS 5.7 ......anyone have any ideas? ... (0 Replies)
Discussion started by: psantinello
0 Replies

8. Programming

How to Write Linux Friendly Async Socket I/O

I am presently refactoring a windows deamon with an eye towards porting it to linux someday. Presently the application uses a single background thread and asynchronous socket I/O to implement FTP and HTTP clients in a single switch statement (2000 lines and 100 cases just for the switch... (3 Replies)
Discussion started by: siegfried
3 Replies

9. Solaris

Async DNS request

Yes, really can't find anything about this. Can anyone suggest a way, how to do it? This is really what I need for. I need for may be list of system calls to read about or probably some C\C++ sources... Please, help... (1 Reply)
Discussion started by: LocalStorm
1 Replies

10. UNIX for Dummies Questions & Answers

Async or Sync I/O on NFS ?

Solaris 2.8 I know regular filesystems use Async I/O on Solaris 2.8. Does anybody know if NFS uses Sync I/O or Async I/O ? (1 Reply)
Discussion started by: marist89
1 Replies
Login or Register to Ask a Question