Re: Any reasons why not to upgrade to 9i

Look, this code works with oracle 8.1.7.4 on Linux, but doesn't on 9.2.0.2.

Problem with <<SELECT CTTNM.Id_Vd

                               FROM CTTNM
                              WHERE CTTNM.Id_CTtnM = V.Id_CTtnM >>

Are you sure your code will work ?

SELECT V.Num_Marsh,

             V.Id_CTtnM,
             V.Num_Pp,
             V.M_QuanOtg,
             V.Dist,
             (SELECT
UATTN.Date_Fact-f_Dist_ExpAdr(TTN.Id_Exped,TTN.Id_Adr)/GEN_PLAN.Velocity/24
              FROM UATTN,TTN,GEN_PLAN
              WHERE UATTN.Id_User = f_UID()
                AND UATTN.Num_Marsh = V.Num_Marsh
                AND UATTN.Num_Pp = 1
                AND UATTN.Id_Ttn = TTN.Id_Ttn
                AND GEN_PLAN.Id_Gen_Plan = f_Gen_Plan()) as Date_Plan,
             NVL((SELECT CTTNM.Id_Vd
                  FROM CTTNM
                  WHERE CTTNM.Id_CTtnM = V.Id_CTtnM),
                 (SELECT TTN.Id_Vd
                  FROM UATTN,TTN
                  WHERE UATTN.Id_User = f_UID()
                    AND UATTN.Num_Marsh = V.Num_Marsh
                    AND UATTN.Num_Pp = 1
                    AND UATTN.Id_Ttn = TTN.Id_Ttn)) as Id_Vd
      FROM (SELECT UATTN.Num_Marsh,
                   MAX(UATTN.Id_CTtnM) as Id_CTtnM,
                   MAX(UATTN.Num_Pp) as Num_Pp,
                   SUM(UATTN.M_QuanOtg) as M_QuanOtg,
                   SUM(UATTN.Dist) as Dist
            FROM UATTN
            WHERE UATTN.Id_User = f_UID()
              AND UATTN.Num_Marsh > 0
              GROUP BY UATTN.Num_Marsh) V

--

Yours sincerely, Vasily Ptitsyn.