oracle 6i Form & report + Oracle 9i Database + Windows 2003
I have summary Column that is TOTAL
I want to display TOTAL field in WORDS using below lines in Formula Column but showing error. ORA-06502
function CF_1Formula return Number is
word varchar2(100);
begin
select (to_char(to_date(:total,'j'), 'jsp'))into word from dual;
return (word);
end;
or please can you write here any method I want to conver number in words.
Convert Number into Words
Hi
get the function from
http://asktom.oracle.com/pls/asktom/f?p ... 7603857650
create it in the database and use this in report.
Regards
Atif
get the function from
http://asktom.oracle.com/pls/asktom/f?p ... 7603857650
create it in the database and use this in report.
Regards
Atif
Who is online
Users browsing this forum: No registered users and 1 guest