XMLType columns disallow a table to be queried

tora-tool / tora

TOra is an open source SQL IDE for Oracle, MySQL and PostgreSQL dbs

http://torasql.com/

GNU General Public License v2.0

290 stars 58 forks source link

Open Helika0n opened 4 years ago

Helika0n commented 4 years ago

Hello,

I've encountered this error while doing a simple query on a table having a XMLType column:

DefinePar: Data type not registered: XMLTYPE(108:58:0:SYS.XMLTYPE:%s)

I've seen an old forum (2014) post about this issue but it seems it hasn't been resolved yet. Is it still planned to be fixed?

Thank you.

malix0 commented 3 years ago

I think you mean that https://sourceforge.net/p/tora/mailman/message/32668947/ The person that open the question in 2014 was me. I said that for me will be good casting XMLTYPE to CLOB, but that never went on.