go-run-windowscmd.go

package main

import (
	"fmt"
	"os/exec"
	"path/filepath"
	"strings"
)

func main() {
  // replaces each '/' with the appropriate path separator
	path := filepath.FromSlash("C:/Users/BLTSEC/Desktop/script.sql")
	cmd := "cmd /C echo exit | sqlplus USERNAME/PASSWORD@TNS_NAME @" + path
	parts := strings.Fields(cmd)
	head := parts[0]
	parts = parts[1:len(parts)]
	c := exec.Command(head, parts...)
	if err := c.Run(); err != nil {
		fmt.Println("Error: ", err)
	}
}

// Cradle to hide cmd window
// save in a vbs file
//
// Set oShell = CreateObject ("Wscript.Shell") 
// Dim strArgs
// strArgs = "cmd /c .\GOBINARY.exe"
// oShell.Run strArgs, 0, false