We have a table with 70 columns and everyday we move data from thsi table to its history table which is basically same in structure. The daily table has about 4 million records that is tranferred to the history table.
To move data from this daily table to the hostory table we are using bulk collect and the implementation of bulk collect is done using record type variable.
Our problem is we when the procedure is executed it does not return back and we are getting a end of comminication end.
May 22, 2004 7:44 AM
May 26, 2004 3:34 PM