Re: Getting sysdate across a DB link

Galen Boyer <galenboyer_at_hotpop.com> writes:

> On 28 Feb 2003, paul.moore_at_atosorigin.com wrote:
>
>> As a simplified version of my problem, suppose I want to calculate the
>> clock difference between the local and remote machines. The "obvious"
>> approach is
>>
>> select l.sysdate - r.sysdate from dual l, dual_at_remote_db r;
>>
>> This doesn't work - it gives me an error "ORA-01747: invalid
>> user.table.column, table.column, or column specification" (presumably
>> because SYSDATE is a date function, not a column).
>
> Does your database link allow you access to any other objects, ie, are
> you sure that retrieving remote sysdate is the issue?

Yes, other objects are fine.

Paul.

-- 
This signature intentionally left blank