Exception handling

Can we use exception more than once in one stored procedure??

Yes Mohan

You can have more than one EXCEPTION as long as they are enclosed within BEGIN…END blocks.

Let us know how it goes for you.

Thanks,