| Subject | RE: [IBO] now OT (was: Multiple UPDATE statements in one TIB_DSQL?) |
|---|---|
| Author | Daniel Rail |
| Post date | 2001-07-04T16:21:33Z |
At 07/04/2001 12:52 PM, you wrote:
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. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)
> > Did you give yourself execution rights?Thomas is right, you can't use a stored procedure in an update. Sorry for
>
>I'm SYSDBA, isn't that enough? If not, how do I give myself execution
>rights?
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. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)