Re: Getting sysdate across a DB link

DA Morgan <damorgan_at_exesolutions.com> writes:

> Paul Moore wrote:
>
>> I'm trying to get the value of SYSDATE on a remote server.

[...]
>
> I'd write a function on that machine to return it.

I'd rather not have to do this. This is for a maintenance function across 100+ target databases, and I'd rather not have to install a custom function across all of the databases.

If that's the only way, then fair enough. But I'll probably just do the query in a client using 2 separate connections if that's the case, and not bother with DB links at all...

Thanks for the suggestion,
Paul.

-- 
This signature intentionally left blank