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

324137Apr 5 2006 — edited Apr 6 2006

Hi Everyone,

I am having difficulties formatting a number data type column in Oracle Forms 6i.

The column is defined in the database as NUMBER(9).

The user can enter the following type of numbers:

04-01-1258
06-03-12581

So, I have set the following properties in forms:

Data Type: Number
Max Length: 11
Fixed Length: No
Format Mask: FM09"-"99"-"99999

If the user enters 06-03-12581 then the entry is accepted and store in the DB as 60312581.

But if the user enters 04-01-1258, then he receives the FRM-40209: Field must be of form FM09"-"99"-"99999 error message.

Any solutions for this ?

Thank you.

Locked Post

New comments cannot be posted to this locked post.

Locked on May 4 2006

Added on Apr 5 2006

#forms, #moved-from-devops

2 comments

547 views