Skip to Main Content

Oracle Forms

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!

Format mask problem at Item Level . Intabular Form.

590026Sep 7 2007 — edited Sep 14 2007
DECLARE
v_len varchar2(25):=:uin;
v_len1 varchar2(25);
it_id Item;
BEGIN
it_id := Find_Item('uin');
v_len1:=length(v_len);
if v_len1 = 13 then
set_item_property(it_id,Format_Mask,'FM99999"-"9999999"-"9');
else
set_item_property(it_id,Format_Mask,'FM999"-"99"-"999999');
end if;
END;
-----------------------------
this code is used on when_validate_item now problem is that when i give 13 digit code output is 12345-1234567-1 thats fine ..
and if code is 11 digit then output is 123-12-123456 but at same time field having 13 digit code converts to like ##########.How to handle two format masks on one item.
My form is tabular.
Using Forms 6i.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 12 2007
Added on Sep 7 2007
13 comments
963 views