Hello Sir

i am a beginner level programmar. i have got a task and need help on
that. Plz Help me.

i have to send a http post request from a stored procedure to a URL.
and also from that stored procedure i have to send XML Data to the URL.

i have following XML Info.

<ERECHARGE>
          <TRANS_ID>Vendor's Transaction ID </TRANS_ID>
          <SOURCE_ID> Vendor's Name </SOURCE_ID>
          <MDN> Vendor's MDN </MDN>
          <DEALER_ID> Vendor's Dealer ID </DEALER_ID>
          <REQUEST>
                      <REQUEST_TYPE>ERECHARGE</REQUEST_TYPE>
                      <ATTRIBUTES>
                                 <ATTRIBUTE>
                                            <NAME>TARGET_MDN</NAME>
                                            <VALUE>MDN where recharge
amount to be transferred </VALUE>
                                 </ATTRIBUTE>
                                 <ATTRIBUTE>
                                           <NAME>AMOUNT</NAME>
                                           <VALUE>Recharge
Amount</VALUE>
                                 </ATTRIBUTE>
                                 <ATTRIBUTE>
                                            <NAME>PIN</NAME>
                                            <VALUE>Unique PIN given to
distributor on registration</VALUE>
                                </ATTRIBUTE>
                      </ATTRIBUTES>
          </REQUEST>
</ERECHARGE>

i have to send this information to a URL via a stored procedure.

i have to use stored procedure because we also have to store these
information in a table.

also, we have to store the response from that URL.

now, I am asking about what approach i should take. and how to solve
this problem.

i will be very thankful to you.

thanx