How do you script this scenario in QTP using VB?
Verify XML attributes in XML message against XSD and data
mapping of fields to Oracle tables? Verify data in XML to
data in a defined table?
Answer / Akhtar Israr Ahmad
To verify XML attributes against an XSD schema, map XML fields to Oracle tables, and compare XML data with Oracle table data using QTP (QuickTest Professional) in VBScript, you can follow these steps:
1. Parse the XML response using Microsoft's MSXML or QTP's built-in XML functions like DOMDocumentLoad() or XMLFileToDOM().
2. Validate the parsed XML against an XSD schema by calling the MSXML function `Validate()`. This will generate a list of validation errors, if any.
3. Map the XML fields to Oracle tables using QTP's Data Table and Data Source objects. Assign the appropriate data source to the corresponding XML nodes.
4. Read data from the defined Oracle table using ADO (ActiveX Data Objects) functions like `Recordset.Open()` or `Connection.Execute()`.
5. Compare the extracted XML field values with the corresponding values from the Oracle table using QTP's built-in comparison functions, such as Assert.Equal(), Assert.IsTrue(), or custom comparison functions if needed.
| Is This Answer Correct ? | 0 Yes | 0 No |
What is the maximum size of the textbox?
In order to get assembly info whcih namespace we should import?
Give the sample code for ItemStockGroupwise Report?
What’s the difference between private and shared assembly?
What is branching logic control in VB.NET?
Observations between vb.net and vc#.net?
What do you mean by serialization?
write a program to develop a graphic user interface application of marks book with students names and their names.the program should show the following options main menu,add student details,display student details,maximum mark and minimum mark.
1 Answers College School Exams Tests,
Explain and brief about rapid application development tool?
What is the Difference between CLR & CTS?
What are jagged arrays ?
What is the use of errorprovider control?
Visual Basic (800)
C Sharp (3816)
ASP.NET (3180)
VB.NET (461)
COM+ (79)
ADO.NET (717)
IIS (369)
MTS (11)
Crystal Reports (81)
BizTalk (89)
Dot Net (2435)
Exchange Server (362)
SharePoint (720)
WCF (340)
MS Office Microsoft (6963)
LINQ Language-Integrated Query (317)
WPF (371)
TypeScript (144)
Microsoft Related AllOther (311)