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

Author: juerg.fross@teamspirit.ch (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

5 Comments

  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 (ulrichmerkel@web.de)
  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 (tneeskens@itblockz.nl)
  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 (juerg.fross@teamspirit.ch)
  4. 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


    Author: ulrich-merkel (ulrichmerkel@web.de)
  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 (juerg.fross@teamspirit.ch)