PL/SQL (MOSC)

MOSC Banner

Unable to execute the batch file from DB Trigger

edited Feb 28, 2010 8:54PM in PL/SQL (MOSC) 6 commentsAnswered
I have a form which I am calling from a batch file and I need to call the same batch file from Database Trigger.
I have created the following java source and procedure. I am able to execute normal dos commands but I am not able to open the internet explorer.
Please help me. Thanks in advance.

CREATE OR REPLACE AND COMPILE JAVA SOURCE NAMED Command
AS
import java.io.*;
import java.util.*;
public class Command{
public static void run(String cmdText)
throws IOException, InterruptedException
{
int rtn;
Runtime rt = Runtime.getRuntime();
Process prcs = rt.exec(cmdText);
rtn = prcs.waitFor();
}
}
/

CREATE OR REPLACE PROCEDURE runoscommand(cmd IN VARCHAR2)

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center