Uploaded image for project: 'PUBLIC - Liferay Portal Community Edition'
  1. PUBLIC - Liferay Portal Community Edition
  2. LPS-58835

Oracle DBMS_LOB.SUBSTR() is being called in a wrong way.

    Details

      Description

      LPS-56674 introduced the CLOB_CAST_TEXT pseudo function to avoid oracle issues like ORA-00932.

      The SQLTransformer, for Oracle databases, substitutes this pseudo function for DBMS_LOB.SUBSTR($1, 1, 4000)

      According to the oracle documentation, the function takes 3 args:

      • lob_loc
      • amount
      • offset

      We are calling this function DBMS_LOB.SUBSTR($1, 1, 4000) so:

      • lob_loc = LOB field to compute the sub string
      • amount = 1
      • offset = 4000

      So we are getting the 4001th character, which seems not we'd like to get

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              beck.liu Beck Liu
              Reporter:
              daniel.sanz Daniel Sanz
              Participants of an Issue:
              Recent user:
              Brian Wulbern
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Days since last comment:
                5 years, 13 weeks, 6 days ago

                  Packages

                  Version Package
                  7.0.0 Alpha 2