>>>>> "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

Reply via email to