Toad World® Forums

Executing commands on filesystem directly from plsql


How can you do that?

  1. Create java source and function docmd from script.
  2. Grant Java permissions, the simplest way is to execute function docmd, java command to grant permissions will be showed on output.
    3.Enjoy this.

– this code renames file on unix system:

dbms_output.put_line(docmd(’/usr/bin/mv’,’/usr/file1 /usr/file2’));

Regards Piter
image export error 02.jpeg