Hi,

> But I want to return the ID as output from stored procedure so that I
> can use it further in my program. How can I put the ID as output? Is
> the following correct?
>
> DECLARE VARIABLE ID INTEGER;
> BEGIN
> ID = GEN_ID("GEN_SESSION_ID",1);
> INSERT INTO
> PLANSESSIONS (SESSION_ID, SESSION_INFO )
> VALUES (:ID, :SESSIONINFO);
> INTO :SESSIONID
> SUSPEND;
> END

Use it like this :

CREATE PROCEDURE SP_INSERT_SESSION (SESSIONINFO VarChar(30)) returns
(SESSION_ID Integer) AS
DECLARE VARIABLE ID INTEGER;
BEGIN
ID = GEN_ID("GEN_SESSION_ID",1);
INSERT INTO
PLANSESSIONS (SESSION_ID, SESSION_INFO )
VALUES (:ID, :SESSIONINFO);
SESSION_ID = ID;
SUSPEND;
END

Regards,
Arno