Re: Getting sysdate across a DB link

"Telemachus" <telemachus_at_ulysseswillreturn.net> writes:

> it works with full views - but my clocks are synchronized so your mileage
> may vary.
> SQL> CREATE VIEW MOO AS SELECT 1 AS SILLY_HEADER,SYSDATE AS MOOTIME FROM
> DUAL;
>
> View created.

Did you need to create that view on the remote server? If so, having a view on the remote server is just as much (or as little, depending on how you look at it...) of a problem as defining a function on the remote server.

Thanks for the suggestion,
Paul.

-- 
This signature intentionally left blank