Re: Any reasons why not to upgrade to 9i

"Vasily Ptitsyn 2147483647" <vpp_at_baker.spb.ru> wrote in message news:bemckn$1ich$1_at_news.peterlink.ru...
> 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.
>
>

Odd, that *should* work, shouldn't it?
Thanks,

Herman Received on Sun Jul 13 2003 - 03:26:13 CDT