Forum Discussion
joffre
15 years agoRegular Contributor
Hey guys.
Any idea about my newest problem?
I call the function you wrote me
But it doesn't work. Saying that the file specified wasn't found.
On my other script, I was using Windows Command Prompt (cmd.exe). Now I'm using sqlplus.exe, the Oracle Command Prompt. Maybe this is the function problem. Any ideas?
Hope you guys can help me again! :)
By the way. On my other script it works PERFECTLY. Thanks againt!!!
Any idea about my newest problem?
I call the function you wrote me
Function Funcao(strRunCommand)
Dim ShellObj
Set ShellObj = Sys.OleObject("WScript.Shell")
Log.Message("Run Command: " &strRunCommand)
Call ShellObj.Run(strRunCommand, 1, true)
Log.Message("Run command has completed.")
End Function
But it doesn't work. Saying that the file specified wasn't found.
NomeUsuario9i = "TS_F_ORA9_20112"
ScriptRemoverUsuario9i = "DROP USER "& NomeUsuario9i &" CASCADE;[Enter]"
Call Funcao(ScriptRemoverUsuario9i)
On my other script, I was using Windows Command Prompt (cmd.exe). Now I'm using sqlplus.exe, the Oracle Command Prompt. Maybe this is the function problem. Any ideas?
Hope you guys can help me again! :)
By the way. On my other script it works PERFECTLY. Thanks againt!!!