using host commands in oracle Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: using host commands in oracle

  1. #1
    Join Date
    Feb 2006

    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

    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:

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

    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.

    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:


    OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
    OCA PL/SQL Developer
    Oracle ACE Director
    My website:
    My 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