This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
Extracting the data from the Oracle Table, throws an error
"ErrorSource: OraOLEDB, ErrorMsg: ROW-00004: Invalid column datatype
SQL SELECT .... FROM db.table"
Extraction works fine when commenting out the problematic column. Appreciate your help and support.
Figured out the issue.
The issue is because the field in concern contains NULL values which has to be treated.
Modifying the SQL in QV Script like below
SQL SELECT NVL(PROBLEM_FIELD, NULL) as OBDIENT_FIELD FROM Ddb.table
View solution in original post