In your stored procedure you have "SELECT prj.ROW_ID row_id, ...".
Shouldn't that be just "Select prj.row_id, ..." ?

Stan



CREATE PROCEDURE SP_GET_MY_PROJECTS
RETURNS (
O_ROW_ID INTEGER,
O_CREATED DATE,
O_LAST_UPD DATE,
O_PROJECTTYPE VARCHAR(30),
O_DESC_TEXT VARCHAR(10),
O_STAGE INTEGER,
O_CALCDATE INTEGER)
AS
begin
FOR
SELECT prj.ROW_ID row_id, prj.created,
prj.last_upd,
prj.projecttype, prj.desc_text, prj.stage, prj.calcdate
FROM E_PROJECT prj
into :o_ROW_ID, :o_created,
:o_last_upd,
:o_projecttype, :o_desc_text, :o_stage, :o_Calcdate
DO BEGIN
SUSPEND;
END
end