How do execute window command or .bat from PL/SQL
Intake Dates:
Feb 16th to Apr 5th
Mar 16th to May 3rd
create or replace and compile java source named fileexecutecmd as
import java.io.BufferedReader;
import java.io.File;
import java.io.IOException;
import java.io.InputStreamReader;
public class FileExecuteCMD {
public static String fileCMD () {
// JavaRunBatFile javaRunBatFile = new JavaRunBatFile();
ProcessBuilder processBuilder = new ProcessBuilder("C:\\Users\\username\\Downloads\\helloCopy.dat");
try {
System.out.println("testing");
Process process = processBuilder.start();
StringBuilder output = new StringBuilder();
BufferedReader reader = new BufferedReader(
new InputStreamReader(process.getInputStream()));
String line;
while ((line = reader.readLine()) != null) {
output.append(line + "\n");
}
int exitVal = process.waitFor();
if (exitVal == 0) {
System.out.println(output);