Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!postnews.google.com!c74g2000cwc.googlegroups.com!not-for-mail
From: erik.ykema@gmail.com
Newsgroups: comp.databases.oracle.server
Subject: Re: A transactionally consistent view on real-time data with MicroStrategy
Date: 6 Jun 2006 02:50:34 -0700
Organization: http://groups.google.com
Lines: 18
Message-ID: <1149587434.226684.138360@c74g2000cwc.googlegroups.com>
References: <1149284215.556809.269580@i40g2000cwc.googlegroups.com>
   <9oSdnUJSZrI78BnZRVnytg@bt.com>
   <1149534024.767457.122780@f6g2000cwb.googlegroups.com>
   <n96dnUcB3pBQARnZnZ2dnUVZ8s6dnZ2d@bt.com>
NNTP-Posting-Host: 83.83.144.142
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1149587439 22682 127.0.0.1 (6 Jun 2006 09:50:39 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Tue, 6 Jun 2006 09:50:39 +0000 (UTC)
In-Reply-To: <n96dnUcB3pBQARnZnZ2dnUVZ8s6dnZ2d@bt.com>
User-Agent: G2/0.2
X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.8.0.4) Gecko/20060508 Firefox/1.5.0.4,gzip(gfe),gzip(gfe)
Complaints-To: groups-abuse@google.com
Injection-Info: c74g2000cwc.googlegroups.com; posting-host=83.83.144.142;
   posting-account=Gtpj3g0AAACCBG8vgokWEFibeEgaD-Jl
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:268599

Jonathan Lewis schreef:
> I'm not sure that you want to use the function/variable
> like this.  It means that you have to end each Microstrategy
> session after each report, otherwise every report for a
> session will run from the same SCN - i.e. the first one
> you set.

I will of course call p_scn.set_scn in every report in a pre-sql
statement, thanks.

As an example, I found just by accident that Informix has extended the
ANSI SQL, and indeed has a serializable mode that is _session
effective_ and not for the transaction only (set isolation to
repeatable read). I would still prefer session serialization if it were
available.
Regards,
Erik Ykema