Question Remote database operation

From: <sj_at_china.pages.com.cn>
Date: Sun, 31 May 1998 04:37:35 GMT
Message-ID: <6kqmqe$58l$1_at_nnrp1.dejanews.com>



Hello their :

   I have post the question before and some friend do help me a lot .

  But I still has problem with that.

  The question is that:

  1. I create a database link from my orace server on sloaris to a Oracle server remotely on a HP UX .

     I can access the remote database by using sqlplus like this :

      sqlplus developer/developer_at_connect  , where connect is the service name
     defined in my tnsnames.ora for another  database

     But if I want to use the database link , There exist problem:

     if login local database by using
     sqlplus sj/sj133

     I can not access the remote database by using the database link I
     create for remote database . It shows ORA-12666 .

     If I login local database using sqlnet , like
     sqlplus sj/sj133_at_oracle  ( oracle is local database service name )
     I can access database link easily .

     why ?

  2. I define a trigger in local database  for a table .
     the trigger act as the following :

     when a line is inserted into the table , the trigger is activated and
    transfer the new line to remote database .

     to get the target for this trigger , I met two problem :

     the first : how to transfer the new line just inserted , because I can
     not use new and old  variant in trigger because during inserting the
table is muting .
     the second :  how to deal with the communication default in trigger ?
     that is : when  a new line is inserted into the database , if the
communication line is cut down , just a ORA  error message raised , the
     trigger did not go to the exception part , it just stoped !
      can I deal with the problem like this in the trigger ?

   I really appriciate any word about the problem .

   Also , very thanks to peoples who have give me suggestion about the problem.

   Jing Shen

   Mail to: sj_at_china.pages.com.cn

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Sun May 31 1998 - 06:37:35 CEST

Original text of this message