Oracle Table with XMLType-Field: How to define in Uniface 9.4.01

Author: (jfro)

Hello all Does somebody know how to definie a field in Uniface model to be able to read and write in an Oracle Table an XMLType-Field? - Data-Type? - Interface? Thanks a lot! Jürg


  1. 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

    Author: ulrich-merkel (
  2. 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

    Author: Theo Neeskens (
  3. 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.

    Author: jfro (
  4. Hi Jürg, perhaps the following hint may boost your excercise: and more general: perhaps using the SQL Loader (lateral thinking) may help: greetings from Farnkfurt, drowning in snow, Uli

    Author: ulrich-merkel (
  5. 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!

    Author: jfro (