[Tora-develop] OT - anyone here use DBD::Oracle?

[Neulinger, N. <nn...@ms...>]

I've been having a really screwed up problem where the db connection
_randomly_ doesn't accept a "alter sesssion set
NLS_DATE_FORMAT='YYYY-MM-DD HH24:MI:SS'" query. Or rather, to be more
precise, the query works just fine, and v$nls_parameters reflects the
change, but the session still gets dates in the old format.

The really irritating problem is - it's RANDOM. Out of a nightly run of
approximately 300 executions of a given script (synchronizing tables,
queries are close to the same, but programatically generated) I'll get
maybe 25-30 failures, and it winds up looking like:

Works for A
Works for A
Fail for A
Fail for A
Fail for A
Works for A

And these are distinct executions of the script, so there should be no
issue with saved state/memory/etc.

Anyone seen anything like this?

-- Nathan

------------------------------------------------------------
Nathan Neulinger                       nn...@ms...
Missouri S&T Information Technology    (573) 341-6679
System Administrator - Principal       KD0DMH