Does anyone know how to run pl/sql scripts in testpartner?
Suppose you have the file (named for example as abc.sql)stored in c:/data. the fiels contains basicly inserts and uses some functions stored in a DB package. The DB is Oracle.
Suppose you have the info for connecting to the database (driver, server, port,user, password).
May be you need this..
sFileName = ("C:\TMP_Script\Temp.sql")
Set CN = CreateObject("ADODB.Connection")
sCNString = "Connection string Here"
CN.ConnectionString = sCNString
Set Fil = fso.OpenTextFile(sFileName)
Do Until Fil.AtEndOfStream
FileLine = Fil.ReadLine
If UCase(FileLine) = "GO" Then
If FileContents <> "" Then
FileContents = ""
FileContents = FileContents & vbCrLf & FileLine