Re: problem while execuitng query using DB Link.

On Mar 28, 6:09 am, "mahesh" <mahesh2..._at_gmail.com> wrote:
> Hi while executing this dblink query the toad is hangs so please tell
> me ia there anything wrong with this query
>
> INSERT INTO DEST_DUPLI_MESS..._at_ltsb.us.oracle.com
> (TXN_ID,COUNTRY_CODE,TXN_SOURCE,DEST_CODE,IN_TIME,DUPLI_MESSAGE_ID,MESSAGE)
> (SELECT
> TXN_ID,COUNTRY_CODE,TXN_SOURCE,DEST_CODE,IN_TIME,DUPLI_MESSAGE_ID,MESSAGE
> FROM DEST_DUPLI_MESSAGE WHERE TXN_ID IN (SELECT TXN_ID FROM TEMP))
Hello Mahesh,
A couple of questions for you:

1. What error message are you getting?
2. What is your database link defined as?
3. What version of Oracle are you running?

Regards,
Arun Received on Wed Mar 28 2007 - 08:39:41 CDT