We're in a migration, and several of our text files - which were keyed on sequence number, so you may have line 0001, 0002, etc. for your text, are converted to CLOB fields. Problem is, we had code that set the text values based on the line sequence - we wanted certain text on line 1 or line 2, etc.

How can I tell where I am in a CLOB, is there any way to know which line I'm reading??

Appreciate any feedback!!