>>>>> "Mike" == Mike Mascari <[EMAIL PROTECTED]> writes:
Mike> 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? Mike> Roland used an anonymous PL/SQL procedure: You're right and I didn't think enough about what was happening. This also explains why I so often see the same timestamp throughout a transaction---the transaction is all taking place inside a PL/SQL procedure. roland -- PGP Key ID: 66 BC 3B CD Roland B. Roberts, PhD RL Enterprises [EMAIL PROTECTED] 76-15 113th Street, Apt 3B [EMAIL PROTECTED] Forest Hills, NY 11375 ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly