today:
133
yesterday:
311
Total:
1,018,372
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
39 JK admin 2019.02.05 717
38 IMP admin 2018.10.08 745
37 Change Admin PASSWORD admin 2018.07.31 251
36 eeeeee admin 2018.06.21 242
35 If you want to use EXISTS in a PL/SQL function returning BOOLEAN admin 2018.05.19 244
34 use a validation function for an element in apex 5.0 admin 2018.05.19 226
» Validation to detect text in numeric field admin 2018.05.19 263
32 All Data DELETE from Table admin 2018.05.10 231
31 Process admin 2018.05.05 239
30 Oracle APEX 5.1.4 Installation admin 2018.04.17 154
29 APEX Password Change admin 2016.08.26 469
28 control break admin 2016.06.25 411
27 Membership Management admin 2016.06.09 454
26 function get area admin 2016.06.08 345
25 How to set a proxy in UTL_HTTP admin 2016.06.07 341
24 APEX Web Services Proxy Settings admin 2016.06.07 380
23 DBMS_NETWORK_ACL_ADMIN admin 2016.06.07 372
22 DBMS_NETWORK_ACL_ADMIN admin 2016.06.07 357
21 Assign a network host to Access Control List admin 2016.06.07 321
20 ADD_PRIVILEGE (2nd STEP) admin 2016.06.07 373