Same query but differnt results:
I have the following script:
SELECT
ceil(sum(TO_NUMBER(p.NUM_OF_BEDSPACES))/3) HDE
FROM
BULL.RNT_PROPERTY_CHARGE_ITEM rpci,
BULL.PROP_STATUS_HIST prosh,
BULL.REP_PROPERTY rp,
BULL.PROPERTY p
WHERE (rpci.CHARGE_ITEM_CODE='HREN'
AND rpci.EFFECT_DATE<='&&AS_AT'...
RJSHA1, this is not always the case. I have over 100 reports using stored procedure which have valid generated .rep files. Unfortunately this seems to be a random bug (I have just had my second occurance)
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.