Subject Re: stored procedure not exiting where expected
Author csswa
--- In ib-support@y..., Helen Borrie <helebor@d...> wrote:
> At 05:01 PM 19-01-02 +0800, Andrew (CSSWA) wrote:
>
> First, take the quotes off procedure arguments and the variable
names and see whether that makes a difference to your problem.
>
> Then, try a simpler procedure, viz.
>
> CREATE PROCEDURE "SP_LOG_CHANGES"
...

Helen, your procedure worked. Oddly, when I ALTERed back to mine,
that now works too. I can only think that altering the procedure
fixed it. If I run into this prob again, I'll try the ALTER first...

-Andrew Ferguson