returning multiple values and ref cursors - Mailing list pgsql-sql

From Dennis
Subject returning multiple values and ref cursors
Date
Msg-id courier.409683FD.000070AD@wolverine.lercnetworks.com
Whole thread Raw
Responses Re: returning multiple values and ref cursors
List pgsql-sql
hello, 

I am porting an Oracle stored procedure to plpgsql (pg 7.4.1) that has about 
ten ref cursor OUT parameters, a varchar OUT parameter and returns an 
integer. The varchar is an error/status message, the integer is a 1/0 for 
success/failure. 

What are your thoughts on the best way to approach this? Break up the stored 
proc into ten different stored procs that return ref cursors? 

Thanks, 

Dennis
dennis at calico dash consulting dot com 



pgsql-sql by date:

Previous
From: "H.J. Sanders"
Date:
Subject: start
Next
From: Peter Eisentraut
Date:
Subject: Re: start