using host commands in oracle

[binoyshil]

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.

[TimHall]

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...