Subject RE: [IBO] now OT (was: Multiple UPDATE statements in one TIB_DSQL?)
Author Daniel Rail
At 07/04/2001 12:52 PM, you wrote:
> > Did you give yourself execution rights?
>I'm SYSDBA, isn't that enough? If not, how do I give myself execution

Thomas is right, you can't use a stored procedure in an update. Sorry for
my ill informed suggestion. One thing that you can try is creating a
stored procedure that contains both of your UPDATE statements.

Daniel Rail
Senior System Engineer
ACCRA Group Inc. (
ACCRA Med Software Inc. (