Toad World® Forums

Executing commands on filesystem directly from plsql


#1

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.

Usage:
– this code renames file on unix system:

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

Regards Piter
image export error 02.jpeg