Call shell script within PL/SQL, How?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Call shell script within PL/SQL, How?

  1. #1
    Join Date
    Jun 2000
    Posts
    295
    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!

  2. #2
    Join Date
    Sep 2000
    Posts
    47

    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.


  3. #3
    Join Date
    Sep 2000
    Posts
    17
    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.

  4. #4
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    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
  •  


Click Here to Expand Forum to Full Width