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.

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

Resolution

The fix is available in:

• K2 Five (5.4) Fix Pack 34.

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.