Re: Sysdate from remote database

From: Keith Jamieson <jamiesonk_at_phoenix.ie>
Date: Fri, 7 Apr 2000 13:48:06 +0100
Message-ID: <8cklih$pmf$1@kermit.esat.net>

This problem also applies to sequences on remote databases. I don't particularly like the solution with the views as l like to keep everything generic. I would set the variable containing the dblink to a null string if it was not required, otherwise it would be ste to the dblink.

If anyon ehas an example of the call using the dbms_sql package I would be very interested in looking at it.

Marek JóŸwik wrote in message ...
>Hi!
>
>I have small problem. I'd like to call sysdate from
>remote database. I have two databases (DB1 and DB2) and
>database link from DB2 to DB1. Assume that time in DB1 is
>10:45 and time in DB2 is 10:50. I connect to database DB2
>and query:
>select to_char(sysdate, 'HH24:MI') from dual;
>It returns 10:50.
>select to_char(sysdate, 'HH24:MI') from dual_at_db1;
>It returns 10:50 too.
>
>Calling "select to_char(sysdate_at_db1, 'HH24:MI')
>from dual" doesn't work.
>
>
Received on Fri Apr 07 2000 - 07:48:06 CDT