Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Alter Session set via link

Alter Session set via link

From: Jacuo <zoch_at_poczta.onet.pl>
Date: Thu, 23 Aug 2001 23:00:20 +0200
Message-ID: <9m3qug$c4u$1@news.tpi.pl> 





How can I make Alter session set on remote session when connecting via link
?


I have 2 databases INTERNAL and EXTERNAL connected by database link DB



EXTERNAL base uses cached_cursor=FORCE


and when I try to make some complex queries with subqueries from INTERNAL I
get error.


So I want to make Alter session set cached_cursor=EXECT



Thanks.



--
Jacek


Received on Thu Aug 23 2001 - 16:00:20 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US