title: Executing Host commands using PLSQL
body: <p>We wanted to know if we execute unix host commands from PLSQL program.  </p>
  
  <p>Does this invoke host commands in oracle DB installed OS or we can invoke host commands for different servers? Please suggest. </p>
  
  <p>Have not tried any solution, need suggestions/inputs before implementation.</p>
  
  <p><strong>edit</strong></p>
  
  <p>Our requirement is like we have an application that has app layer and database layer. App layer contains application related programs which interact with database layer for any database information. App layer and database layer reside in different hosts (different ip addresses). Application related programs are unix shell scripts that interact with file system.</p>
  
  <p>Client requirement is that instead of shell script interacting with file system, PL/SQL code should do the work so that we have complete security. </p>
  
  <p>Solutions suggested by Xing and Ozhan are in direction of Java code interacting with file system and providing the related information. Filesystem interaction is done using the <code>host</code> command program in Java. My question is if we run the host commands using java program in app layer will it connect to file system of app layer or will it connect to file system of database layer? We want file system layer of the client system connected, not the database server. </p>
  
  <p>Hope I have articulate my requirement. Please let me know if you need any other info. </p>