EF4 - stored procedure returns no columns

May 16, 2011 at 11:19 PM

The add function import dialog gets me the error:

The stored procedure returns no columns

when trying to import a stored procedure returning a result set. However using the datadmin tool or effiproz query tool, this

procedure returns me the columns.

CREATE PROCEDURE DBO.PRPEOPLELIST(IN POWNER VARCHAR(50))
SPECIFIC PRPEOPLELIST_128
LANGUAGE SQL
NOT DETERMINISTIC
READS SQL DATA
NEW SAVEPOINT LEVEL
BEGIN
SELECT ........... field values
FROM DBO.PERSON P
WHERE(P.OWNER=POWNER OR P.SHARED=1);
END

The same happens for other procedures returning result sets.