Is it documented somewhere or can someone tell me what data types are not compatible with QlikView when reading from an oracle database? For instance, I have found out that SDO_GEOMETRY and XMLTYPE cannot simply be loaded via the script (or at least I have not figured out how to do it). Is there a list of database types fields that are acceptable or not? Thanks.
The data type has to be supported by the driver. In case of the odbc driver you can find the data type mapping here. I think those kind of data types simply weren't taking into account when defining the odbc specification. The mapping for the oledb driver can be found here.
The data type has to be supported by the driver. In case of the odbc driver you can find the data type mapping here. I think those kind of data types simply weren't taking into account when defining the odbc specification. The mapping for the oledb driver can be found here.
