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 ONE Support launchpad (Login required).

Search for additional results

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