Re: Stop executing stored procedure

Richard Harnden wrote: > Jonathan Leffler wrote: > > On 3 Aug 2006 04:53:16 -0700, maxskalski@gmail.com wrote: > >> How can I stop executing procdure after some condition? > >> e.g. > >> > >> if nr > 0 then > >> 'here I want to stop executing and exit procedure' > >> end if > > > > This looks like it might be an error condition - maybe you should use > > RAISE instead of the EXIT and RETURN options already suggested. Error > > -745 is reserved for your use; you can generate a message text of your > > own choosing. > > ITYM -746 See what happens when your brain goes on holiday and your fingers don't! :-) Yes, I did mean -746.