Re: (Fwd) Re: Any Oracle 9 users? A test please...

Mike Mascari wrote:
> Tom Lane wrote:
> > Yury Bokhoncovich <byg(at)center-f1(dot)ru> writes:
> >
> >>As reported by my friend:
> >>Oracle 8.1.7 (ver.9 behaves the same way):
> >>[ to_char(sysdate) advances in a transaction ]
> >
> >
> > Now I'm really confused; this directly contradicts the report of Oracle
> > 8's behavior that we had earlier from Roland Roberts. Can someone
> > explain why the different results?
>
> Roland used an anonymous PL/SQL procedure:
>
> SQL> begin
> 2 insert into rbr_foo select sysdate from dual;
> [...wait about 10 seconds...]
> 3 insert into rbr_foo select sysdate from dual;
> 4 end;
> 5 /
>
> PL/SQL procedure successfully completed.
>
> SQL> select * from rbr_foo;
>
> Oracle isn't processing those statements interactively. SQL*Plus
> is waiting on the "/" to send the PL/SQL block to the database.
> I suspect its not going to take Oracle more than a second to
> insert a row...

Oh, I understand now. He delayed when entering the function body, but
that has no effect when he sends it. Can someone add an explicit sleep
in the function body and try that?

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073