Forum Discussion
Weidson_Cordeir
15 years agoContributor
I´m using Oracle 9i (SQLPLUS) for Run some scripts for Creation table. But when i run the scripts i need a Wait for the Other
Ex:
While 1.sql End Script
I move on to the Other, that is the case in 2.sql.
I took a peek in and found the Post "WScript.Shell"which is used in the CMD.
I'm new to automation and do not know how to use the "WScript.Shell"in my Code.
Code follows in SQLPLUS.
Sub Oracle9i
Dim ConsoleCmd
Dim BaseScrip9i, SenhaBaseScrip9i
Call TestedApps.SqlPlus.Run (1, True)
Set ConsoleCmd = Aliases.SqlPlus.wndConsoleWindowClass
''' Connecting to Oracle 9i
BaseScrip9i = "TS_F_ORA9_20112%%%%%%[ Enter]
SenhaBaseScrip9i = " %%%%%%[Enter]
Typing in''''Console SQLPLUS
Call ConsoleCmd.Keys (BaseScrip9i)
Call ConsoleCmd.Keys (SenhaBaseScrip9i)
End Sub
Can someone help me.