Change to
CREATE EXCEPTION MY_EXCEPTION 'My exception';

set TERM ^;
CREATE PROCEDURE DOSOMETHING(a INTEGER,b INTEGER,

...procedure code

END ^
SET TERM ; ^
note space^ added

mick

The procedure scripts are essentially structured as below.

set TERM ^;

CREATE EXCEPTION MY_EXCEPTION
'My exception' ^

CREATE PROCEDURE DOSOMETHING(a INTEGER,b INTEGER,

...procedure code

END ^
SET TERM ;^