Data extraction from Oracle database

[#1]

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

[#2 · Accepted solution]

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