Stored procedure problems
I am trying to create stored procedure which will insert a row into a
table which has a serial column, and will return me the generated values
by using DBINFO. Any ideas why its not working (its returing a huge
negative number)?:
CREATE PROCEDURE sp_prov_srvc (p_sub_id INT, p_srvc_typ INT, p_ct_typ
INT)
RETURNING INT;
DEFINE r_last_serial INT;
INSERT INTO wasabi.v_srvc (sub_id, srvc_typ)
VALUES (p_sub_id, p_srvc_typ);
SELECT DBINFO ('sqlca.sqlerrd1'), COUNT (*)
INTO r_last_serial
FROM wasabi.v_srvc;
INSERT INTO wasabi.v_srvc_ct (srvc_id, srvc_typ, ct_typ)
VALUES (r_last_serial, p_srvc_typ, p_ct_typ);
RETURN r_last_serial;
END PROCEDURE;