One Row of Data Returned

Go Up to EXECUTE STATEMENT

EXECUTE STATEMENT <select-statement> INTO :<var> [, :<var> ..]

Argument	Description
<select-statement>	SQL statement returning one or no rows of data.
<var>	Valid procedure variable, the ":" is optional.

Example:

CREATE PROCEDURE EXEC_STMT_SINGLETON (TABLE_NAME VARCHAR(50))
 AS
 DECLARE VARIABLE MAXEMPNO INTEGER;
 BEGIN
 EXECUTE STATEMENT 'SELECT MAX(EMP_NO) FROM ' || TABLE_NAME INTO :MAXEMPNO;
 END