Pass linux command line values into sqlplus variable
oramanApr 4 2013 — edited Apr 4 2013hi 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
IS
myvalue:= host df -h
BEGIN
INSERT INTO sizes VALUES (myvalue);
END;
so is it possible to store the output of the sqlplus host command into var and use it for an insert?
thank you