DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: calling unix

  1. #1
    Join Date
    Aug 2000
    Location
    Jolo, Sulu
    Posts
    639
    Hi!


    How to call unix commands from PL/SQL scripts


    thanks

  2. #2
    Join Date
    Nov 2000
    Location
    Israel
    Posts
    268
    Hi,
    use DBMS_PIPE

  3. #3
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Well, if you are on 8.* it would be much easier (as compared to DBMS_PIPE) to use external procedures through listener's EXTPROC fascility. You should write a simple C program that executes OS command, compile and link it into .so or .dll and register it within database as database library.

    If you are on 8.1.*, you can write a simple java class that executes OS command, register it within database and run it directly from the database - you don't even need to configure EXTPROC in listener in this case.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

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