Joe,

Did you try running this script thru another tool? I know of someone
else who tried the new Marathon and was having problems with defining
SP's. FWIW, I was able to create this in a dialect 1 database with
Marathon v1.6.

Bob M..


At 5/27/2004 03:11 PM, joe_dh2003 wrote:

>Hi everyone,
>
>I'm having some troubles with a simple stored procedure to INSERT a
>row:
>-------------------------------------------------------------------
>CREATE PROCEDURE SP_I_COUNTRY (NAME VARCHAR(50)) RETURNS(ID BIGINT)
>AS
>BEGIN
> ID = GEN_ID(G_COUNTRY_ID,1);
> INSERT INTO COUNTRY VALUES(:ID,:NAME);
>END;
>-------------------------------------------------------------------
>
>If it matters, I'm running this script through the SQL editor in
>Marathon 3.0.0.22.
>
>When I run the script, it runs fine. But when I try to COMMIT the
>action, I get this error:
>
>-----------------------------------
>ISC ERROR CODE:335544343
>ISC ERROR MESSAGE:
>invalid request BLR at offset 102
>bad parameter number
>-----------------------------------