Hi Jürg, I think thats a matter to talk to your local account manager, would be nice if you can share the reply with us in the community. Greetings from the freezing cold Frankfurt/Germany (after 16 centigrades 4 days ago) , Uli

Hi Jurg, As the XMLType has no direct support in the Uniface Oracle driver I would try treating it as a CLOB. So that would be a String C* Please test carefully since it is not officially supported by Uniface. Feel free to share you use case, maybe more people have ideas for you then. Maybe there is a case to be made for adding XML as a data type to the Uniface model. Regards, Theo

Hello all Just received the official information of my account manager that this Uniface for the moment doesn't support the Oracle datatype XMLType. If I receive an information that it will be supported in future I will put it in here... He recoommende me to create an Oracle View and convert the XMLType in a String... This works of course.. I already did in the past. But this wasn't what I needed to do. My problem is/was that I have to load an XML-File from the disk and want to put this in an Oracle-Table with an XMLType-Field. I did now the following and it seems to work: • I read the XML-File (with FILELOAD, as the "Textdriver" actually doesn't support UTF-8 (yet). • The read XML-File I write in a temporary-table with a CLOB-field (as I know since yesterday, that Uniface doesn't support the use of CLOB as parameters of Oracle-procedures - even there is written something else in documentation/help. It works as long as the CLOB is not longer than 30000 charaters. If is longer it crashes.) • Then I start an Oracle-Procedure. This procedure reads the CLOB from the temporary table and converts the CLOB in a XMLType. This XMLType-field it finally writes in the XMLType-field of the Oracle-table.

Hi Jürg, perhaps the following hint may boost your excercise: http://stackoverflow.com/questions/998055/oracle-loading-a-large-xml-file http://www.oracle-base.com/articles/9i/load-xmltype-from-file.php and more general: http://docs.oracle.com/cd/B28359_01/appdev.111/b28369/xdb03usg.htm perhaps using the SQL Loader (lateral thinking) may help: http://docs.oracle.com/cd/B10500_01/appdev.920/a96620/xdb26loa.htm#1026157 greetings from Farnkfurt, drowning in snow, Uli

Hello Uli Of course I could also load a file directly with Oracle - in theory... My problem is that I have not always a access to the drives the client on his computer has. Thats why I have to do it with Uniface... Thank you!