Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> database link problem

database link problem

From: marina <marina_at_cronos.be>
Date: 31 May 2001 15:10:29 GMT
Message-ID: <3b165ee5$0$3123$456d72a3@news.skynet.be>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US