Here's an example script:
Code: Select all
SET TERM ^^ ;
CREATE PROCEDURE P_DONOTHING2 AS
BEGIN
SUSPEND;
END ^^
SET TERM ; ^^
SET TERM ^^ ;
ALTER PROCEDURE P_DONOTHING2 AS
begin
/* code */
end ^^
SET TERM ; ^^
Setting the terminator again, or resetting it should be possible. Of course, the new terminator has to be used, just like the script above.
There seems to be a bug here.
With regards,
Martijn Tonies
Upscene Productions