I have create a store procedure named GET_IT , all thing samed right. (have
commited).
But I cant list the store prcedure name in the properity of storedprocname
in Tstroredproc.

the procedure is:

CREATE PROCEDURE GET_IT (EMP_NO SMALLINT)
RETURNS (PROJ_ID CHAR(5))
AS
BEGIN
  FOR SELECT PROJ_ID
  FROM EMPLOYEE_PROJECT
  WHERE EMP_NO = :EMP_NO
  INTO :PROJ_ID
  DO
    SUSPEND;
END

please help me out of trouble! thanks!