vb.net code
Write code in VB.NET to achieve the following task: 1) Call an oracle stored procedure which takes brand_id, region_id as in parameter and returns out_orders and out_lineitems as refcursor 2) Generate an xml using both the out refcursor from above, xml sample below : <?xml version="1.0" encoding="ISO-8859-1"?> <ORDERINFORMATION> <ORDER> <ORDER_ID>1</ORDER_ID> <ORDER_COST>22</ORDER_COST> <ORDERLINE> <PRODUCT>A</PRODUCT> <QTY>2</QTY> </ORDERLINE> <ORDERLINE> <PRODUCT>B</PRODUCT> <QTY>1</QTY> </ORDERLINE> </ORDER> </ORDERINFORMATION> 3) Save this XML to disk. 4) Open this XML from disk and validate if ORDER_COST is a number. 5) Encrypt the XML data using RSA (you can generate your own RSA keys) 6) Send the encrypted string to a web service (you can generate your own web service) Attach the .Net solution