Uploaded image for project: 'Reported Issues'
  1. Reported Issues
  2. RI-28

Oracle maxhits smaller than array fetch size: Data was truncated on fetch error

    XMLWordPrintable

    Details

    • Type: Maintenance
    • Status: Under Review (View Workflow)
    • Resolution: Unresolved
    • Labels:
      None
    • Old bug number:
      31768

      Description

      Summary:
      Uniface:
      Oracle is used as database.
      Read trigger uses maxhits in options part.
      Connector options array fetch size and fixed array size are used.
      When maxhits is smaller than array fetch size the following error occurs:
      ORACLE Driver Error [-62]: Data was truncated on fetch.

      Documentation fixed array size:
      Use exact array size specified by array fetch size.
      Do not increase array size for small records.
      So there is a conflict between maxhits and fixed array size
      when array fetch size exceeds maxhits.

      Environment:
      +Uniface Version : 9 / 10
      +Operating System : OS independent
      +Database : Oracle

      Reproduction scenario
      1. Oracle used as database for the data.
      2. Read trigger uses maxhits in options part: read options "maxhits=1"
      3. Oracle connector options array fetch size and fixed array size are used:
      usys$ora_params array fetch size 2, fixed array size
      4. A retrieve is done

      Expected Result
      One record retrieved

      Actual Result
      No record retrieved and in log file the error
      ORACLE Driver Error [-62]: Data was truncated on fetch.

        Attachments