Re: Flashback query bug?
From: Phillip Jones <phil_at_phillip.im>
Date: Wed, 19 Sep 2012 20:30:13 +0100
Message-ID: <CAOyzJuePzBvNYYD1sX5v-Xd4S3H_D0DsOZnHou6o5C3tWcPw1w_at_mail.gmail.com>
Hi,
This works fine as a workaround:
Date: Wed, 19 Sep 2012 20:30:13 +0100
Message-ID: <CAOyzJuePzBvNYYD1sX5v-Xd4S3H_D0DsOZnHou6o5C3tWcPw1w_at_mail.gmail.com>
Hi,
This works fine as a workaround:
create or replace
procedure cs_p( myscn NUMBER ) IS
CURSOR cur IS
SELECT c1.c1
FROM cs_t1 AS OF SCN myscn c1, cs_t2 AS OF SCN myscn c2
WHERE c1.c1 = c2.c1;
l_row cur%rowtype;
begin
open cur;
fetch cur into l_row;
close cur;
end;
/
Thanks,
Phil
On Wed, Sep 19, 2012 at 8:17 PM, Stephens, Chris <Chris.Stephens_at_adm.com>wrote:
> 11.2.0.3 on Linux 5
> Any idea why the procedure fails when joining 2 tables?
>
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Sep 19 2012 - 14:30:13 CDT