topic Problem with loading SQL_LONGVARBINARY data types in QlikView

Problem with loading SQL_LONGVARBINARY data types

Thu, 16 Sep 2010 12:12:22 GMT

Hi,

I am trying to load data from my ORACLE 11g database into the QV file. I am using the ORACLE ODBC Driver version 11.01.00.07.

QV successfully loads all columns I need except for columns with data type SQL_LONGVARBINARY (-4).

I receive the following script error:

SQL Error:[Oracle][ODBC][Ora]Driver not capable.|SQL Scriptline:|SQL State:S1C00

SQL SELECT *

FROM DatabaseName."Table_Alias"

I figured out that that the SQL_LONGVARBINARY data type was the problem by writing a separate SQL SELECT script for each of the columns I wanted to load. All scripts worked except for the one selecting the column with data type SQL_LONGVARBINARY.

How can I load this? Appreciate very much any help given

Thanks,

Sam

Re: Problem with loading SQL_LONGVARBINARY data types

Tue, 26 Feb 2013 10:33:11 GMT

Please help !!

Re: Problem with loading SQL_LONGVARBINARY data types

Thu, 25 Apr 2013 14:57:14 GMT

Hi Sam,

I found the following:

C.14 LONG VARBINARY [ODBC]

Variable length binary datatype.

http://docs.oracle.com/cd/B19188_01/doc/B15917/sqdatyp.htm#i631572

i dont know what data is stored in the column, but I would (in my limited Oracle knowledge + QlikView knowledge) suggest that you cast it to a string and check if that helps...

I dont think QV can handle binary data.