Zeoslib Portal

The underlying buffer logic hasn't really changed. Is the error consistently repeatable? Can you remove columns from the query until you figure out which one causes the issue? I also have debug code you can put inside the TZOracleResultSet.Next() that I used to debug the buffers (Oracle reports over...

Interesting! Can you narrow it down to the exact record or column that causes the problem? I'll be happy to take a look if it can be replicated. I don't see that error on any of the databases I have access to.

-Mark

In ZDbcOracleUtils NormalizeOracleTypeToSQLType change: if (ScaleOrCharSetForm = SQLCS_NCHAR) or (ConSettings.ClientCodePage.Encoding = ceUTF16) then DataSize := Precision shl 1 to if (ScaleOrCharSetForm = SQLCS_NCHAR) or (ConSettings.ClientCodePage.Encoding = ceUTF16) then DataSize := Precision shl...

I may be misunderstanding, but for Oracle catalog should be empty and schema should be the SEQUENCE_OWNER column of ALL_SEQUENCES. Also in the pull request is the following incorrect? if FConSettings.ClientCodePage.Encoding = ceUTF16 then begin Result.UpdatePAnsiChar(SequenceNameIndex, GetPAnsiChar(...

I think I've got it. In TZPostgreSQLResultSet.DefinePostgreSQLToSQLType there's a check to determine stCurrency vs stBigDecimal: NUMERICOID: if TypeModifier <> -1 then begin ColumnInfo.Precision := (TypeModifier - VARHDRSZ) shr 16 and $FFFF; ColumnInfo.Scale := (TypeModifier - VARHDRSZ) and $FFFF; i...

I'm having a problem and having a hard time debugging what is really going on. The situation: Pg table with a numeric(19,4) column. Value in colum is inserted as 310000000 (310 million) selecting this value gives 3100000000000 (4 digits added to the end that maybe should be decimals?) Oddly enough: ...

Hi Marian.

Try adding the following connection property to see if it helps your case:

MyConn.Properties.Values[ConnProps_OCIMultiThreaded] := 'True';

This puts the Oracle Client into multithreading mode.

-Mark

I think it might be:

Query.Properties.Add('BinaryWireResultMode=false');

to force the character mode data handling. I haven't need to use it though so it would be great to find out the data or type that causes the issue.

-Mark

Looks good to me!

-Mark

Found it. In the constructor for TZCodePageConversionStream it checks the size of the stream. The problem is that this is before the TemporaryLob has been created (which happens in "BeforeWrite".) A quick fix is to check for this specific case in the lobsteam's GetSize and return zero. Thi...

I should add that my dev environment is Delphi 11.3 and my Oracle Client is 21.8 with an Oracle 19 server.

-Mark

Sample code to show the two bugs: program ZeosOraClobUTF8; {$APPTYPE CONSOLE} {$R *.res} uses System.SysUtils, System.Classes, System.Diagnostics, ZDbcIntfs, ZDbcProperties, ZConnection, ZDataset; var ZConn: TZConnection; ZQuery: TZQuery; TempString: String; i: integer; RecID: Integer; RecAClob: Str...

Hey all! I've been doing some work in the Oracle part of Zeoslib relatd to clobs. I have changes almost ready to show but ran into a couple bugs when testing in UTF8 mode. It was driving me bonkers until I realized that the bugs also exist in the current code and weren't caused by my new stuff. It l...

Hi Jan,

Sorry! I guess I was impatient! All good and thanks as always.

-Mark

Hey all,

is the github repo active? It seems to be a few weeks behind. Thanks!

-Mark