I need to do some processing on each <id> tag. My first thought was to place them in a temporary table and then use a cursor to read each one and do the neccessary processing.
However there may be a way to traverse the XML in a cursor like scenario so i do not need the temporary table and you are welcome to suggest a solution.
How would extract each <id> tag and place it in a temporary table?
I am thinking:
Traverse the xml, extract <id> tag, and create a temp tableCreate cursor to traverse tableWhile cursor returns data DObegin Process the current <id>.end ;