Author
Topic: Logic to rebuild a string having n no of '&' and inserting into a table. (Read 7463 times)

Gurus,Need your help ...I need to rebuild a string value programmatically which has '&' and insert the same into another table.Now the string may contain n no of '&' occurrances.Hence,can you suggest/modify the existing codeso that it can be used in a general way.Assume creating arrays permission is not granted to the schema.

Actually, this info is being passed to one procedure which willinsert the reqd details into one table.Hence,procedure abc (p_input_id number,p_input_string varchar2) will be 2 input parameters.The only point where i'm getting stuck is the way to handle multiple '&' in a particular string.

Logic :Find the total no of '&' occurrances.Find the sub-strings coming in between '&' and concat them withchr(38) which will give a '&'.