Skip to main content

Working with BLOB or CLOB Objects in QTP

By
The below Code will Insert the CLOB or BLOB objects in  Oracle DB using QTP.

Sample Code:


'CLOB or BLOB file Path
strClobFileName = "C:\Jay\SampleInputs\BLOBorCLOB.txt"

'Connection String
strOracleConnectionString =  "Driver= {Microsoft ODBC for Oracle}; " &_
                  "ConnectString=(DESCRIPTION=" &_
                  "(ADDRESS=(PROTOCOL=TCP)" &_
                  "(HOST=hostName) (PORT=1234))" &_
                  "(CONNECT_DATA=(SERVICE_NAME=ABCD)));uid=userName; pwd=Password;"

'Create Required Objects
Set objCon = CreateObject("Adodb.Connection")
Set objRs = CreateObject("Adodb.Recordset")
Set objCom = CreateObject("Adodb.Command")
Set objStream = CreateObject("ADODB.Stream")

'Set the CursorLocation to Get the Record Count properly
objCon.CursorLocation = 3

'Open the Connection
objCon.Open strOracleConnectionString

'Set the required types for Stream Object
objStream.Charset = "us-ascii"
Const adTypeText = 2
objStream.Type = adTypeText

'Open the Stream Object
objStream.Open

'Load the CLOB or BLOB object from the File
objStream.LoadFromFile strClobFileName

'Command to Execute
'Here we should place the "?" for CLOB or BLOB object to
objCom.CommandText = "INSERT INTO TABLE(BLOBorCLOBColumnName,Col2,Col3) VALUES (?,1,2,)"

'set the Active Connection to ADODB Command
objCom.ActiveConnection = objCon

'Execute the Command with CLOB or BLOB object as Input as objStream.ReadText
set objrs1 = objCom.Execute(strMsg,objStream.ReadText,adExecuteNoRecords)

'Read the strMsg to validate wether Record is inserted or not
If strMsg >= 1  Then
    Print "Pass"
Else
    Print "Fail"
End If

Labels

Labels:

Comments

Post a Comment

Popular posts from this blog

PDF Automation in QTP

By
                                                                            The most challenging issue with PDFs is that it could be of any kind, not just a tabular data; it could have plain text, images or even forms to fill up. So this makes a tester’s life a bit difficult, never mind, we will definitely find an easy of do it… Although there are already some better approaches we have to deal with PDF documents but I found many of us are facing so many difficulties using this. There are lots of queries coming at QTP forums asking for an easy way of doing it with PDFs. keeping those in my mind I started c...
Post a Comment
Read more

Convert JSON to XML using QTP/UFT/VBScript

By
Sample Code : Dim strPage,strJSON,objIE strPage = "C:\Jay\JLoader.html" Set objIE = CreateObject("InternetExplorer.Application") objIE.Visible = True objIE.Navigate2 strPage While objIE.Busy : Wend strJSON = "{""FirstName"":""Jay"", ""LastName"":""Krishna""}" Set objWin = objIE.document.parentWindow objWin.execScript "var jsonStr2XML = function(strJSON) { return json2xml(JSON.parse(strJSON));};" Msgbox  oWin.jsonStr2XML(strJSON) objIE.Quit In Detail: Converting The most popular data interchange format JSON(JavaScript Object Notation) to XML using QTP/UFT. Parsing JSON in UFT could be a challenge so we will use JavaScript in UFT to make it perfect. SO We need :              Java Script API  - To Convert JSON to XML                         JavaScript Files :  ...
Post a Comment
Read more

Download Test Resource From QC Using QTP

By
'########################################################################### '* Function Name: QCGetResource '* Designer: Jay '* Date 09-May-2012 '* This script will Download QC Test Resource to a local dir '########################################################################### Function QCGetResource(resourceName,saveTo)     Set qcConn = QCUtil.QCConnection     Set oResource = qcConn.QCResourceFactory     Set oFilter = oResource.Filter     oFilter.Filter("RSC_FILE_NAME") = resourceName     Set oResourceList = oFilter.NewList     If oResourceList.Count = 1 Then         Set oFile = oResourceList.Item(1)         oFile.FileName = resourceName         oFile.DownloadResource saveTo, True     End If         Set qcConn = Nothing     Set oResource = Nothi...
Post a Comment
Read more

compare Two Text files using Vb Script

By
Public Function CompareFiles (FilePath1, FilePath2) Dim FS, File1, File2 Set FS = CreateObject(“Scripting.FileSystemObject”) If FS.GetFile(FilePath1).Size <> FS.GetFile(FilePath2).Size Then CompareFiles = True Exit Function End If Set File1 = FS.GetFile(FilePath1).OpenAsTextStream(1, 0) Set File2 = FS.GetFile(FilePath2).OpenAsTextStream(1, 0) CompareFiles = False Do While File1.AtEndOfStream = False Str1 = File1.Read(1000) Str2 = File2.Read(1000) CompareFiles = StrComp(Str1, Str2, 0) If CompareFiles <> 0 Then CompareFiles = True Exit Do End If Loop File1.Close() File2.Close() End Function Return value: The function returns 0 or False if the two files are identical, otherwise True. Example: File1 = “C:\countries\apple1.jpg” File2 = “C:\countries\apple3.jpg” If CompareFiles(File1, File2) = False Then MsgBox “Files are identical.” Else MsgBox “Files are different.” End If    Source: Mercury Forum’s KB articles
1 comment
Read more

Close All Opened Browsers Except HP Quality Center/ALM

By
Option : I Function  CloseIEExceptALM()                 On   Error   Resume   Next         iCurItr = 0         bExit =  False          Do                           Set  objDlg = Dialog("regexpwndtitle:=.*Internet Explorer.*","Index:=" & iCurItr)              If  Dialog("regexpwndtitle:=.*Internet Explorer.*","Index:=" & iCurItr).Exist(0)  Then                  If  objDlg.WinButton("text:=Cancel","Index:=0").Exist(0)  Then  ...
Post a Comment
Read more