Subject | Re: stored procedure not exiting where expected |
---|---|
Author | csswa |
Post date | 2002-01-19T11:54:30Z |
--- In ib-support@y..., Helen Borrie <helebor@d...> wrote:
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
> At 05:01 PM 19-01-02 +0800, Andrew (CSSWA) wrote:names and see whether that makes a difference to your problem.
>
> First, take the quotes off procedure arguments and the variable
>...
> 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