how to read clob and iterate through all lines
879687Sep 14 2011 — edited Sep 15 2011I am attempting to read a table that has clob field. I want to iterate through all rows that are contained in the data of clob. Is it possible to do this?
For example I have some thing like this in my data:
OH, JK, -JKManualTra-Lem_dropping90
TX, KJ, -KJAutoTra-Mel-popping89
The clob could be large itself so I want to be able to extract line by line and I can't figure out how to iterate easily. Anyone can assist please?