Re: help: How to refrence a column over the database link

charlie cs wrote:

> Hi, group, in PL/SQL, if i want to refrence a column over the database link,
> something like this
>
> Declare
> ......
> v_1 tableA.columnA%type_at_db_link;
> .....
> Begin
> ....
> end;
>
> but it is not working. Could somebody tell me how to do it?
>
> Thanks for your help.

I', with IANAL_VISTA in terms of your assumption that we are all able to look over your shoulder but I think I have an idea what the problem is.

Either:
(1) you can't do that
or
(2) you don't have the necessary privilege

I'd be interested in knowing which it is.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)