My Oracle Support Banner

ODBC: ActualSize returns -1 when CacheSize > 1 (Doc ID 395951.1)

Last updated on JUNE 05, 2019

Applies to:

Oracle ODBC Driver - Version 8.1.7.8 and later
z*OBSOLETE: Microsoft Windows XP

Symptoms

Using Oracle's ODBC Driver, Recordset.Fields.ActualSize returns -1 when used with LONG or LOB data, when CacheSize is greater than 1.

This behavior can be reproduced with the following code:

SQL
====
create table blobtab(col1 blob);
insert into blobtab values('1010101010101010');
commit;

 

VB
========
Private Sub Command1_Click()
Dim con As New ADODB.connection
con.open "dsn=orcl;uid=scott;pwd=tiger"
Dim rs As New ADODB.Recordset
rs.CacheSize = 2
rs.open "select * from blobtab", con
MsgBox rs.Fields(0).actualsize
End Sub

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.