Re: Referencing table in another schema via database link

On 1 Feb 2006 07:38:59 -0800, "Chris R" <Chris.Redmond_at_gmail.com> wrote:

>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

The syntax is incorrect. You cannot refer to remote stored pl/sql.

--
Sybrand Bakker, Senior Oracle DBA