ORA3113 with DB Links & PL/SQL block

I face a strange problem.
I installed two Oracle734 on two NCR Unix boxes. They are connected with a db link.

In sql*plus, when I execute a single SQL select statement on DB#1 to select
data from DB#2 through db link, no problem. However, when I execute a PL/SQL block to do the same thing, it will disconnect my session (ORA 3113).

I also have two Oracle716 on that two NCR Unix boxes. Both the single SQL select statement and the PL/SQL block run on 716 successfully.

Is there any mistakes on the 734 I overseen?

Thank for any advice,
River
wychan_at_vol.net Received on Tue Aug 03 1999 - 08:26:47 CDT