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: 26766
Registered: January 2009
Location: SoCal
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: 68625
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: Thu Mar 28 11:36:11 CDT 2024