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

Home -> Community -> Usenet -> c.d.o.server -> Referencing table in another schema via database link

Referencing table in another schema via database link

From: Chris R <Chris.Redmond_at_gmail.com>
Date: 1 Feb 2006 07:38:59 -0800
Message-ID: <1138808339.484669.252060@f14g2000cwb.googlegroups.com>


This is my first experience with database links. I am writing a PL/SQL function that defines a type as

TYPE approvals IS TABLE OF test_results_at_xyx.approved%TYPE;

where test_results is the table, @xyz is the link, and approved is the column. I am getting an error that the database link does not exist. Is this possible or is the syntax I am using incorrect. I am using Oracle 9.2.0.6.

Thanks Received on Wed Feb 01 2006 - 09:38:59 CST

Original text of this message

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