Error during compilation - ORA 2083
Dear All,
Thank you for your help...
I performed a migration, and am trying to compile a package.
Version 11.0.2.3, runnning on RHELinux Ver5.
It fails with a ORA-02083 error...database name has illegal character '-'
The code is
BEGINSELECT sum(nooftimesadappear)
INTO lPremiumAdImpressions
FROM VW_LIVE_PREMIUMADS lpa, viewpremiumadstatistics@APGATEDW@APGATEDW pi, INVOICE i ****<Fails here
WHERE lpa.ORDERID = i.ORDERID
AND lpa.PREMIUMADID = pi.PREMIUMADID
AND lpa.PREMIUMADTYPE = rec_premiumad_type.PREMIUMADTYPE
AND lpa.DISPLAYSTATUS = 'Active'
AND TRUNC(pi.statsdate , 'MM') = TRUNC(lReportDate, 'MM');
EXCEPTION WHEN NO_DATA_FOUND THEN
lPremiumAdImpressions:=0;
END;
When I run the following, I get the error:
0