Zeoslib Portal

@ludob

Wow.
All the time I supposed that the error is in fpc because the different datasets receives a variety of effects.
Thanks

Michal

@EgonHugeist All right Michael, For now you can make a small :) change in the file ZDbcCache.pas the 74th line: TZByteArray = array [0 ..131062] of Byte; / / M.A. was 65535 // TZRowBuffer size - LazarusWin 131 072B; - Delphi 131 069B I checked on: Zeos7eh1439 (compiles and runs) D2006, DXE2 32/64, ...

@EgonHugeist

Michael,
It is hoped to solve the problem of type BFILE in Oracle?

Michal

@EgonHugeist

Two times I wrote then the error occurred in rev 1433.
Now I'm using rev 1434 and this error does not occur.

Michal

@EgonHugeist

It seems to me that the error was caused by the procedure CreateFields; override;

Michal

@EgonHugeist Following the 1433 changes that was roleback. There was then an error which was not previously: List index out of bounds (8 ) For Oracle table: CREATE TABLE SYSTEM."ADQA_All_types_DTM" ( TNVARCHAR2 NVARCHAR2(2000), TVARCHAR2 VARCHAR2(15), TNUMBER NUMBER, TFLOAT FLOAT, TDATE D...

@EgonHugeist

Michael,
In the case of types that are impossible to identify at the moment could we create a field of a simple fixed type (todo type) and ignore this field of reading and writing data (something like calculated field).

Michal

@EgonHugeist

Zeos7eh1433.
Now I get, for example, when opening TZQuery:
List index out of bounds (14)
(Line 1809, "..\..\src\component\ZAbstractRODataset.pas" + 31)


Probably in the case of an error unable to identify the type.

Michal

@EgonHugeist Here is a simple example of using a BFILE: http://selvirajan.hubpages.com/hub/BFILE-in-Oracle Now I get (Zeos7eh1432) error: ... expected BINARY got FILE ZPlainOracleDriver.pas { OCI Data Types } SQLT_CHR = 1 ; SQLT_NUM = 2 ; SQLT_INT = 3 ; SQLT_FLT = 4 ; SQLT_STR = 5 ; SQLT_VNU = 6 ; ...

@EgonHugeist

Michael,
It seems to me that in Zeos7eh1430 the ORACLE BFILE type is not recognized and supported

Michal

@EgonHugeist

Thanks Michael,
Zeos7eh1430 compiles and runs D2006, DXE2 32/64, LazarusWin1.1.0/fpc 2.7.1 32/64.

I was able to open all Firiebird 2.5 tables I have found .

Michal

@EgonHugeist There is no column "RDB$FIELDTYPES" in table "RDB$TYPES" About RDB$DEBUG_INFO RDB$FIELDS (RDB$FIELD_NAME, RDB$QUERY_NAME, RDB$VALIDATION_BLR, RDB$VALIDATION_SOURCE, RDB$COMPUTED_BLR, RDB$COMPUTED_SOURCE, RDB$DEFAULT_VALUE, RDB$DEFAULT_SOURCE, RDB$FIELD_LENGTH, RDB$F...

@EgonHugeist

"RDB$RELATIONS" work

"RDB$PROCEDURES" and "RDB$TRIGGERS" not
RDB$DEBUG_INFO BLOB SUB_TYPE 9 SEGMENT SIZE 80

Michal

@EgonHugeist

Michael,
Why in Firebird 2.5 when I try to open the "RDB$PROCEDURES" I get:

Similarly, for:
"RDB$RELATIONS"
"RDB$TRIGGERS"

This is probably the type BLOB SUB_TYPE 8 SEGMENT SIZE 80
and BLOB SUB_TYPE 9 SEGMENT SIZE 80.

Michal

@EgonHugeist

Zeos7eh1421 compiles and runs in my environment.

Have you tried Firebird 3 with Zeos7eh?

Would be handy connect to DB2 Express-C (10.1). The free version allows you to 4GB RAM, 2 cores, unlimited database size.

Michal