today:
651
yesterday:
793
Total:
1,014,854
DECLARE
  v_test_nbr NUMBER;
  v_check_exists NUMBER;
BEGIN
  BEGIN
    v_test_nbr := to_number(:P6_TEXT_FIELD);
  EXCEPTION
  WHEN OTHERS THEN
    -- or catch 1722 (invalid number) and 6502 (char to number conversion error)
    v_test_nbr := NULL;
  END;

  IF v_test_nbr IS NOT NULL
  THEN
  -- if v_test_nbr is not null then the field should be numerically valid
  -- if it isn't then this code would be skipped and this validation
  -- will not throw an error.
  -- However, the previous validation will still fail when text is entered, 
  -- so this shouldn't matter.
    BEGIN
      SELECT 1
      INTO v_check_exists
      FROM my_table
      WHERE column_name = :P6_TEXT_FIELD;
    EXCEPTION 
    WHEN no_data_found THEN
      v_check_exists := 0;
    END;

    IF v_check_exists = 1 
    THEN
      RETURN 'A record with this key already exists';      
    END IF;
  END IF;

  RETURN NULL;
END;
No. Subject Author Date Views
106 DBMS_NETWORK_ACL_ADMIN admin 2016.06.07 361
105 ADD_PRIVILEGE (2nd STEP) admin 2016.06.07 360
104 Access Control List (ACL) admin 2016.06.07 350
103 DBMS_NETWORK_ACL_ADMIN admin 2016.06.07 348
102 function get area admin 2016.06.08 334
101 How to set a proxy in UTL_HTTP admin 2016.06.07 329
100 CREATE_ACL (1st STEP) admin 2016.06.07 320
99 ACL 보기 admin 2016.06.07 319
98 Assign a network host to Access Control List admin 2016.06.07 309
97 Oracle 11g Access Control List for External Network Services admin 2016.06.07 306
96 CAPTCHA PLUG-IN admin 2016.05.27 304
95 영수증 2023 file admin 2024.01.04 285
94 SUBSTR admin 2016.05.26 280
93 FOR LOOP admin 2016.05.20 278
» Validation to detect text in numeric field admin 2018.05.19 254
91 ROWNUM admin 2016.05.19 246
90 Change Admin PASSWORD admin 2018.07.31 244
89 Group by, Order by (두개의 Table을 활용한 Sub Total / 최고값 ) admin 2016.05.06 242
88 VERY IMPORTANT admin 2018.06.26 239
87 How-To Document / Change a Logo in a Page Template admin 2016.04.16 239