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

Thread: using host commands in oracle

  1. #1
    Join Date
    Feb 2006
    Posts
    86

    using host commands in oracle

    can i use host command (net send) through my SQL/ PL - SQL , not in java oracle interface, procedure with computer name or IP as parameter.

  2. #2
    Join Date
    Dec 2001
    Location
    UK
    Posts
    1,684
    Hi.

    There is no native way of calling host commands from PL/SQL. The three options that spring to mind are:

    1) Use a java stored procedure to give you access to the shell:

    http://www.oracle-base.com/articles/...sFromPLSQL.php

    2) Write a shared library and call it using External Procedure (EXTPROC) interface. On Windows you can use the COM Cartridge:

    http://www.oracle-base.com/articles/...tomation8i.php

    3) In Oracle 10g you can schedule executable jobs which run on the OS. This makes calling executable possible, but it is asynchronous, so your code won't wait for completion of the job, and you won't get an error message returned in the event of a problem.

    http://www.oracle-base.com/articles/...heduler10g.php

    Of the three options, I would pick the Java Stored Procedure every time. I guess you don't like this option since you've posted the same question again, after I answered it last time:

    http://www.dbasupport.com/forums/showthread.php?t=50488

    Cheers

    Tim...
    Tim...
    OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
    OCA PL/SQL Developer
    Oracle ACE Director
    My website: oracle-base.com
    My blog: oracle-base.com/blog

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