Discussion in 'SQL PL/SQL' started by bnramesh8, Jun 12, 2014.
how can i collect the records that are missing during the bulk binding/bulk collect process?
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
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.
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.
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.
It's better to show your code here, It will help to give solution fast