Subject | Re: problem with very simple Stored Procedure |
---|---|
Author | duilio_fos |
Post date | 2002-08-26T21:56:10Z |
> It's ridiculousYou tell me.
I was going to post my problem when I saw that a similar thread was
already open.
I am using Marathon v. 1.6 with FB v. 1.
I want to re-create an old, simple, thoughly tested stored procedure.
The code is:
CREATE PROCEDURE NewN_ROW
RETURNS
(result integer)
as
begin
result=GEN_ID(N_ROW_GEN, 1);
end
N_ROW_GEN is a generator existing in my database
The only different point I can see is that this time I am using the
SQL editor of Marathon v. 1.6.
When I try to execute the SQL statement, Marathon says:
"unexpected end of command"
Adding a final colon won't produce different results.
Is there a bug in Marathon or I am doing some stupid error I cannot
see ?
TIA
Duilio Foschi