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.

Report message to a moderator

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

Report message to a moderator

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;

Report message to a moderator

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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Jun 28 21:57:35 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.