RE: EXE very urgent

RE: EXE very urgent

 

  

Try this.. if this helps u..

Step I:
create or replace java source named "executeexe" as
public class executeexe {
/* Pure Java Code */
static public String exe(String exename) {
Process p= Runtime.getRuntime().exec(exename);
return "success" + exename;
}
}

Step 2:
create or replace function executexe (str varchar2) return varchar as
language java name 'executeexe.exe(java.lang.String) return
java.lang.String';

Step 3 :
select executexe('c:\setup.exe') from dual;

Note : Make sure u have run the initjvm.sql before you start the above
steps,also provide enough memory space for java_pool , shared pool.

Best of luck
Rgds
Kumar

-----Original Message-----
From: Amardeep Singh [mailto:[Email Address Removed] 28 February 2003 12:14
To: LazyDBA.com Discussion
Subject: EXE very urgent


Pls let me know ---->
i want to run an exe from a trigger or a procedure is it possible
??
VERY URGENT
amar



--------
Oracle documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
Oracle LazyDBA home page