I'm not sure I properly understand your question, but maybe this is what
you want to know:

There are several ways to return values from Ingres 2006 database
procedures (DBPs). First off, there's the RETURN statement, which
allows you to return a single integer value.  The second possibility is
to call the procedure and pass the arguments BYREF, and in the parameter
list indicate that each parameter is IN, OUT, or INOUT.  If a parameter
is OUT, or INOUT you can use it to retun a result as a side-effect.
Finally the third possibility is to return an entire row.  The procedure
must be declared as a row-producing procedure by specifying the row
structure with a RESULT ROW clause.  Multiple rows can be returned by
invoking the RETURN ROW statement repeatedly.

For details of all this, refer to
http://docs.ingres.com/sqlref/UnderstandingDatabaseProceduresSessionsandEvents#o1039