Oracle Sequences & Blob changes

martinrame · Post by **martinrame** » 24.10.2006, 20:13

In the file ZdbcOracle.pas, the CreateSequence method isn't included.

To include it, just add that method to the TZOracleConnection class with this code:

TZOracleConnection = ...
...
public
function CreateSequence(const Sequence: string; BlockSize: Integer):
IZSequence; override;
...

and in the implementation section:

function TZOracleConnection.CreateSequence(const Sequence: string; BlockSize: Integer): IZSequence;
begin
Result := TZOracleSequence.Create(Self, Sequence, BlockSize);
end;

The second file to change is ZDbcOracleResultSet.pas, method procedure TZOracleResultSet.Open. This change correct a bug related to blob fields:

Replace the contents of SQLT_BLOB with:

procedure TZOracleResultSet.Open;
...
SQLT_BLOB:
begin
CurrentVar.ColType := stBinaryStream;
CurrentVar.TypeCode := CurrentVar.DataType;
end;
...

Post by **mdaems** » 24.10.2006, 22:33

Hi Martinrame,

I hope you did test it well. There was an other post concerning CLOBs indicating a similar solution, so I changed both.

This changes has been committed to testing branch in revision 157.

If you use SVN, can you check this version?

If not, this patch will be open until somebody else confirms the effectiveness or until you can test after next release.

Mark

martinrame · Post by **martinrame** » 25.10.2006, 14:13

The Blob related change is the same propossed by another user.

I joined the Blob and Sequences changes into this post because both affect the Oracle driver.

With respect to your testing concern, i did't made an exhaustive testing, just with a couple of scenarios. I'll get the revision 157 to look what happens.

Thanks for your promptly action.

Sincerely,
Leonardo M. Ramé
http://leonardorame.blogspot.com

martinrame · Post by **martinrame** » 25.10.2006, 15:08

Can you tell me the url of the svn "testing" branch? I only can see the Trunk.

Post by **mdaems** » 25.10.2006, 15:39

Almost same URL svn://www.firmos.at/zeos/branches/testing

If you only see trunk in TortoiseSVN Repo Browser : click on the + or - symbol of the project root.

See in tutorials forum for more details about different branches/releases ...

Mark

martinrame · Post by **martinrame** » 25.10.2006, 15:46

Thanks, i was using svn://www.firmos.at/zeos/testing (without "branches").