Re: Store Procedure
chew yuit min wrote:
>
> I am trying to create a Store Procedure in my database but I keep on getting
> error messages -673 and 853. Even with a very simple store procedure as below,
> I still get the error messages.
>
> CREATE PROCEDURE aaa()
> SET LOCK MODE TO WAIT;> END PROCEDURE
>
> Please Help
>
> Regards,
> Yuitmin
Yuitmin,
Error -673 means a procedure with that name already exists. -853
just says the current transaction has been rolled back - this will
be because of the previous error. It looks like the create
procedure statement worked the first time - try it again,
replacing "aaa" with "bbb". You can also check the SP's present
in your database using the Database Info menu on dbaccess.
HTH,
Richard.