-
Problem on running os command from pl/sql
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|