PL/SQL (MOSC)

MOSC Banner

How do execute window command or .bat from PL/SQL

in PL/SQL (MOSC) 1 commentAnswered

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);

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