Home » Developer & Programmer » JDeveloper, Java & XML » How to pass XML Parameter (Oracle 9i)
How to pass XML Parameter [message #460139] Wed, 09 June 2010 17:59 Go to next message
phari
Messages: 2
Registered: June 2010
Junior Member
Hello All,

We are implementing a new interface where data elements will be passed from Tibco Middleware in XML format to Oracel Stored Procedure and all logic will be written in stored procedure.

What is the type of IN parameter we should use ? Should I use XMLType ?

Can someone give me how to write this stored procedure which takes XML data as IN parameter and how to extract data from this XML data.

Here is the sample XML passed from Tibco to Stored procedure and we have to update few tables with data received.

<q1:Studies>
<q1:Study>
<q1:StudyName>abcdef</q1:StudyName>
<q1:StudyStatusActive>false</q1:StudyStatusActive>
<q1:Product>efgh</q1:Product>
<q1:BriefTitle>test</q1:BriefTitle>
<q1:Title>xxxx</q1:Title>
<q1:Phase>1234</q1:Phase>
<q1:StartDate>06042010</q1:StartDate>
</q1:Study>
</q1:Studies>

Any quick help is appreciated.

Thanks
PH
Re: How to pass XML Parameter [message #460140 is a reply to message #460139] Wed, 09 June 2010 18:12 Go to previous messageGo to next message
BlackSwan
Messages: 21951
Registered: January 2009
Senior Member
>What is the type of IN parameter we should use ? Should I use XMLType ?
It should be the same or comparable datatype as exists within TIBCO.
Re: How to pass XML Parameter [message #460149 is a reply to message #460140] Wed, 09 June 2010 22:16 Go to previous messageGo to next message
phari
Messages: 2
Registered: June 2010
Junior Member
Can someone provide me some samples of how I can parse the values from XML data passed within Oracle stored procedure ? Or point me to some samples in web...
Re: How to pass XML Parameter [message #460158 is a reply to message #460149] Wed, 09 June 2010 23:34 Go to previous message
Michel Cadot
Messages: 57613
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
There are many examples in this forum; just read the topics in the first page of this "JDeveloper, Java & XML" forum.

Regards
Michel
Previous Topic: select current node threw xmlquery
Next Topic: parsing xml
Goto Forum:
  


Current Time: Sun Apr 20 10:09:31 CDT 2014

Total time taken to generate the page: 0.08994 seconds