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
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