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.
- Ensure you have the correct K2 version and/or Cumulative update installed. See KB001893 to see what Fix Pack level you have installed.
- Download the latest Fix Pack using the links in the table above for the version you require.
- Install the Fix Pack to apply the fix.