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!

Plsql

Discussion in 'SQL PL/SQL' started by Subu_bala89, Nov 30, 2017.

  1. Subu_bala89

    Subu_bala89 Active Member

    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    55
    Location:
    Chennai
    Hi friends,
    I need to insert 10lakhs record using bulk collect . I got an error in say 96000th record how to solve it????? Using stored procedure and collections
    Kindly share the program if anyone knows
    Thanks in advance.
     
  2. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,608
    Likes Received:
    364
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    How could anyone know how to solve your problem when we don't know what your 'problem' is? " I got an error in say 96000th record how to solve it?????" WHAT error? What was the error text/error number? If you won't provide that information then no one can provide any useful input.
     
  3. vibhasss

    vibhasss Active Member

    Messages:
    7
    Likes Received:
    2
    Trophy Points:
    160
    Location:
    India
    Hello Bala,
    Well, I guess you faced this question in one of your interviews. In Oracle apps, you fetch records into the staging table before entering them into actual interface table. Once you get data in the staging table, you have to validate each record and if there is any record has any problem you can add details of errors in same staging table using additional 'Message' column.
     
    Subu_bala89 likes this.