Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.ision.net!newsfeed2.easynews.net!ision!kanaga.switch.ch!switch.ch!ecngs!feeder2.ecngs.de!npeer.de.kpn-eurorings.net!newsfeed.arcor.de!news.arcor.de!not-for-mail
From: Dietmar Brueckmann <dietmar.brueckmann@lycos.de>
Subject: how to obtain the value of current_schema
Newsgroups: comp.databases.oracle.server
User-Agent: 40tude_Dialog/2.0.15.1de
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Date: Fri, 5 May 2006 08:12:17 +0200
Message-ID: <1hmw2qpgjqzpk.1uwy5npbhhdnh.dlg@40tude.net>
Lines: 14
Organization: Arcor
NNTP-Posting-Date: 05 May 2006 08:12:17 MEST
NNTP-Posting-Host: 3b548b49.newsread4.arcor-online.net
X-Trace: DXC=Q9iV]>A7VECo47S\@TX3oE:ejgIfPPldDjW\KbG]kaMH]kI_X=5KeaF><ZDbCUOWUJXe]MjWdX=IJG1oPS@ic9aA7U8n?JMPi3I
X-Complaints-To: usenet-abuse@arcor.de
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:266934

Hello,

in an application I use 
"alter session set current_schema = A_SCHEMA"
to set the Schema where all data are located for avoiding excessive use of
synonyms for user schema.

Because of a problem with that, I'd like to see the current setting of
CURRENT_SCHEMA, but I don't how to obtain it.
Thanks in advance!

-- 
Best regards
Dietmar Brueckmann