Node.js driver for Oracle Database -XMLTYPE

5bb35ae5-9fb6-4c08-a69e-10259dc25a57 · Feb 27, 2015 9:13AM

Hello everybody,

My application save the orders als XML Strings and I've read that you plan the LOB TYPE for the next release to implement.

When is the XML TYPE planned ?

Beste Regards

Georg

vbuehringer · Feb 27, 2015 9:48AM

you serialize xmltype as a clob and fetch it as a string with node

it works today with varchar column ( 4k in oracle11 and 32k in Oracle12 )

5bb35ae5-9fb6-4c08-a69e-10259dc25a57 · Feb 27, 2015 10:05AM

Thank you, but my orders are bigger then 20k and i use the function of the oracle database.

At present i work with Oracle 11. We will change the database on 12c end of this year.

vbuehringer · Feb 27, 2015 10:25AM

I tested it

it works in oracle 11 until 32k

you have to set maxSize=32000 in your binds

vbuehringer · Feb 27, 2015 10:32AM

and the outparameter in the oracle procedure need to be clob

procedure xmlread ( xml out clob ) as

...

Christopher Jones-Oracle · Feb 27, 2015 7:12PM

Your request for XML support has been noted.

Forum Stats