Search found 753 matches
- 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...
- 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...
- 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...
- 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.
- 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.
I'd love to have it.
- 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 :)
Changes are exactly the same, but this feature can be ported to 7.2 - that's why the second one :)
- 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...
- 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...
- 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...
- 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.
I knew it is possible somehoe, I just had no idea Zeos is capable of doing that too until now.
- 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:
TestApp code:
Result:
- 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 ...
- 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...
I'm currently testing what value should go in there to trigger the error...
- 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 :)
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 :)
- 21.01.2024, 17:30
- 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
Bugtracker ticket created.