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?



How do you script this scenario in QTP using VB? Verify XML attributes in XML message against XSD a..

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

Post New Answer

More VB.NET Interview Questions

What is the maximum size of the textbox?

1 Answers  


In order to get assembly info whcih namespace we should import?

1 Answers  


Give the sample code for ItemStockGroupwise Report?

1 Answers   CTS,


What’s the difference between private and shared assembly?

1 Answers  


What is branching logic control in VB.NET?

1 Answers  


Observations between vb.net and vc#.net?

1 Answers  


What do you mean by serialization?

1 Answers  


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?

1 Answers  


What is the Difference between CLR & CTS?

3 Answers  


What are jagged arrays ?

1 Answers  


What is the use of errorprovider control?

1 Answers  


Categories