Re: Flashback query bug?
- From: Phillip Jones <phil@xxxxxxxxxx>
- To: Chris.Stephens@xxxxxxx
- Date: Wed, 19 Sep 2012 20:30:13 +0100
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@xxxxxxx>wrote:
> 11.2.0.3 on Linux 5
> Any idea why the procedure fails when joining 2 tables?
>
>
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
