Procedure exception question

[ajhull]

I have written a function which outputs a CLOB. I now want to add an exception section so that the CLOB output will be "More than one note" if the error is too_many_rows. The output populates a field in a report. If there is more than one row I need the field in the report to inform the user of this. How do I write an exception for this? I am assuming that I will need something like dbms_lob.write(....,'More than one note').

Any help is greatly appreciated.

Thanks in advance.

Adrian