Home » SQL & PL/SQL » SQL & PL/SQL » URGENT database links
URGENT database links [message #22980] Fri, 08 November 2002 09:54 Go to next message
John Murphy
Messages: 8
Registered: November 2002
Junior Member
I am trying to access a table in another database through the link that is created. Everytime I try to reference the table in my script it throughs me errors can someone please send me the correct syntax for accessing a table and column in another db. This is what I have. I need to know where to reference the db link.

primary_fname_var service_request.primary_fname%type;

Thanks,

Report message to a moderator

Re: URGENT database links [message #22982 is a reply to message #22980] Fri, 08 November 2002 10:09 Go to previous message
Todd Barry
Messages: 4819
Registered: August 2001
Senior Member
 
primary_fname_var  service_request.primary_fname<b>@dblink</b>%type;

Report message to a moderator

Previous Topic: Re: Error trapping in an Oracle Stored Procedure
Next Topic: Indexes
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Apr 29 08:21:52 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.