Integration

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Calling a stored procedure with an XmlType parameter.

584764Nov 6 2007 — edited Nov 7 2007

I am attempting to execute a stored function via a named query. The stored procedure has a single parameter of Oracles 'xmltype', and also returns an xmltype. For example this dummy function

function testXML(xml_in xmltype) return xmltype is

begin
return xml_in;
end;

Is it possible to make the named query call with an oracle.xdb.XMLType or oracle.xdb.dom.XDBDocument? I cannot find any examples of this being done. I also want the returning xmltype to be converted into a Java class.

Another question - will I need to work with a conversion manager to achieve this?

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 5 2007

Added on Nov 6 2007

#application-servers, #toplink-jpa

6 comments

5,223 views