| How to pass XML Parameter [message #460139] |
Wed, 09 June 2010 17:59  |
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 #460158 is a reply to message #460149] |
Wed, 09 June 2010 23:34  |
 |
Michel Cadot
Messages: 68731
Registered: March 2007
Location: Saint-Maur, France, https...
|
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
