Compilerdirektiven for backward compatibility

From: Nicolas Bronke <Nicolas_Bronke_at_web.de>
Date: Sat, 27 Jan 2007 12:39:08 +0100
Message-ID: <520rutF1lspsuU1@mid.individual.net>

I search for a solution with backward compatbility. That means, I have to enhance a procedure in a package. My changes works fine with Oracle 9i and 10g but not with 8.1.7

Here an example

  update TABLENAME B
    set

       LIMIT=(select LIMIT from TABLENAME A
           where A.NGNR=B.NGNR AND A.NPNR=B.NPNR AND 
A.DTSTICHTAG=DTLASTRPTDATE AND
                 A.ORT=B.ORT AND A.LAND=B.LAND AND A.ISO=B.ISO)

    where B.DTSTICHTAG=DTRPTDATE AND B.NID=0 AND NGNR=NRPTGNR;

in SQLPLUS it works also on 8.1.7

Now in this case it would be possible to create a seperate package where this syntax is not used. Possible but not nice. Better would be to have a compiler directive so that this code is only used if this variable is setted (like in delphi). I have other examples where it is not so easy (e.g. email sending). Of cause 8.1.7 is old and not supported anymore, otherwise some customers are still using this release and are satisfied. Of cause they will upgrade but when? Until this I have only the possibility: maintaining two releases of the required packages or does exist another way?

Kind regards
Nicolas Received on Sat Jan 27 2007 - 05:39:08 CST