Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Referencing table in another schema via database link
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