Home » Developer & Programmer » Reports & Discoverer » Number Conver into Words
Number Conver into Words [message #326583] Thu, 12 June 2008 01:06 Go to next message
kamran.it
Messages: 265
Registered: September 2005
Location: Karachi
Senior Member
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.

Re: Number Conver into Words [message #326619 is a reply to message #326583] Thu, 12 June 2008 02:16 Go to previous messageGo to next message
wency
Messages: 450
Registered: April 2006
Location: Philippines
Senior Member

I guess that must be return varchar2
Re: Number Conver into Words [message #326648 is a reply to message #326583] Thu, 12 June 2008 02:56 Go to previous messageGo to next message
dillango
Messages: 145
Registered: January 2008
Senior Member
Try below this

declare
word varchar2(200);
begin
word := (to_char(to_date(:total,'j'), 'jsp'));
end;
Re: Number Conver into Words [message #326915 is a reply to message #326648] Fri, 13 June 2008 01:25 Go to previous message
kamran.it
Messages: 265
Registered: September 2005
Location: Karachi
Senior Member
my mistake

wency is right
Previous Topic: Creating Supplier Payment EFT
Next Topic: ordering by financial year
Goto Forum:
  


Current Time: Fri Dec 09 21:10:37 CST 2016

Total time taken to generate the page: 0.05720 seconds