Dear all,

I am trying to run OS command from pl/sql, this OS command like pkzipc. I do not have problem running native OS command (Windows) like dir, findstr etc, but not the ones we added, such as pkzipc.

I like to find out how do I run pkzipc within the pl code. I have no problem running other commands using the following java code:

CREATE OR REPLACE AND RESOLVE JAVA SOURCE NAMED "UTLcmd"AS import java.lang.Runtime;public class execHostCommand{ public static void execute (String command) throws java.io.IOException { String osName = System.getProperty("os.name"); if(osName.equals("Windows XP")) command = "cmd /c " + command; Runtime rt = java.lang.Runtime.getRuntime(); rt.exec(command); }}/



Thanks,
Tina