Subject | FB: RECREATE PROCEDURE? |
---|---|
Author | Richard Saeger |
Post date | 2001-09-05T08:08:45Z |
Hi,
I find the new feature of FB RECREATE ... very usefull for developer.
But I run in an error trying this:
RECREATE PROCEDURE MyProc ( Param1 SMALLINT )
AS
BEGIN
EXIT;
END #
Statement failed, SQLCODE = -104
Dynamic SQL Error
-SQL error code = -104
-Token unknown - line 1, char 10
-PROCEDURE
The procedure MyProc allready exists, I want "ALTER PROCEDURE" in
fact. What am I doing wrong?
Thanks
Richard
I find the new feature of FB RECREATE ... very usefull for developer.
But I run in an error trying this:
RECREATE PROCEDURE MyProc ( Param1 SMALLINT )
AS
BEGIN
EXIT;
END #
Statement failed, SQLCODE = -104
Dynamic SQL Error
-SQL error code = -104
-Token unknown - line 1, char 10
-PROCEDURE
The procedure MyProc allready exists, I want "ALTER PROCEDURE" in
fact. What am I doing wrong?
Thanks
Richard