Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Data extraction from Oracle database

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.

-Ram

1 Solution

Accepted Solutions
Not applicable
Author

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

worked.

-Ram

View solution in original post

1 Reply
Not applicable
Author

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

worked.

-Ram

View solution in original post