Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Plz see this error very urgent

556433Jan 16 2007 — edited Jan 17 2007
REP-1401: 'p_cad_sys_dtformula': Fatal PL/SQL error occurred.
ORA-01403: no data found

I wrote these lines in formula there is no complied error but when I run the report shows above error.

Please help why?

function P_CAD_SYS_DTFormula return Number is

CAD_RATE NUMBER;
CT NUMBER;

begin

SELECT COUNT(*) INTO CT FROM gl_daily_rates_V
WHERE TO_CHAR(CONVERSION_DATE,'DD/MM/RR')=TO_CHAR(SYSDATE,'DD/MM/RR')
AND USER_CONVERSION_TYPE='Corporate';

IF CT =1 THEN
SELECT SHOW_CONVERSION_RATE INTO CAD_RATE
FROM gl_daily_rates_V
WHERE TO_CHAR(CONVERSION_DATE,'DD/MM/RR')=TO_CHAR(SYSDATE,'DD/MM/RR')
AND USER_CONVERSION_TYPE='Corporate';
ELSE
SELECT SHOW_CONVERSION_RATE INTO CAD_RATE
FROM gl_daily_rates_V
WHERE TO_CHAR(CONVERSION_DATE,'DD/MM/RR')=TO_CHAR(SYSDATE,'DD/MM/RR')
AND USER_CONVERSION_TYPE='Corporate'
AND FROM_CURRENCY='CAD' AND TO_CURRENCY='USD';
END IF;


RETURN(CAD_RATE);

end;
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 14 2007
Added on Jan 16 2007
3 comments
370 views