I have created a database link successfully and then made a public synonym.
No problems at all.
However when i use %type to reference a field in the public synonim in forms
it does not compile, the same code compiles without a problem in toad.
CREATE PUBLIC SYNONYM tableA
using something like this works fine in TOAD not in forms :
forms tells me that tableA.fieldA must be declared, TOAD compiles ! i am
at a loss
any help would be appreciated