description: SET TERM ^ ;

CREATE PROCEDURE PSTRID
( IN_ID1 VARCHAR(100), IN_ID2 VARCHAR(100))
RETURNS
( ID1 VARCHAR(100), ID2 VARCHAR(100))
AS
BEGIN
ID1 = IN_ID1;
ID2 = IN_ID2;
SUSPEND;
END^

SET TERM ; ^

SELECT
*
FROM
RDB$RELATIONS R
INNER JOIN
(SELECT
*
FROM
RDB$RELATION_FIELDS F
INNER JOIN PSTRID(F.RDB$RELATION_NAME, F.RDB$FIELD_NAME) P ON P.ID1 = F.RDB$RELATION_NAME AND P.ID2 = F.RDB$FIELD_NAME ROWS 2) F2 ON R.RDB$RELATION_NAME = F2.RDB$RELATION_NAME

=>

SET TERM ^ ;

CREATE PROCEDURE PSTRID
( IN_ID1 VARCHAR(100), IN_ID2 VARCHAR(100))
RETURNS
( ID1 VARCHAR(100), ID2 VARCHAR(100))
AS
BEGIN
ID1 = IN_ID1;
ID2 = IN_ID2;
SUSPEND;
END^

SET TERM ; ^

SELECT
*
FROM
RDB$RELATIONS R
INNER JOIN PSTRID(R.RDB$RELATION_NAME, R.RDB$RELATION_NAME) P ON P.ID1 = R.RDB$RELATION_NAME AND P.ID2 = R.RDB$RELATION_NAME

summary: "no current record for fetch operation" when joining with stored procedure inside derived table => "no current record for fetch operation" when joining with stored procedure

description: SET TERM ^ ;

CREATE PROCEDURE PSTRID
( IN_ID1 VARCHAR(100), IN_ID2 VARCHAR(100))
RETURNS
( ID1 VARCHAR(100), ID2 VARCHAR(100))
AS
BEGIN
ID1 = IN_ID1;
ID2 = IN_ID2;
SUSPEND;
END^

SET TERM ; ^

SELECT
*
FROM
RDB$RELATIONS R
INNER JOIN PSTRID(R.RDB$RELATION_NAME, R.RDB$RELATION_NAME) P ON P.ID1 = R.RDB$RELATION_NAME AND P.ID2 = R.RDB$RELATION_NAME

=>

SET TERM ^ ;

CREATE PROCEDURE PSTRID1
( IN_ID1 VARCHAR(100))
RETURNS
( ID1 VARCHAR(100))
AS
BEGIN
ID1 = IN_ID1;
SUSPEND;
END^

SET TERM ; ^

--------------------------------------------------

SELECT
*
FROM
RDB$RELATIONS R
INNER JOIN PSTRID1(R.RDB$RELATION_NAME) P ON P.ID1 = R.RDB$RELATION_NAME

summary: "no current record for fetch operation" when joining with stored procedure => "no current record for fetch operation" when "INNER" joining with stored procedure

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Won't Fix [ 2 ]

status: Resolved [ 5 ] => Closed [ 6 ]