| Author |
Message
|
| flahunter |
 Posted: Wed Jul 15, 2009 6:43 pm Post subject: Insert XML datatype into Oracle |
 |
|
Acolyte
Joined: 30 Oct 2008
Posts: 62
|
Hi, all
As you know Oracle 9i can support XMLType element. So i was wondering if Message Broker could support XMLType and how can I insert a XML dataype element into Oracle? |
|
| Back to top |
|
 |
| keenlearner |
| Posted: Wed Jul 15, 2009 9:48 pm Post subject: |
|
|
Acolyte
Joined: 24 Aug 2006
Posts: 62
|
Yes Oracle9i supports the XMLType and Broker can insert and retrieve the XMLType variable from Oracle.
| Code: |
CREATE PROCEDURE <Procedure Name> (IN param1 INTEGER,OUT param3 CHARACTER)
LANGUAGE DATABASE
EXTERNAL NAME "<Database package name.fucntiona name>";
|
The above should give a kick start to you |
|
| Back to top |
|
|
| flahunter |
| Posted: Wed Jul 15, 2009 11:33 pm Post subject: |
|
|
Acolyte
Joined: 30 Oct 2008
Posts: 62
|
Thank you for you answer. But what's the problem I met is I need to insert an XML as an element into database
such as
CREATE PROCEDURE Insert_DB (IN param1 XMLType,OUT param3 CHARACTER)
LANGUAGE DATABASE
EXTERNAL NAME "<Database package name.fucntiona name>";
But it's not supported in Message Broker. Who can give me some ideas? |
|
| Back to top |
|
|
| rekarm01 |
| Posted: Thu Jul 16, 2009 2:49 am Post subject: Re: Insert XML datatype into Oracle |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 1415
|
| flahunter wrote: |
| So i was wondering if Message Broker could support XMLType and how can I insert a XML dataype element into Oracle? |
No, the broker ESQL does not support Oracle's XMLType. Check here for a list of supported data types from external sources.
Inserting an XMLType element into an Oracle table requires:- either a Java Compute node (with Oracle DOM API jars),
- or an Oracle stored procedure to convert a supported parameter type to XMLType.
|
|
| Back to top |
|
|
| flahunter |
| Posted: Mon Jul 20, 2009 7:08 pm Post subject: |
|
|
Acolyte
Joined: 30 Oct 2008
Posts: 62
|
| Thank you. Now I have got some ideas |
|
| Back to top |
|
|
|
|
