No Rows or Data Returned

Go Up to EXECUTE STATEMENT

EXECUTE STATEMENT <statement>

Argument	Description
<statement>	A SQL statement returning no rows of data.

Examples:

CREATE PROCEDURE EXEC_STMT_NO_RET (proc_name varchar(20))
 AS
 DECLARE VARIABLE EMPNO INTEGER;
 DECLARE VARIABLE EXECSTMT VARCHAR(150);
 BEGIN
   SELECT MAX(EMP_NO) from EMPLOYEE into EMPNO;

EXECSTMT = 'EXECUTE PROCEDURE' || proc_name || '( ' || cast (EMPNO as varchar(10)) || ')';

EXECUTE STATEMENT EXECSTMT;

END