topic Re: Data extraction from Oracle database in QlikView https://community.qlik.com/t5/QlikView/Data-extraction-from-Oracle-database/m-p/672343#M1061261 <HTML><HEAD></HEAD><BODY><P>Figured out the issue.</P><P>The issue is because the field in concern contains NULL values which has to be treated.</P><P></P><P>Modifying the SQL in QV Script like below</P><P></P><P>SQL SELECT NVL(PROBLEM_FIELD, NULL) as OBDIENT_FIELD FROM Ddb.table </P><P></P><P>worked.</P><P></P><P>-Ram</P></BODY></HTML> Tue, 23 Sep 2014 13:44:10 GMT 2014-09-23T13:44:10Z Data extraction from Oracle database https://community.qlik.com/t5/QlikView/Data-extraction-from-Oracle-database/m-p/672342#M1061260 <HTML><HEAD></HEAD><BODY><P>Extracting the data from the Oracle Table, throws an error </P><P></P><P>"ErrorSource: OraOLEDB, ErrorMsg: ROW-00004: Invalid column datatype </P><P>SQL SELECT .... FROM db.table"</P><P></P><P></P><P>Extraction works fine when commenting out the problematic column. Appreciate your help and support.</P><P></P><P>-Ram</P></BODY></HTML> Tue, 23 Sep 2014 13:14:42 GMT https://community.qlik.com/t5/QlikView/Data-extraction-from-Oracle-database/m-p/672342#M1061260 2014-09-23T13:14:42Z Re: Data extraction from Oracle database https://community.qlik.com/t5/QlikView/Data-extraction-from-Oracle-database/m-p/672343#M1061261 <HTML><HEAD></HEAD><BODY><P>Figured out the issue.</P><P>The issue is because the field in concern contains NULL values which has to be treated.</P><P></P><P>Modifying the SQL in QV Script like below</P><P></P><P>SQL SELECT NVL(PROBLEM_FIELD, NULL) as OBDIENT_FIELD FROM Ddb.table </P><P></P><P>worked.</P><P></P><P>-Ram</P></BODY></HTML> Tue, 23 Sep 2014 13:44:10 GMT https://community.qlik.com/t5/QlikView/Data-extraction-from-Oracle-database/m-p/672343#M1061261 2014-09-23T13:44:10Z