| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|  |  | |||
Home -> Community -> Usenet -> c.d.o.tools -> database link problem
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.
Example
CREATE PUBLIC SYNONYM tableA 
FOR userowner.tableA_at_otherdb.WORLD;
using something like this works fine in TOAD not in forms :
declare
       fld_a      tableA.fieldA%type;
   begin
   end;
...
forms tells me that tableA.fieldA must be declared, TOAD compiles ! i am
at a loss
any help would be appreciated
Received on Thu May 31 2001 - 10:10:29 CDT
|  |  |