Tom Lane wrote:
> Yury Bokhoncovich <byg@center-f1.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...
Mike Mascari
mascarm@mascari.com