PLSQL package to run unix / linux zip command to zip files
I am trying to create a PLSQL package and from which I should be able to call Unix / linux commands.
For now, I am using sql to test this.
I am able to use commands like ls, mkdir etc.
But I am trying to ZIP couple of files, it shows as executing without errors, but is not creating any zip file.
select os_command.exec_clob('zip test /tmp/stk/OS_command.sql') command from dual;
COMMAND
--------------------------------------------------------------------------------
updating: tmp/stk/OS_command.sql (deflated 80%)
here I want to zip file test.zip for OS_command.sql, but is not getting created.