Code Fix: Using an Oracle Database Stored Procedure with a row that has multiple lines in it returns the value as a single line string.

  • 16 February 2021
  • 0 replies
  • 1 view

Badge +9

Issue Description

When you have an Oracle Database with a row in a table that has multiple lines in it for example:


ID Text

1 Line 1

Line 2

Line 3


Then when you execute a SmartObject method for the table, the new lines are maintained. However, when doing so via a Stored Procedure that is a simple select on that same table, the new lines are not maintained and are returned as a single line string as illustrated below:


ID Text
1 Line 1Line 2Line3


The fix is available in:


  1. Ensure you have the correct K2 version and/or Cumulative update installed. See KB001893 to see what Fix Pack level you have installed.

  2. Download the latest Fix Pack using the links in the table above for the version you require.

  3. Install the Fix Pack to apply the fix.


0 replies

Be the first to reply!