Ron,
I had two issues with SQL and PL/SQL during the upgrade:
1. GROUP BY no longer does and implicit ORDER BY. You must add an ORDER BY
clause to all SQL's with group by's that require an order. This is a
"documented change" :).
2. PL/SQL. The compiler has been amended to pick up a few more errors that
it previously let by. Out of 500+ packages, I had two that failed to compile
under 10G. One I revised to correct the error conditions. The other I
rewrote completely as it was total pants as written by the "developer" and
it was faster to do that than try to fix it :).
If you are using JDBC for applications, you may need to fiddle about with it
to get the correct versions on the client and server else it works
erratically. Some relinking was required for 10G drivers/libraries, but that
was pretty much all.
HTH
John.
-----Original Message-----
From: ron [mailto:oracledba-ezmlmshield-x65794550.[Email address protected]
Sent: 05 March 2007 19:38
To: LazyDBA Discussion
Subject: Upgrade experiences from 9i to 10gR2
We have one guy who is saying he had to change SQL and PL/SQL to get 10g
working. I don't believe him.
Can anyone relate experiences with apps? How difficult was it to get
applications working with 10gR2? Any compatibilty issues?
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
-----------------------------------------
Information in this email including any attachments may be
privileged, confidential and is intended exclusively for the
addressee. The views expressed may not be official policy, but the
personal views of the originator. If you have received it in error,
please notify the sender by return e-mail and delete it from your
system. You should not reproduce, distribute, store, retransmit,
use or disclose its contents to anyone.
Please note we reserve the right to monitor all e-mail
communication through our internal and external networks.
SKY and the SKY marks are trade marks of British Sky Broadcasting
Group plc and are used under licence. British Sky Broadcasting
Limited (Registration No. 2906991), Sky Interactive Limited
(Registration No. 3554332), Sky-In-Home Service Limited
(Registration No. 2067075) and Sky Subscribers Services Limited
(Registration No. 2340150) are direct or indirect subsidiaries of
British Sky Broadcasting Group plc (Registration No. 2247735). All
of the companies mentioned in this paragraph are incorporated in
England and Wales and share the same registered office at Grant
Way, Isleworth, Middlesex TW7 5QD.
Oracle LazyDBA home page