Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Sql problems.
Hi!
The following sql script worked fine on Oracle Server 7.3.2 on a digital Unix
update repport set
Use =
(select nvl(round(sum(fp.beloeb),0),0)*(-1) from ose.bundt bu, ose.fpost
fp
where fp.rgkod = '0001'
and fp.kntid = repport.actid and fp.bidat >= 19970101 and fp.bidat <= 19971231 and bu.nedtid = 0 and bu.rgkod = '0001' and bu.bdtnr = fp.bdtnr)
Now we have opgraded to Oracle Server 7.3.3, and it doesn't work
anymore. It doesn't return any errors, but it just runs forever(I think,
I stopped it after 5 minuts, before the upgrade it fineshed after about
30 sec.).
Please help me.
-- Casper Thrane System developer Benau A/SReceived on Tue Dec 09 1997 - 00:00:00 CST