> Hi,
>
> we have trouble with the following procedure:
>
> ALTER PROCEDURE INSERT_NEW_THEME (
> THM_NAME VARCHAR(128),
> CLASS_ID SMALLINT,
> OBJ_ID INTEGER,
> PARAM_ID INTEGER,
> USER_COUNT INTEGER)
> RETURNS (
> NEW_ID INTEGER)
> AS
> DECLARE VARIABLE NEW_UHI INTEGER;
> BEGIN
> new_id = gen_id (gen_thm_id, 1);
> INSERT INTO thm (id, name) values (:new_id, :thm_name);
>
> SELECT * FROM search_or_insert_rsp (:param_id, :user_count) INTO

:new_uhi;

>
> INSERT INTO guilt (thm_id, cls_id, obj_id) values (:new_id, :class_id,
> :obj_id);
> INSERT INTO guilt (thm_id, cls_id, obj_id) values (:new_id, 2,

:new_uhi);

>
> suspend;
> END

I don't believe a SUSPEND statement is needed here. This procedure isn't
returning a recordset, it's only inserting new records. The return value can
still be obtained without using SUSPEND.

Woody (TMW)

----------------------
"To invent, you need a good imagination and a pile of junk."
Thomas Edison