Custom table named "dual" breaks TOCIConnection.GetSessionParameters

Discussion of open issues, suggestions and bugs regarding ODAC (Oracle Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
feelairslow
Posts: 1
Joined: Mon 11 May 2020 15:42

Custom table named "dual" breaks TOCIConnection.GetSessionParameters

Post by feelairslow » Mon 11 May 2020 15:59

Hello,

I wrote a unit test where I created a table named "dual" in my database.
That's obviously a bad practice... but Oracle agreed.

But that broke TOCIConnection.GetSessionParameters.
An easy fix was to change all "from dual" by "from sys.dual".

Could you include this fix in a next release ?
Thank you.

Philippe

MaximG
Devart Team
Posts: 1822
Joined: Mon 06 Jul 2015 11:34

Re: Custom table named "dual" breaks TOCIConnection.GetSessionParameters

Post by MaximG » Fri 15 May 2020 10:46

Thank you for your suggestion. The fix will be included in the next build of our product, which we're currently working on.

Post Reply