Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Please help !!
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.