how can we return a cursor from a procedure (SQL, pl/pgsql procedure).
this is to display the cursor output of a procedure in a Crystal report (ie records in the cursor). is there any other option to do the same?

Also how can we return more than one value (can we use an out parameter in parameter list).