1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

How to add validation for uploaded column of data load functionality

Discussion in 'Oracle Application Express (APEX)' started by sree31, Sep 24, 2016.

  1. sree31

    sree31 Starter

    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    10
    Location:
    INDIA
    Hi,

    The first column of my uploaded file is Country. And I need to validate its value from a given list like ('AA','AB','BC','DE','RG') . So added validation in Page Processing --> validations of Data/Table Mapping something as follows..
    Type: Exists
    Validation expression1: c001 in ('AA','AB','BC','DE','RG')

    but I am ending up with error like ORA-01403:no data found....

    I also tried to create Transformation Rule in Data Definition, but all valid country records are also getting failed because of that rule.

    Not sure how to crack this issue but I am highly in need of solution to proceed the development.

    Please suggest me the best solution to crack same at earliest.
     
  2. sree31

    sree31 Starter

    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    10
    Location:
    INDIA
    Any replies on above?