View Single Post
  #1 (permalink)  
Old November 11th, 2005, 02:11 AM
kissvineet kissvineet is offline
Registered User
 
Join Date: Oct 2005
Location: noida, UP, India.
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to kissvineet
Default how to send http post request via stored procedure

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


Reply With Quote