AE Himself

I have some questions regarding the video you posted: - It appears that there is a web fontend as it shows a browser window and not a Win32 application. Did you check if everything is fine between the Zeos application and the frontend? E.g. correct data is sent to be posted, etc. - Previous point is especially important as according to the video changes aren't discarded, data seems to be malformed somehow (empty lines appear) - I'm using Zeos 8 with MySQL databases for years now and never met this...

Some time ago TZGenericStatementAnalyzer has been expanded to be able to parse all table aliases, even across multiple queries if needed. https://zeoslib.sourceforge.io/viewtopic.php?p=222277 Check if you get your desired results with DefineAllSelectSchemasFromQuery.

I can confirm that the pull request sent by Mark on GitHub fixes the issue on the test case (and the real-world scenario behind). I'll start full-blown experimenting with it to see if it works on the long run but initial tests look more than promising.

We found out that on the affected table the CLOB storage mode was BasicFiles. Changing that to SecureFiles solved the issue, query can be executed without errors Changing the LOB storage mode back to BasicFiles also brought the error back. Which means that the issue should be reproduceable in the dump, after adding some CLOB values... So, my guess is: x64 Zeos, lcmOnLoad caching, newer version of oci.dll and BasicFiles LOB storage is affected.

Some updates: We tried to catch the issue on DB side and did the following: - Created a backup copy of the table where the issue appears - Selecting all data from the backup table is possible, no errors are shown. Due to this, we can safely say that the error will not show up if executed against a new table, filled with the data from the dump - Cleared all lob data from affected (original) table. Running a query was successful, no error popped up - Re-inserted the original values of the CLOB fields...

Pee79, I installed the patched package in 4 different Delphi installations already (2 Delphi 12 and 2 Delphi 11) without any issues. As no component registration methods were changed this also makes me to believe that the problem will be localized to your PC; and is not in Zeos in this case. AVs in the IDE are caused by a 3rd party addon in most of the cases so try to disable them during the installation (GExperts, CNPack, Parnassus just to name a few). It's also possible that you have some remains...

x64 lcmOnLoad with later oci.dlls fail to load CLOBs

ORA-01406: fetched column value was truncated in UTF16