-
I want to call shell script within PL/SQL block.
For example:
...
exception
when no_data_found then
CALL_SHELL_SCRIPT_TO_DO_STH_ON_OS_LEVEL;
end;
/
Thank you!
-
External Routine .....
Hi,
This can be worked out by calling an EXTERNAL ROUTINE. The required shell script can be stored in a DLL. You register the routine in your PL/SQL routine, and then call it to perform special-purpose processing.
Still, if you find and other alternative then do share it.
Good Luck,
Pinakin.
-
Dbms_pipe is another way of doing this. In the pl/sql send a message
and that is captured by the daemon running on the background.
Based on the message sent by the pl/sql , daemon would do the
required job. As daemon runs on the background , it is easy
to execute the host command.
The disadvantage of this is to have a daemon running in the background.
As suggested earliear, for oracle 8i , external procedure is a good
option.
-
Just to get notification on this thread, I'm posting this message. Pl. ignore it.
Thanx,
Sam
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|