OraFAQ Forum: SQL & PL/SQL » Call XML URL from PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL » Call XML URL from PL/SQL

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Call XML URL from PL/SQL [message #607192]

Mon, 03 February 2014 11:58

shahid17
Messages: 13
Registered: January 2012

Junior Member

Dear All,

From my oracle database, I need to connect to a third party to perform a transaction and then update my tables according to the results I got from the transaction. The third party gave me the URL "https://xxx.xxx.xxx.xxx:7372/training/thirdparty/leco";

and the below code

$ecokashxml = '<?xml version="1.0" encoding="UTF-‐8"?>
<transaction>
<transactionid>27936083</transactionid>
<msisdn>5875265897</msisdn>
<broadcaster>2050</broadcaster>
<card>140472542074</card>
<bouquet>ACC</bouquet>
<amount>25000</amount>
</transaction>';

How can I call this from my pl /sql function or procedure? Please help.

Regards,

Report message to a moderator

Re: Call XML URL from PL/SQL [message #607193 is a reply to message #607192]

Mon, 03 February 2014 11:59

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>How can I call this from my pl /sql function or procedure? Please help.

use UTL_HTTP

Report message to a moderator

Re: Call XML URL from PL/SQL [message #607234 is a reply to message #607193]

Tue, 04 February 2014 02:28

shahid17
Messages: 13
Registered: January 2012

Junior Member

Thanks, can I have an example using XML

Report message to a moderator

Re: Call XML URL from PL/SQL [message #607235 is a reply to message #607234]

Tue, 04 February 2014 02:36

Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Can you post it or a link to it.

Report message to a moderator

Re: Call XML URL from PL/SQL [message #607246 is a reply to message #607235]

Tue, 04 February 2014 04:13

shahid17
Messages: 13
Registered: January 2012

Junior Member

The URL is like https://XXX.XXX.XXX.XXX:7372/training/thirdparty/emo

and the XML is
/*
Create XML

Combine the agreed variables into the same XML structure given below.

*/

$emoxml = '<?xml version="1.0" encoding="UTF-‐8"?>
<transaction>
<transactionid>27936083</transactionid>
<msisdn>89526254</msisdn>
<broadcaster>2050</broadcaster>
<card>140472542074</card>
<bouquet>ACC</bouquet>
<amount>25000</amount>
</transaction>';

Thanks

Report message to a moderator

Previous Topic:	create or replace context abc Using package_name
Next Topic:	Oracle Parallel Hint Query

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 20:53:03 CDT 2024