XMLType field to small for large xml
Posted on 2003-10-22
I'm currently testing XMLType in oracle 18.104.22.168 on windows 2000 server . I need to insert a quite large XML file into an XMLType field (as far as I know XMLType is a CLOB, capable of storing a couple of GB) but when I try to insert an XML file with more than approx 100 lines, I get this error:
ORA-01704: String lateral too long.
My XML file is 4000 characters long (including whitespaces), 123 lines...