INSERT large (>4k) XMLDATA

[bug]

Greetings!
I'm trying to insert large amount of data into XMLDATA column (Oracle9i). Unfortunately approach, described in help seems to be not suitable.
I mean error "ORA-22816: unsupported feature with RETURNING clause". I can't also insert data as CLOB (empty_clob()), because I got an error ORA-00932 (data type mismatch).

Can anybody tell me how to do such a thing (I mean subj)

Thanks

 

[Marco Kalter]

You will need Temporary LOB support for this, which is not available in 3.4.

The upcoming 4.0 release supports both Temporary LOB's and the XMLTYPE data type.

------------------
Marco Kalter
Allround Automations