- Your INFORMATION_TOTAL column seems to be getting skipped, and instead NAAM is being reused again. Can you check the attributes for the INFORMATION_TOTAL column, especially the attributes: "Display Type" under column definitions and "Column Filter Type" under list of values.
- wow, i didn't intend to have that error catching in place there, i forgot to remove it just there. My package has the right code, but i must've messed up my ctrl+c ctrl+v skills again. I put those in at first for gracefullness, but then again, a good nice crash would be a lot more valuable in my opinion :) The whole things should work without extreme crashes anyway, and a no-data-found is worthless: even with no next and previous values the select would not create an ora-1403. But ah well, these things need to be debugged either way.
- i'll be at the OGH apex day 26th of march. You can always treat me there ;p
It should probably work with a clob column, but my parse falls over the 'column filter type' attribute i believe. It might've been blank for your clob column (not able to set it perhaps?), meaning it would skip over it. I may try to reproduce this, might simply be an oversight since i use no clobs anywhere. Don't put yourself in trouble though, if your column can be > 4000 chars you might run into errors.
Anyway, glad you got it to work :)