Exiting PL/SQL procedures

[fatcodeguy]

Hi. I have a procedure that searches large table records for certain data, and parses it in HTML. Now only so many characters (32767) can be used for this certain data. If, while executing, the process notices that there won't be enough space in the 32767 varchar2 buffer, I want it to display an error message, and stop the procedure? How would I do this ?? Is there an exit command for loops as well?? Thanks

 

[sem]

You may raise an exception or use EXIT operator (to exit from loop).

Regards, Dima