Re: Stuck on old system can you feel my pain

From: Joe <nospam_at_joekaz.net>
Date: 3 Feb 2004 05:34:27 -0800
Message-ID: <b9c56449.0402030534.3ceee042@posting.google.com>

"Ranting this one time" <rantaboutasystem_at_rantingonetimesorry.com> wrote in message news:<5LqdnZ3cl_lIcYPdRVn-jw_at_comcast.com>...
> ...
> Has anyone been associated with an entity that for some reason was stuck on
> an old version of Oracle in some (or all) parts of their business.

Yes! I work in an environment with a large number of Oracle applications, both in house and 3rd party. For various reasons, there are always some apps stuck at old and unsupported Oracle versions. Like it or not, it's a fact of life here.

>...

> Comrades, any experience like this, tips for connecting to old servers (post
> in server newsgroup for this reason) or tips in dealing w/the vendor?

I've had to use that trick of connecting from v9 to v7 by hopping through a v8 database. The only real problem I recall is that I could have a perfectly valid SQL statement using that v9-v8-v7 link, which worked when run from sqlplus. But when put in a stored procedure, it bombed with "ORA-01775: looping chain of synonyms". This error didn't make sense in the context I was using it. Eventually, I got the same sql to work by wrapping it in an EXECUTE IMMEDIATE. Other than that, no real problems.

-- 
Joe
http://www.cafeshops.com/joekaz
http://www.joekaz.net

Received on Tue Feb 03 2004 - 07:34:27 CST