CREATE PROCEDURE GETROWSUM(ROWSUM OUT INT) IS CURSOR TOTAL_SUM IS SELECT SUM(I) FROM TEST; BEGIN ROWSUM := TOTAL_SUM; END GETROWSUM; /