Session is a mess after querying table with SDO_GEOMETRY field in direct mode

Discussion of open issues, suggestions and bugs regarding ODAC (Oracle Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
dados
Posts: 82
Joined: Thu 18 Aug 2005 14:06

Session is a mess after querying table with SDO_GEOMETRY field in direct mode

Post by dados » Fri 15 Jan 2016 13:21

Hi,

If I connect using direct mode and query a table that has a column of type SDO_GEOMETRY I get "NET: Out of memory" error and after that the session is useless even "select * from dual" gives me Unknown error 1

I'm using 9.6.21 on Seattle

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: Session is a mess after querying table with SDO_GEOMETRY field in direct mode

Post by AlexP » Fri 15 Jan 2016 13:41

Hello,

Thank you for the information. We know about the problem and work on its solution. As soon as we fix the behavior, we will inform you.

dados
Posts: 82
Joined: Thu 18 Aug 2005 14:06

Re: Session is a mess after querying table with SDO_GEOMETRY field in direct mode

Post by dados » Sun 17 Jan 2016 17:38

Great, thanks.

One question: Do you guys intend on supporting user defined types in the near future (for direct connections)?

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: Session is a mess after querying table with SDO_GEOMETRY field in direct mode

Post by AlexP » Tue 19 Jan 2016 10:15

These types have already been supported starting in ODAC versions starting from 9.6.19.

dados
Posts: 82
Joined: Thu 18 Aug 2005 14:06

Re: Session is a mess after querying table with SDO_GEOMETRY field in direct mode

Post by dados » Tue 19 Jan 2016 22:52

Whoops :)

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: Session is a mess after querying table with SDO_GEOMETRY field in direct mode

Post by AlexP » Wed 20 Jan 2016 05:45

Feel free to contact us if you have any further questions.

Post Reply