Problems with version 5.70.0.28 : Doesn't recognize public synonyms

Discussion of open issues, suggestions and bugs regarding ODAC (Oracle Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Helen Annels
Posts: 7
Joined: Thu 26 Jan 2006 15:43
Location: UK

Problems with version 5.70.0.28 : Doesn't recognize public synonyms

Post by Helen Annels » Tue 07 Feb 2006 12:26

My current Delphi2005 application accesses the database using Toratable with TableName set to a public synonym for a table.
(ODAC version 5.55.1.24)

Since upgrading ODAC to 5.70.0.28 the tables can not longer be edited using the public synonyms. The table now appears to be READ ONLY but the READ ONLY property is set to FALSE.

If I change the code to use the table name rather than the public synonym it works OK. However I have different Oracle Users using the program so it needs to work with the synonym.

Challenger
Devart Team
Posts: 925
Joined: Thu 17 Nov 2005 10:53

Post by Challenger » Thu 09 Feb 2006 12:30

We couldn't reproduce your problem. Please send to ODAC support address sample project that to demonstrate this situation, including script to create server objects

Helen Annels
Posts: 7
Joined: Thu 26 Jan 2006 15:43
Location: UK

Post by Helen Annels » Thu 09 Feb 2006 15:40

I have sent a sample project via e-mail.
I have determined that this is only a problem when you have OPTION : NET set to TRUE on the OraSession Component.

Post Reply