Page 1 of 1

Problems with version 5.70.0.28 : Doesn't recognize public synonyms

Posted: Tue 07 Feb 2006 12:26
by Helen Annels
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.

Posted: Thu 09 Feb 2006 12:30
by Challenger
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

Posted: Thu 09 Feb 2006 15:40
by Helen Annels
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.