in reply to Re: Interactive Input without Expect.pm
in thread Interactive Input without Expect.pm
and open and get the output...if the SQL is simple and fixed. Or you can use DBI/DBD module for oracle.system ('sqlplus -s /NOLOG @file.sql'); Inside your SQL, set head off feed off ....etc you write spool /script/dir/tmp/file.log; SELECT ..... spool off;
|
|---|