ORA-02248: invalid option for ALTER SESSION
(Don't worry, this is the last of my scanned images)
.
This is one of the truly painful Oracle errors I've been forced to deal with in my time at UPS. It's probably comparable to the headaches accompanying FAST refresh on MVIEWS.
.
Since I haven't seen my version of the error treated satisfactorily yet, I thought I'd share my experience here. Every candidate solution I've found through Google, assumes that I've specified an invalid option in my ALTER SESSION command. None of them considered the possibility that a driver might be setting invalid options on my behalf. :P
My problem was the Oracle 10g JDBC driver I was using to access an Oracle 9i server. One would think that the drivers would be backwards compatible, but they're not. Worse still, I thought that I was out of luck, given that my application accesses data from 9i and 10g servers simultaneously.
However, all was not lost. Surprisingly enough, Oracle 9i client-side drivers are forward-compatible with 10g servers. So, the solution was to use an old JDBC driver.
No comments:
Post a Comment