Mike Mascari wrote: > 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...
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 [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
