SAP Knowledge Base Article - Preview

2508171 - HANA Flowgraph error - NULL value error occurs with Oracle data source when Trim() is called on string of all spaces

Symptom

A query against an Oracle remote source that uses a TRIM function on a column populated with spaces returns NULL rather than an empty string


Read more...

Environment

  • SAP HANA
  • SAP HANA Smart Data Integration
  • Oracle remote source

Product

SAP HANA smart data integration all versions

Keywords

Oracle, null, TRIM, space, SDI , KBA , HAN-DP-SDI , SAP HANA smart data integration (SDI) , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.