Format mask for numeric data entry
525076Jul 30 2006 — edited Aug 11 2006Dear all,
Now I am on process of evaluate Oracle 10g express edition. I try to make a simple application and find how easy to build the application on 10g. I create some tables. I use application builder to build form by using ‘TABULAR FORM and use multiple row update’ and modify the format of column to let the user entry numeric data. In the form level, I change the format mask of CUR_BOOK_VAL (in Column Attributes) to 999G999G999G999G990D0000 and found that when entry 111,111.0000 it’s ok but when I put 1 at the beginning (1111,111.000) and SUBMIT the error show like this
-----------------------------------------------------------------------------------------------------------------------
Error in mru internal routine: ORA-20001: Error in MRU: row= 1, ORA-20001: ORA-20001: Found invalid number value, please verify number format., update "DOIREPORT"."IN_1210" set "NUM" = :b1, "EF_YEAR" = :b2, "DETAIL_IN_1210" = :b3, "REPORT_CODE" = :b4, "COMPANY_CODE" = :b5, "EF_MONTH" = :b6, "LINE_NO" = :b7, "CUR_BOOK_VAL" = :b8, "PREV_BOOK_VAL" = :b9, "CUR_APPRAISED_VAL" = :b10, "PREV_APPRAISED_VAL" = :b11, "REMARK" = :b12, "UNIT_PREPARE" = :b13, "RECONCILE_STATUS" = :b14, "RECONCILE_DATE" = :b15, "LAST_UPDATE_PERSON" = :b16, "LAST_UP
------------------------------------------------------------------------------------------------------------------------
but if I put “1, “ ( one with comma so = 1.,111,111.0000 ) there is no error found.
Do I put the wrong FORMAT MASK or I had to change DOUBLE PRECISION to NUMBER ?
********************************************************************************
Details to support problem
Oracle Database 10g Express Edition Release 10.2.0.1.0 - Beta
PL/SQL Release 10.2.0.1.0 - Beta
CORE 10.2.0.1.0 Beta
TNS for 32-bit Windows: Version 10.2.0.1.0 - Beta
NLSRTL Version 10.2.0.1.0 - Beta
********************************************************************************
SQL to generate table. (below is version 1 and later I added more columns by using SQLDEVELOPER.)
********************************************************************************
CREATE TABLE IN_1210
(DETAIL_IN_1210 VARCHAR(255) NOT NULL
,NUM NUMBER NOT NULL
,REPORT_CODE VARCHAR2(240) NOT NULL
,COMPANY_CODE VARCHAR(255) NOT NULL
,EF_YEAR INTEGER NOT NULL
,EF_MONTH INTEGER NOT NULL
,LINE_NO INTEGER NOT NULL
,CUR_BOOK_VAL DOUBLE PRECISION
,PREV_BOOK_VAL DOUBLE PRECISION
,CUR_APPRAISED_VAL DOUBLE PRECISION
,PREV_APPRAISED_VAL DOUBLE PRECISION DEFAULT 0
) STORAGE (INITIAL 10K NEXT 5K MINEXTENTS 1 MAXEXTENTS 20 PCTINCREASE 5)
********************************************************************************
Best Regards,
Tritep