Tom Lane wrote: > Yury Bokhoncovich <[EMAIL PROTECTED]> 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 [EMAIL PROTECTED] ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster