Re: [SQL] returning multiple values and ref cursors

2004-05-04 Thread Dennis
Dennis writes: 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? I guess another question here is whether I can return a row type or record type with (integer, varchar, refcursor) and then make use of the

[SQL] returning multiple values and ref cursors

2004-05-03 Thread Dennis
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 appro