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!

ep-1401 fatal pl/sql error occurred in oracle reports ORA 01830 date format

Aryan AleeFeb 11 2022

function wordsFormula return Char is
words varchar2(100);
begin
select upper(to_char(to_date(round(:sum_debit,'j'),'jsp')))||' RUPEES ONLY ' into words from dual;
if :sum_debit=:sum_credit then
return(words);
else
return(null);
end if;
end;
Acc_vocher (2).png

Comments
Post Details
Added on Feb 11 2022
1 comment
369 views