Uploaded image for project: 'Lucee Development'
  1. LDEV-902

Oracle - Select query with nclob field, returns java object instead of string

    Details

    • Type: Bug
    • Status: Deployed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 5.1.0.17
    • Fix Version/s: 5.0.1.16
    • Labels:
    • Environment:

      All

      Description

      SELECT [nclobfield] FROM table

      cfoutput queryname.nclobfield[1] or cfdump queryname
      returns java object - class oracle.sql.NCLOB

      cfoutput queryname.nclobfield[1].stringValue()
      returns string

      Lucee should cast this object to a string!

        Attachments

          Activity

            People

            • Assignee:
              michaeloffner Michael Offner
              Reporter:
              HarryK Harry Klein
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: