Call stored procedure with multi result set and out parameters

[pingrami]

Hi all, is it supported the call to stored procedure as show below? I tried some solutions without success. If it is supported could you provide me an example?

CREATE PROCEDURE MySPWithOutParams(InParamId INTEGER, OUT OutParam1 INTEGER, OUT OutParam2 VARCHAR(200))
BEGIN

SELECT id, description, completed FROM my_table_1 WHERE id = InParamId;

SELECT description, completed FROM  my_table_2;

SET OutParam1 = 1; 
SET OutParam2 = 'Hello World!';

END