3 Replies Latest reply: Dec 3, 2012 3:25 AM by Prabodh RSS

    Data Loading in APEX 4.2

    968631
      I am going to use Data Loader in my project, But the problem is:
      I have a table called Employee which has two columns (Employee_Name and Email)
      So when I try to import data to this table it adds the same record two times or more.

      Anyone can help??
        • 1. Re: Data Loading in APEX 4.2
          Prabodh
          I am going to use Data Loader in my project, But the problem is:
          I have a table called Employee which has two columns (Employee_Name and Email)
          So when I try to import data to this table it adds the same record two times or more.

          Anyone can help??>
          What is unsaid is more important in this case.
          a. Are you sure that the table does not already contain the rows?
          b. does your table have a Primary or Unique Key defined that will trap duplicate values?

          Cheers,
          • 2. Re: Data Loading in APEX 4.2
            968631
            A. I am sure that the table does not contain any thing
            B. I don't have primary key for this table
            • 3. Re: Data Loading in APEX 4.2
              Prabodh
              A. I am sure that the table does not contain any thing
              B. I don't have primary key for this table>

              i. If you do not want duplicates make sure you have a Primary Key
              ii. Run page in Debug mode. The upload could be happening twice for some reason. The Debug Report will tell you whether it is running twice or not, and why, if it is running twice.

              Cheers,