Ales,

I have implemented ur second suggestion...but sorry to say that the problem still persists although I have increased the size of Comp_list to VARCHAR2(3000)

I don't think that the string that i need to generate like 123,234,235,235 will ever be of such a huge magnitude...

There can be at max 50 comma seperated components each of max 3 digit making it 50*3+50 chars long at most...

Can there be any other reason for the error??