5 Replies Latest reply: Apr 4, 2013 10:09 AM by oraman RSS

    Pass linux command line values into sqlplus variable

      hi experts,

      I'm wondering if its possible to insert values into a table retrieved from the host within db, without external shell script files, let say in a procedure, so it could look like this:

      create or replace
      PROCEDURE p_sizes

      myvalue:= host df -h

      INSERT INTO sizes VALUES (myvalue);


      so is it possible to store the output of the sqlplus host command into var and use it for an insert?

      thank you