I have to pass deleted and new customers in comma separated values to my SP from front end and then I need to look up my records and mark them as deleted. I tried passing the values to SP in Clob or sys,xmltype however when I get these in SP i am not able to consume them since i cannot store them in varcha (length limit) for split. Please suggest a better way for this.
It doesn't seem this is a ".NET Stored Procedures" question, so you may be better off posting to one of the database forums as it seems it's simply a design question.
However, you should be able to use DBMS_LOB which contains both INSTR and SUBSTR functions to split up the clob, but you'd need to write it yourself. There are also some examples you can get by googling dbms_lob split .
Hope it helps
Greg Edited by: gdarling on May 24, 2012 10:39 AM
You could also pass an associative array (plsql index-by table) depending upon the interface you're connecting to the database with.