Problem after upgrade from ODAC 10.1.3 to 10.1.4

Discussion of open issues, suggestions and bugs regarding ODAC (Oracle Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
gmis
Posts: 4
Joined: Tue 17 Nov 2015 11:29

Problem after upgrade from ODAC 10.1.3 to 10.1.4

Post by gmis » Mon 05 Feb 2018 14:53

Hi there.

some code:

Code: Select all

procedure TForm1.ButtonClick(Sender: Object);
var
s1, s2: string;
begin
  s1 := oraQuery1COL.AsString;
  s2 := oraQuery1COL.AsString;
  if (s1 <> s2) then
    ShowMessage(':('); // this Message is shown only in 10.1.4
end; // end procedure
DFM:

Code: Select all

object oraQuery1: TOraQuery
    SQL.Strings = (
      'select col'
      'from t_table'
      'where data_id = :ID')
    Options.DeferredLobRead = True
    Left = 680
    Top = 280
    ParamData = <
      item
        DataType = ftUnknown
        Name = 'ID'
        Value = nil
      end>
    object oraQuery1COL: TBlobField
      FieldName = 'COL'
      BlobType = ftOraBlob
    end
  end
Oracle DB 12.1:

Code: Select all

CREATE TABLE "SCOTT"."T_TABLE" 
   (	"DATA_ID" NUMBER NOT NULL ENABLE, 	
	"COL" BLOB
  )
After setting "Options.DeferredLobRead" to "false" it starts working again.
It seems to be a breaking change after ugrading from 10.1.3 to 10.1.4

MaximG
Devart Team
Posts: 1822
Joined: Mon 06 Jul 2015 11:34

Re: Problem after upgrade from ODAC 10.1.3 to 10.1.4

Post by MaximG » Tue 06 Feb 2018 17:15

Thank you for the information. We have reproduced the issue and will investigate its origin. We will inform you about the results shortly.

Post Reply