Search found 753 matches

by aehimself
09.02.2024, 14:08
Forum: Oracle
Topic: LobCacheMode: OnLoad, OCI 21.7 fails to load CLOBs
Replies: 13
Views: 997

Re: LobCacheMode: OnLoad, OCI 21.7 fails to load CLOBs

I don't know to be honest... I'm not that experienced with the inner life of RDBMS systems, I'm mostly their consumer :) Our expert altered the table, maybe you can try that too? ALTER TABLE mytable MOVE LOB(myfield) STORE AS SECUREFILE(TABLESPACE tablespace) As Oracle advises you not to use BasicFi...
by aehimself
08.02.2024, 23:46
Forum: ZeosLib 7.3/8.0 Forum
Topic: Zeos connection library caching
Replies: 4
Views: 471

Re: Zeos connection library caching

1. More elastic solution would be to pass parameter on function/procedure call or even add procedure to clean the cache from what is clean-able. You definetly can clear the cache on-demand, see the snipplet in my first post. The reason I did not include this is I did not find a way to determine whe...
by aehimself
07.02.2024, 18:04
Forum: Oracle
Topic: Oracle & UTF16 - Fetched column value was truncated (solved...?)
Replies: 28
Views: 1981

Re: Oracle & UTF16 - Fetched column value was truncated (solved...?)

Uff, it is still at large? In my country it's all about the war now, everyone forgot about Covid (thankfully the fully remote work remains). I put a comment in the pull request, some minor adjustments have to be done for the code to stay compatible with older Delphi versions. Once your changes are m...
by aehimself
06.02.2024, 14:08
Forum: Oracle
Topic: LobCacheMode: OnLoad, OCI 21.7 fails to load CLOBs
Replies: 13
Views: 997

Re: LobCacheMode: OnLoad, OCI 21.7 fails to load CLOBs

There are some updates on the bugracker, maybe the issue can be reproduced with the same dump as the UTF16. I'll send you a PM with the original CLOB values.
by aehimself
06.02.2024, 13:49
Forum: Oracle
Topic: Oracle & UTF16 - Fetched column value was truncated (solved...?)
Replies: 28
Views: 1981

Re: Oracle & UTF16 - Fetched column value was truncated (solved...?)

Are you planning to send a pull request about the fixed, sped-up UTF16 version? :)
I'd love to have it.
by aehimself
02.02.2024, 21:01
Forum: ZeosLib 7.3/8.0 Forum
Topic: Zeos connection library caching
Replies: 4
Views: 471

Re: Zeos connection library caching

I opened two pull requests on GitHub: one for master branch, one for 7.2-patches.

Changes are exactly the same, but this feature can be ported to 7.2 - that's why the second one :)
by aehimself
02.02.2024, 19:46
Forum: ZeosLib 7.3/8.0 Forum
Topic: Zeos connection library caching
Replies: 4
Views: 471

Re: Zeos connection library caching

As it turns out FCachedPlainDrivers has to stay as the initial ones are stored here too. So the only thing the conditional directive would do is to disable line 977 in ZDbcConnection.pas {$IFNDEF ZEOS_DISABLE_DRIVER_CACHE}AddPlainDriverToCache(Result, Protocol, LibLocation);{$ENDIF} Tested, works as...
by aehimself
02.02.2024, 18:38
Forum: ZeosLib 7.3/8.0 Forum
Topic: Zeos connection library caching
Replies: 4
Views: 471

Zeos connection library caching

I know we already talked about this but this time I'm bringing a solution proposal too. The thing is, Zeos is automatically caching driver libraries, leaving the handles open even after a connection to a database is closed. You can reproduce the "issue" quite easily: drop a TZConnection on...
by aehimself
29.01.2024, 14:17
Forum: Oracle
Topic: How to connect to Oracle without TnsNames.ora?
Replies: 9
Views: 831

Re: How to connect to Oracle without TnsNames.ora?

My huge issue in the UTF16 error (and the AL32UTF8 64-bit AV too) is my current debugging and this deep Zeos knowledge doesn't seem to be sufficient. I did play around in both and however I did achieve an effect - I did not find the root cause and therefore could not fix them myself. I was hoping fo...
by aehimself
29.01.2024, 08:26
Forum: Oracle
Topic: How to connect to Oracle without TnsNames.ora?
Replies: 9
Views: 831

Re: How to connect to Oracle without TnsNames.ora?

Nice!

I knew it is possible somehoe, I just had no idea Zeos is capable of doing that too until now.
by aehimself
28.01.2024, 23:34
Forum: Oracle
Topic: How to connect to Oracle without TnsNames.ora?
Replies: 9
Views: 831

Re: How to connect to Oracle without TnsNames.ora?

ZConnection setup:
NoTnsNamesOra #1.png
TestApp code:
NoTnsNamesOra #2.png
Result:
NoTnsNamesOra #3.png
by aehimself
28.01.2024, 23:26
Forum: Oracle
Topic: How to connect to Oracle without TnsNames.ora?
Replies: 9
Views: 831

How to connect to Oracle without TnsNames.ora?

We all know the regular way to connect to an Oracle instance: Have your TnsNames.ora file, set your TNS_ADMIN environmental variable, put the connection descriptor in the TnsNames.Ora file and set ZConnection.Database to the descriptor name. But, can we connect to an Oracle database leaving all the ...
by aehimself
23.01.2024, 20:46
Forum: Oracle
Topic: LobCacheMode: OnLoad, OCI 21.7 fails to load CLOBs
Replies: 13
Views: 997

Re: LobCacheMode: OnLoad, OCI 21.7 fails to load CLOBs

It seems they cleared the CLOB fields during obfuscation / cloning.
I'm currently testing what value should go in there to trigger the error...
by aehimself
22.01.2024, 17:19
Forum: ZeosLib 7.3/8.0 Forum
Topic: Possible issue with Oracle, 64bit and stBigDecimal
Replies: 7
Views: 479

Re: Possible issue with Oracle, 64bit and stBigDecimal

Already done :) Do a select * from xxx from the dump. It shows both issues.

UTF16: Bugtracker Thread
Win64 CLOB lcmOnLoad: Bugtracker Thread

Let me know if I should send the dump location again, but it should be in your private message inbox :)