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!

bulkbinding

Discussion in 'SQL PL/SQL' started by bnramesh8, Jun 12, 2014.

  1. bnramesh8

    bnramesh8 Active Member

    Messages:
    24
    Likes Received:
    0
    Trophy Points:
    80
    how can i collect the records that are missing during the bulk binding/bulk collect process?
     
  2. rajenb

    rajenb Forum Expert

    Messages:
    361
    Likes Received:
    114
    Trophy Points:
    655
    Location:
    Mauritius
    Hi,

    Can you explain what do you mean by "missing" records ?

    The "SELECT" or "FETCH" statement will only bring the records as per the "WHERE" condition you have written in your "SELECT" statement or CURSOR declaration.

    See a simple example on this link if it helps: http://psoug.org/reference/array_processing.html
     
  3. bnramesh8

    bnramesh8 Active Member

    Messages:
    24
    Likes Received:
    0
    Trophy Points:
    80
    I want to bind 10000 records.In the process of bulk binding some of the records are not getting.so how can i found those records.
     
  4. rajenb

    rajenb Forum Expert

    Messages:
    361
    Likes Received:
    114
    Trophy Points:
    655
    Location:
    Mauritius
    How did you find out that "some of the records are not getting" ?
    Is your SELECT bringing 10000 records (or more) ?
    I suppose you did a SELECT count(*) ... with the same WHERE clause to check.
     
  5. bnramesh8

    bnramesh8 Active Member

    Messages:
    24
    Likes Received:
    0
    Trophy Points:
    80
    Hi,
    After binding am using count(*) but the records are showing less than the 10000.how can i get those records is there any exception to save those records.
     
  6. jagadekara

    jagadekara Forum Guru

    Messages:
    1,126
    Likes Received:
    145
    Trophy Points:
    1,805
    Location:
    Pulivendula
    Hi,

    It's better to show your code here, It will help to give solution fast