"BH" <info_at_siliconmindset.com> wrote in message
news:odh1b.7274$sV.6247_at_newsread1.news.atl.earthlink.net...
> The reason is simple. The DB specific layer should easily work with
multiple
> versions of Oracle. But as any half way decent Developer knows. You need
to
> certify your product on specific versions. IE Tested 100% with XXX or
YYY.
> Now as most of us know a clip of PL/SQL will work with any version.....but
> you need to categorically state it has been tested and certified by the
> manufacturer to work with a specific version... I mean come on if you are
> supporting a trading application or Banking application you are not
arrogant
> and say..hay my stuff works with any version...unless of course you are so
> confident in your work that you go over the line of confident to blind
> arrogance. When I say something works with version XXX even thought the
> code uses no specific PL/SQL of any specific version I will test it, then
> test it again then have someone else test it.
>
> Somehow I thought my question was really just plain old simple - what is
the
> more prevalent version out their. Now I understand the need offer advice
on
> design - but that I do not need - yet - maybe later - just looking for a
> simple answer like '9.2'
>
Well if you are going to say 'I warrant this code against version x' then
you should be aware that as of 31.12.2003 then the only version x that
Oracle will fix bugs against is 9.0.1 or higher. If you can say 'The code
has been tested and found to work against version x, if we can reproduce a
problem we will fix it' then I guess you can choose any vaue of x you wish.
If you can envisage a situation where you meet a new bug that needs Oracle
corp to fix it then you might wish to consider the desupport timetable. You
can of course word licenses any way you wish so that becomes a legal and
business decision.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
Received on Fri Aug 22 2003 - 15:04:54 CDT
