how to stick a number(amount format) to a session

[zulu99]

Hi

I have a change requirement from the client where
now he wants all amount figures returned from oracle
procedures through resultsets with a comma & 2 decimal
format.

my solution was to pad all amounts with to_char(amt,'99,99,99,999.00')

Is there anyway i can set the number format for a session
something on the line of how we can set a date format using
nls_date_format parameter with a logon trigger.

Regards
Sushant

[nametullah]

try this one:

Write this code in the triggers of PRE-TEXT-ITEM and POST-TEXT-ITEM
at form level.

BEGIN

-- DESC : DEFINE NUMBER FORMAT
---------------------------------------------------------------------

IF Get_item_property(:system.current_item,DATATYPE) = 'NUMBER' Then
Set_Item_Property(:system.current_item,FORMAT_MASK,'99,99,99,999.00');
END IF;

END;

May be it helps u.
Namet ullah Kalair

[zulu99]

My front end is Java. We are using servlets - JSP