Calling a Select Procedure
To use a select procedure in place of a table or view name in an application, use the procedure name anywhere a table or view name is appropriate. Supply any input parameters required in a comma-delimited list in parentheses following the procedure name.
EXEC SQL SELECT PROJ_ID FROM GET_EMP_PROJ (:emp_no) ORDER BY PROJ_ID;
- Important: InterBase does not support creating a view by calling a select procedure.